what version you on?
I don't remember what version this was introduced on (thinking V7R1).
FROM FINAL TABLE(
INSERT INTO CNSOLGRPP
(RPGRPC, RPGRPD, RPSTAT)
VALUES(:W1GRPC, :W1GRPD, :W1STAT)
Or immediately after the insert get the identity_val_local .
INSERT INTO ORDRMAHP
(AHSTOR, AHSSFX, AHORD, AHTALY, AHRSTS,
VALUES(:OHSTOR, :OHSSFX, :OHBILL, 0, 'E',
SET :ReturnID = IDENTITY_VAL_LOCAL();
do a google search on IDENTITY_VAL_LOCAL to get an understanding of this
On Fri, Nov 9, 2012 at 11:14 AM, Scott Mildenberger <
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?
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,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives