Letzten Wert Identitätsspalte zurückliefern per Stored Procedure

[Fuerchau]

Wie wärs damit?

SET Meas_Head_ID = IDENTITY_VAL_LOCAL();

DECLARE C1 CURSOR WITH RETURN TO CLIENT FOR Select Meas_Head_ID MEAS_VALUE_ID FROM SYSIBM.SYSDUMMY1;