How to create batchID?

A_SUSHMA · Post by **A_SUSHMA** » Thu Apr 03, 2014 9:49 pm

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?

chulett · Post by **chulett** » Thu Apr 03, 2014 10:08 pm

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?

A_SUSHMA · Post by **A_SUSHMA** » Thu Apr 03, 2014 11:37 pm

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

ray.wurlod · Post by **ray.wurlod** » Fri Apr 04, 2014 12:10 am

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.

A_SUSHMA · Post by **A_SUSHMA** » Fri Apr 04, 2014 12:56 am

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

yousuff1710 · Post by **yousuff1710** » Fri Apr 04, 2014 1:18 am

Hi,

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

I hope it helps.

Thanks,
Yusuf

A_SUSHMA · Post by **A_SUSHMA** » Fri Apr 04, 2014 2:05 am

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

anbu · Post by **anbu** » Fri Apr 04, 2014 3:53 am

The routine argument is the name associated with the sequence.

ray.wurlod · Post by **ray.wurlod** » Fri Apr 04, 2014 3:54 am

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" ?

A_SUSHMA · Post by **A_SUSHMA** » Fri Apr 04, 2014 4:15 am

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

chulett · Post by **chulett** » Fri Apr 04, 2014 6:56 am

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