Re: Retrieving identity column value when adding a record

["Charles Wilt" <charles.wilt@xxxxxxxxx>]

Ah, but I'm not using VALUES

I'm using VALUES INTO.

Note that the SQL reference manual has two separate topics.

Charles

On Wed, Nov 5, 2008 at 2:10 PM, <Rick.Chevalier@xxxxxxxxxxxxxxx> wrote:

> 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.