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.
KeyMgtGetNextVal for the same table in two separate jobs.
Moderators: chulett, rschirm, roy
Re: KeyMgtGetNextVal for the same table in two separate job
If you use the same key in the second job also then u shld get continued values. The second job key starts from the point where the First job key has ended.
Is this you what are looking for ?
Is this you what are looking for ?
Raju,
After more research, I found that I used this key function as a variable.
And I should not do this for the second job to insert into existing table.
I changed the logic and put it as derivation for primary key and this function does the job (continue incrementing sequence when it was left from previous job).
Thank you for respond and help.
After more research, I found that I used this key function as a variable.
And I should not do this for the second job to insert into existing table.
I changed the logic and put it as derivation for primary key and this function does the job (continue incrementing sequence when it was left from previous job).
Thank you for respond and help.