do the keys generated start at the start value at every run of the job that uses the surrogate key stage?
or the next value after the last run's highest value?
djoni
surrogate key stage's start value
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
You can set the surrogate key start value to a job parameter and pass in the start value every time you run the job. The max value can be retrieved by the Sequence job by a shell execute script that runs SQL or isql or db2 commands.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn