I need a way to create a sequence number using SQL. I have a table that contains about 4000 entries. There is a colum called ARSEQ# that is currently set to zero (0). I would like to create an SQL statement to populate the SEQ column.
These are the steps I have taken so far:
/* clear the sequence # */
update arfile
set ARSEQ# = 0
Then I would like to update the sequence number:
update arfile
set ARSEQ# = <something that will generate a number>
Anyone know how I can do this without having to create an RPG program?
These are the steps I have taken so far:
/* clear the sequence # */
update arfile
set ARSEQ# = 0
Then I would like to update the sequence number:
update arfile
set ARSEQ# = <something that will generate a number>
Anyone know how I can do this without having to create an RPG program?
Comment