Page 1 of 1

How to generate a sequence number in Datastage ?

Posted: Tue Jan 30, 2007 5:14 pm
by xinhuang66
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.

Posted: Tue Jan 30, 2007 6:03 pm
by ray.wurlod
Server or Parallel?

The answer is different depending on job type.

Please post in the correct forum.

Your question will be answered when it appears on the Server or Parallel forum.

Posted: Tue Jan 30, 2007 7:36 pm
by xinhuang66
I am so sorry about fail to put them in the right section..

Sorry again !