Re: IDENTITY_VAL_LOCAL() returns 2 rows

[Tim Dudgeon]

Barry Books wrote:
try SELECT IDENTITY_VAL_LOCAL() from sysibm.sysdummy1

Its get more weird!
SELECT IDENTITY_VAL_LOCAL() from sysibm.sysdummy1
returns 1 row


SELECT IDENTITY_VAL_LOCAL() from the_actual_table_name
returns as many rows as there are in the table, all with the value of 
the last ID.

Tim