Generate Sequence

[shrey3a]

Hi,

I've a Scenario where I need to know the maximum number of sequnce number and then insert the new rows starting +1 of max sequenc number.

I've made a job in which I stored the max number of sequence in the has h file by:

SELECT MAX(USER_ID) FROM TFT_HR

Now In my second job I'm using the same hash file value and storing max value in stage variable 'SeqA' and defining another variable SeqB = SeqA +1 but I'm not getting the desired o/p . suppose the max number is 4325 and my result is value '4326' in all the column , I need the number to be incremented for each column.

Thanks in Advance.

Regards

[chulett]

SeqA + @INROWNUM

[ray.wurlod]

Do you really mean for each column? Or each row?

If "each row" then Craig's solution, and yours (if in stage variables), will work.
Otherwise, you need a separate stage variable for each column, and one that updates the driver stage variable by the number of columns in the row.