How to generate a sequence number in Datastage ?

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
xinhuang66
Participant
Posts: 161
Joined: Wed Aug 02, 2006 4:30 am

How to generate a sequence number in Datastage ?

Post 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.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post 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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
xinhuang66
Participant
Posts: 161
Joined: Wed Aug 02, 2006 4:30 am

Post by xinhuang66 »

I am so sorry about fail to put them in the right section..

Sorry again !
Post Reply