Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have output table for accepted values as well as file from tmap.
I want to add serial number column for the outputs. However, I don't want the serial number to start from 1 every time. I want it to start from the last serial number.
Eg if the max serial number is 100 then I want the serial number to start from 101 in the next run.
I tried using context variable and tjavarow but I am not able to get the desired output.
Please suggest me how to do this for both database output and file output delimited.
Hi
We usually store the max serial number to somewhere such as file or DB, load this value from file or DB in the beginning of job and store it to context variable for used in sequence function.
Regards
Shong