try SELECT IDENTITY_VAL_LOCAL() from sysibm.sysdummy1
- IDENTITY_VAL_LOCAL() returns 2 rows Tim Dudgeon
- Re: IDENTITY_VAL_LOCAL() returns 2 rows Barry Books
- Re: IDENTITY_VAL_LOCAL() returns 2 rows Tim Dudgeon
- Re: IDENTITY_VAL_LOCAL() returns 2 rows Dan Scott
- Re: IDENTITY_VAL_LOCAL() returns 2 rows Barry Books
