RE: Retrieving identity column value when adding a record

[<Rick.Chevalier@xxxxxxxxxxxxxxx>]

Thanks Birgitta.  That's what I was missing.

Rick

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of BirgittaHauser
Sent: Wednesday, November 05, 2008 1:50 PM
To: 'RPG programming on the AS400 / iSeries'
Subject: AW: Retrieving identity column value when adding a record

Hi,

You need to distinguis between VALUES and VALUES INTO (what Charles used!)

Values into:
The values into statment produces a result table consiting of at most one row and assigns the values in that row to variables.

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!"

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.