RE: Update a single record using SQL

Bob,

Look up SQL sequence in the SQL reference manual. There is a special SQL object implemented for sequences that might help you out. I was researching how to do a similar thing recently and was looking seriously at using it. The requirement got dropped so I didn't get to after all.

Rick

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Bob Bledsoe
Sent: Wednesday, June 16, 2010 10:44 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Update a single record using SQL

I am trying to update a series of records in a file using SQL. The records are in groups that are the same except for a sequence number field. If try to do an Update it puts the same number in all the records. What i want to do is re-sequence the sequence number. I would appreciate any help I can get. Thanks

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.