|
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
bounces@xxxxxxxxxxxx] On Behalf Of Dennis Lovelady
Sent: Thursday, June 17, 2010 4:43 AM
To: 'RPG programming on the IBM i / System i'; 'Midrange Systems
Technical Discussion'
Subject: 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. TheIf
records
are in groups that are the same except for a sequence number field.
trywant
to do an Update it puts the same number in all the records. What i
to
do is re-sequence the sequence number. I would appreciate any help I
can
get. Thanks
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.