Surrogate Key Reset

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
dsean
Participant
Posts: 22
Joined: Thu Feb 09, 2006 12:52 pm

Surrogate Key Reset

Post by dsean »

Hi ,
Is there a way to reset the surrogate key sequence that is generated by SDK routines to starting point again once it is run? My opinion is that it is not possible to reet any sequence that is generated using SDK routines to zero.. Please advice. I did searched for it in the forums but did not find it.

Thanks in advance,
Sean
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

It's possible. Search for 'update sdksequences' to find out how to do it, it has been posted here a number of times.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
dsean
Participant
Posts: 22
Joined: Thu Feb 09, 2006 12:52 pm

Post by dsean »

got it. Thanks Chulett.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”