DSXchange

Hi All,

1.How to create the invocation Id(or) batch id through data stage sequence?
2.How to pass the sequence invocation id (or)batch id through data stage routine?

1. However you like. What do you want to control it - a database? Something within DataStage? For the latter, the simplest is probably to use the supplied "KeyMgtGetNextValue" routine.

2. Sorry, not really sure what you are asking. Can you clarify the question, please?

how to pass the "KeyMgtGetNextValue through datastage sequence as parameter?

Invoke it through a Routine activity and use the return value (activity variable $ReturnValue) to supply the value to the job parameter in a Job activity.

In routine activity it is asking routine name. Do I use a routine to generate a batch or invocation id?

Hi,

KeyMgtGetNextValue is a built-in routine available in datastage, you have to select this to make use.

I hope it helps.

Thanks,
Yusuf

Routine Activity is asking argument. What argument I need to pass?

The routine argument is the name associated with the sequence.

Any string, but one that should be meaningful. It becomes the name of the "sequence" that the routine uses to keep track of the next available batchID. How about "batchID" ?

How to generate a sequence a batchID or Invocation Number in Datastage server Routine.

Asked and answered. If you have a question that's a little more specific, please ask it but that one has already been covered.