DSXchange

Hi, we have MQ read stage in datastage 8.1Px reading the data and passing to next stage with one column-A output. This works fine. Now, we would like to capture header of each message that comes in MQ to column-B along with column-A. Could you please tell me how to do this? Any MQ properties setting...

Thank you Eric, I have found that the issue was with the input data having special characters for one record.

It helped a lot. Thank you.

Hi, I have a datastage job with XMLoutputPX stage which has aborted with the below error in the job. Surpisring today in production after successfully running 30 days. I am unable to find the solution for this problem since it is not showing any stage name in the director but red lines coming for XM...

Hi,

A new grid queue has been created for the project with 2 new nodes. Can you please tell me how to configure this queue to my project and
run my parallel jobs ?

Your quick response is appreciated.

Thanks
lkganta

Hi, I have tried to use Merge stage as follows, but the output is coming as NULLs for other selected merge columns. ( I have Sort asc before the Merge stage) Input 1 C1 C2 C3 -------------- 1 a 10 2 b 20 Input 2 C1 C2 C4 ------------- 1 a 100 2 b 200 Input 3 C1 C2 C5 -------------- 1 a 1000 2 b 2000...

HI, Can some one help me to figure out the below CDC stage problem. I have a datastage job with CDC stage. Basically the CDC stage as two inputs which have exactly the same metadata. in the CDC stage I am excluding two columns on which the change should not be looked. Inputs have 10 columns in it. E...

Hi I have a DS sequence job which internally invokes 3 more jobs. I am able to run the sequence job from the DS-Designer fine. But when I tried to run it from the UNIX command line with help of 'dsjob' it gives me the below error. Error running job Status code = -14 DSJE_TIMEOUT I tried to find the ...

can some one help me here?

Hi, I am trying to implement the roundrobin collection from below datasets. Dataset1 ----------- 10 20 30 40 Dataset2 ---------- AA BB CC DD Dataset3 ------------ XX YY ZZ PP Expected OUTPUT ------------------ 10 AA XX 20 BB YY 30 CC ZZ 40 DD PP Can somebody help me to implement this with help of an...

Hi, My question is "Can I send my input to output as below fashion in the lookup stage then ? Input stream ----> Lookup Stage----> Link1 and Link2(Reject) Link1 --------- Matched Records (I have to set one column from reference as "1") + Reject records (I have set one column from refe...

I have created a job 7.5 Px with column generator stage for adding new column C20 to the main stream. But I need to assign a default value "0" to the newly added column. After that I have lookup stage with reject consition, can I pass some value to the new column C20(from lookup stage), If...

Thank you very much for the reply. If the previous values reaches Z then I need to put the value "AA" and then increment it to AB,AC,AD...etc
It is kind of implementing the recursion concept correct?



Thank you,

Hi, I have the situation where I need to increment my input value as per below in the datastage 7.5 PX INPUT ------ 1234 44346 656566 44346 656566 44346 44346 OUTPUT ---------- 1234 44346 656566 44346A 656566A 44346B 44346C Here I am adding the alphabet to the number incase it comes again by increme...

Thank you for the response; I am planning to use some other external script to verify these logs of the multi instance job. Incase I find some errors, I will stop the processing the next steps. So, is there any way to pass many invocation ids in parallel and execute one multi-instance job in PX ? Th...

Hi, I have implemented loop type logic (Start & End Loop stages) in my datastage sequencer job, which makes call to a multi-instance datastage job based on the loop counter value. But, I found that the loop is waiting until the multi-instance job is completed, for the passing the next value and ...