sql - iSeries DB2 - Is there any way to select the identity value from an insert statement? - Stack
I am not sure of iSeries, but the following worked on db2v8.1: Consider 'ID' is the name of your identity column. The following stmt will return the newly generated id (the same one that gets inserted by the insert stmt): SELECT ID FROM FINAL TABLE ( INSE...