Search found 2 matches
- 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...
- 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
Do you have any idea How can we set the initial value for the Sequence using KeyMgtGetNextval?
Thanks and Regards,
Bhaskar