Look into the IDENTITY_VAL_LOCAL function in the SQL reference manual.

Denis Dubeau
DBA
State of Washington - DSHS

-----Original Message-----
From: Stephane Paquette [mailto:stephane.[Email Address Removed] Wednesday, March 03, 2004 8:41 AM
To: [Email Address Removed] Sequences or identity


Hi,

How do you populate your surrogated keys, sequences or identity ?
(DB2 UDB 8.1/aix 5.2)

If using identity you have to query the data you just inserted to know the
value of the key as there is no returning clause in DB2.



TIA

Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 stephane.[Email Address Removed]


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: db2udbdba-[Email Address Removed] additional commands, e-mail: db2udbdba-[Email Address Removed]DB2 & UDB email list listserv db2-l LazyDBA home page