Re: SQL how to get Generated Always value on Insert

what version you on?

I don't remember what version this was introduced on (thinking V7R1).

Exec SQL
SELECT RPID
INTO :GroupID
FROM FINAL TABLE(
INSERT INTO CNSOLGRPP
(RPGRPC, RPGRPD, RPSTAT)
VALUES(:W1GRPC, :W1GRPD, :W1STAT)
);

Or immediately after the insert get the identity_val_local .

Exec SQL
INSERT INTO ORDRMAHP
(AHSTOR, AHSSFX, AHORD, AHTALY, AHRSTS,
AHMUSR, AHMPGM)
VALUES(:OHSTOR, :OHSSFX, :OHBILL, 0, 'E',
:User, :Proc_Name);
Exec SQL
SET :ReturnID = IDENTITY_VAL_LOCAL();

do a google search on IDENTITY_VAL_LOCAL to get an understanding of this
value.


On Fri, Nov 9, 2012 at 11:14 AM, Scott Mildenberger <
SMildenberger@xxxxxxxxxxxxxxxxxx> wrote:

I have a auto-generated field in a table defined as

ARCHIVENUM INTEGER GENERATED ALWAYS AS IDENTITY primary key NOT NULL,

When I do an Insert on the table is there a way to get the new generated
value without having to do a Select on that record?

Thanks,

Scott Mildenberger
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.