Re: update column with a sequential #

[Booth Martin <booth@xxxxxxxxxxxx>]

The sequencing number does not need to start over at 1 with every change 
in key, right?  It just needs to be higher than any number already in 
the file.  So pick some absurdly high number and add 1 to that number 
and use that for the update.



On 4/30/2013 5:13 PM, Stone, Joel wrote:
> No significance to number.
>
> Just doing a regression test between a file updated with the current prod version of a pgm and a modified version of same pgm.
>
> Need to force the seq# field to 1,2,3,4, etc so it is the same between files, and it is a unique key so I cant simply clear it out.
>
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Roger Harman
> Sent: Tuesday, April 30, 2013 5:10 PM
> To: 'Midrange Systems Technical Discussion'
> Subject: RE: update column with a sequential #
>
> Any significance to the number?
>
> I had to do something similar a long time ago.  RGZPFM to get rid of deleted
> records and then just used the RRN as the value for my update.
>
> How do you plan to maintain it going forward?
>
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Stone, Joel
> Sent: Tuesday, April 30, 2013 3:01 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: SQL: update column with a sequential #
>
> Is it possible to update a column with a sequential # ?
>
> So that for this particular column, each row has a value 1 higher than the
> prior row?
>
> Something like
>
> UPDATE filename set SEQCOL to prior SEQCOL + 1
>
> (This is a DDS created file that does NOT have an identity column.)
>
> Thanks!