IF EXISTS . . ?

[woyler]

Hello all,
Is there a DB2 syntax for the following type of query(not in a stored procedure)?

IF EXISTS (SELECT x FROM table WHERE something = "this")
UPDATE table SET ............
ELSE
INSERT INTO table ...........

thanks in advance,
Bill

 

[blom0344]

Nope (AFAIK), this is not an SQL query, but should be part of a stored procedure..

Ties Blom
Information analyst

 

[gregsimpson]

woyler,

I think you're after an SQL Merge, or "UPSERT" statement. Try the following link to see if it does what you require.

http://www.databasejournal.com/features/db2/print.php/10896_3322041_2

Cheers
Greg

 

[juliane26]

MERGE exists in V8:

http://publib.boulder.ibm.com/infoc...topic=/com.ibm.db2.udb.doc/admin/r0010873.htm

It is brand new and came with SQL2003(?) standard

Juliane