I use
exec SQL
VALUES IDENTITY_VAL_LOCAL() INTO :POFDRUG.DRUGID;
If that does not work make sure the identity column is defined like:
DrugID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY
(START WITH 1 INCREMENT BY 1 NO CYCLE),
I have had problems before if it is defined differently.
Chris
Rick.Chevalier@xxxxxxxxxxxxxxx 11/5/2008 10:57:19 AM >>>
I am looking at using an identity column as the primary key for one of the tables in a new process. When a record is added to the table using RPG I need to pass the identity column value off to another program via a data queue. My question is how do I know what value was assigned to the identity column for the added record?
I searched the archives and found references to the VALUES statement but the documentation says it can only be used in a trigger. Am I missing something?
Rick Chevalier
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 email transmission and any documents, files or previous
email messages attached to it may contain information that is
confidential or legally privileged. If you are not the intended
recipient, you are hereby notified that any disclosure, copying,
printing, distributing or use of this transmission is strictly
prohibited. If you have received this transmission in error,
please immediately notify the sender by telephone or return
email and delete the original transmission and its attachments
without reading or saving in any manner.
The Evangelical Lutheran Good Samaritan Society.
midrange.com
