×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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.
midrange.com
