How to generate a sequence number in Datastage ?
Posted: Tue Jan 30, 2007 5:14 pm
There is an API routine KeyMgtGetNextValue, which can help us to generate a sequence number ..
Do you guys usually use it to generated sequence number ?
by the way, If I don't want to start from 0, for example I want to start from a certain point like 1000000. Does KeyMgtGetNextValue can help me ?
Or the only way is to write my personal routine ...
Thanks.
Do you guys usually use it to generated sequence number ?
by the way, If I don't want to start from 0, for example I want to start from a certain point like 1000000. Does KeyMgtGetNextValue can help me ?
Or the only way is to write my personal routine ...
Thanks.