AW: SQL how to get Generated Always value on Insert

["Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>]

BTW IDENTITY_VAL_LOCAL will also return the generated identity value if the
record was written with native I/O.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Anderson, Kurt
Gesendet: Friday, 09.11 2012 17:59
An: Midrange Systems Technical Discussion
Betreff: RE: SQL how to get Generated Always value on Insert

Thanks for asking this question, Scott.  I was doing a write and then a
chain.  Now I don't have to do that anymore.

-Kurt

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Scott Mildenberger
Sent: Friday, November 09, 2012 10:15 AM
To: Midrange Systems Technical Discussion
Subject: SQL how to get Generated Always value on Insert

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.

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