RE: Get Auto Increment Values After SQL Insert in the same command

Assuming your column is an identity column, you can use the
IDENTITY_VAL_LOCAL SQL scalar functions to return the value.

Best wishes,

Richard

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Dr. Stefano Mirenda
Sent: 26 July 2010 15:47
To: rpg400-l@xxxxxxxxxxxx
Subject: Get Auto Increment Values After SQL Insert in the same command

Good moorning to everyone.
My question is :
Is possible retrieve the value of an auto increment field generated after an
INSERT SQL in the same command ?

I need something like INSERT INTO TSTTABLE VALUES (DEFAULT) RETURNING ID;

Where ID is the value of the auto genereted file .

Thanks to all .

Stefano