RE: Update a single record using SQL

This doesn't sound like an RPG question, so I've cross-posted my response to
midrange-l. Responses should probably go there.

To be effective with this, we would need to know more about your data, and
your OS version et cetera. Maybe describe the table involved, what you're
trying to achieve, and what you've tried.

Having said that, if your release level SQL includes RRN, you should be able
to do something like (untested), which will work only if SEQNBR is unique:

CREATE TABLE QTEMP/TEMPTABLE AS (SELECT SEQNBR FROM MYTABLE ORDER BY SEQNBR)
WITH DATA ;
UPDATE MYTABLE A SET SEQNBR = (select rrn(TEMPTABLE) * 10 FROM
QTEMP/tempTABLE B WHERE A.SEQNBR = B.SEQNBR) ;

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"We must believe in luck. For how else can we explain the success of those
we don't like?"

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
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.