Re: Retrieving identity column value when adding a record

Thanks to everyone who replied.

I forgot to mention that we are at V5R4 so I can't get the value from an
insert statement.

I just want to clarify something. I saw Charles solution from the
archives. When I looked it up in the SQL reference manual it specifically
states the VALUES statement is only allowed in a trigger. I am not using a
trigger and doubt that will change. Is the manual wrong and the statement
can be used from a SQLRPGLE program?

From the V5R4 SQL reference manual:

VALUES

The VALUES statement provides a method for invoking a user-defined function
from a trigger. Transition variables can be passed to the user-defined
function.

Invocation
This statement can only be used in the triggered action of a CREATE TRIGGER
statement.


Rick

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Charles Wilt
Sent: Wednesday, November 05, 2008 11:18 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Retrieving identity column value when adding a record

Use:
VALUES IDENTITY_VAL_LOCAL() INTO :IVAR

HTH,
Charles

Privileged and Confidential. This e-mail, and any attachments there to, is
intended only for use by the addressee(s) named herein and may contain
privileged or confidential information. If you have received this e-mail in
error, please notify me immediately by a return e-mail and delete this
e-mail. You are hereby notified that any dissemination, distribution or
copying of this e-mail and/or any attachments thereto, is strictly
prohibited.
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.