Search found 2 matches

by Vemireddy_Sasi
Thu Jul 12, 2007 8:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Surrogate Key Assignment
Replies: 16
Views: 24899

More of a 'reset' than a 'set', per se, but perhaps it will help: UPDATE SDKSequences USING DICT VOC SET F1 = '?' WHERE @ID = 'YourSequenceName'; YourSequenceName is the 'key' to reset. ? is the value to reset it to. Thank you very much for your quick response .Still how can i update the SDKSequenc...
by Vemireddy_Sasi
Wed Jul 11, 2007 11:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Surrogate Key Assignment
Replies: 16
Views: 24899

Re: Surrogate Key Assignment

Hi Ram,

Do you have any idea How can we set the initial value for the Sequence using KeyMgtGetNextval?

Thanks and Regards,
Bhaskar