DSXchange

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

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

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

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

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?

Hi,
I tried to search for pxReplace. But, I didn't find exact link. If possible can you share the link...

Thank you Chulett...

Can I get sample routines in any site?

Hi All,

How do I create Routines in DataStage? Previously I haven't created any DataStage routines..

Could you please guide me ?

Hi All,

I have two jobs,In this I need to execute second job from First job. Means to Execute one job from other job.

Please explain me how can i do in datastage...

Hi All,

what is Control table in data stage and how it works ?

If possible Please explain me with example..

Hi,

DBAmount Valcode
{100, 200, 300) 1
{200, 200, 500) 3
{100, 400, 300) 2

output

based on the valcode position I need to take the DBAmount.If value code is 1 then first postion in the array that is 100.DBAmount datatype is Number(7,2)

Output
100
500
400

Hi CHullet,

Source is Oracle I need to drag single column(array) to target table...

Hi All, Db_Amount{3} In a table i have a column called Db_Amount{3} array 3 .It have the value of {100, 200, 300) I mean the aomunt may be in array{1}, {2} , {3} for the column Db_Amount. I want to populate this column to target file with addition of the arry values. I mean I need the below output. ...

I am asking how to reset the KeyMgtGetNextValue to ZERO, Once the process completed...

Each time I need to reject a record or the record is bypassed then audit table is incremented. I am using the Routine KeyMgtGetNextValue .I will call this function each time when the record is by passed or reject.once the process completed successfully.Next day when I want to run the process I want ...