KeyMgtGetNextVal for the same table in two separate jobs.
Posted: Wed Jan 21, 2004 2:54 pm
Hi, All!
I loaded information into the table(created rows). For unique sequence I used KeyMgtGetNextVal function. In a future, I would have to add some new rows from different file(output) as an input to the table.
In this case, how would I use KeyMgtGetNextVal to continue sequence number where it was left.
It should metter for relationship with other tables as FK.
Maybe somehow I can update previous ran job? Is it possible?
Thanks.
I loaded information into the table(created rows). For unique sequence I used KeyMgtGetNextVal function. In a future, I would have to add some new rows from different file(output) as an input to the table.
In this case, how would I use KeyMgtGetNextVal to continue sequence number where it was left.
It should metter for relationship with other tables as FK.
Maybe somehow I can update previous ran job? Is it possible?
Thanks.