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] <mailto:stephane.[Email Address Removed]

DB2 & UDB email list listserv db2-l LazyDBA home page