Hi all....
Does DB2 UDb uses the clause 'IF EXISTS....ELSE' ????

For eg I want to check whether a record with particular ID exists in the table.If it exists then update the remaining fields else insert a new record.
The below query does not work:

IF EXISTS (SELECT 'X' FROM T1 WHERE ID = 1) UPDATE T1 SET NAME = 'MMM' ELSE INSERT INTO T1 (ID,NAME) VALUES (1,'MMM')

I tried the query UPDATE T1 SET NAME = 'MMM' WHERE EXISTS (SELECT 'X' FROM T1 WHERE ID = 1)....This query works fine but again I want the 'ELSE' part.....

In core...How can I use the update query with conditional exists clause??????



Thanks in advance,
Madhuri.

I think you should be able to accompolish this using a MERGE Statement, assuming you are on V8.1.2 atleast

I don´t know where you´ll run this statement but I guess you could try to use the CASE..WHEN..THEN clause.

CASE WHEN (<OPTION>) THEN UPDATE..
ELSE INSERT..
END CASE

You can find more about this statement at the SQL Reference

You might want to consider SQL/DB2 merge statement:

DB2 Database for Linux, UNIX, and Windows

you are getting a lot of "I guess" and "might" answers, because you did not tell us what the "ELSE" you want done is. If you could explain fully what you are wanting to do, you will indubitably get a more concrete answer.
Dave Nance