DSXchange

Hi amsh, I feel that the big parallel job is better than splitting it into 2 or 3 smaller jobs. If you split the big job into smaller jobs and then run them in sequence, possibly using a job sequencer to achieve the same result. The overhead in initializing,starting,processing,writing the log and no...

Hi Vinay, Your question is not clear. I am suggesting three solutions based on different interpretations of your problem. 1) If you meant that your source file is having quotes and you want to read it - In format tab in the sequential file, make sure you put the quote character field to " and a...

Hi Me48,

I am sorry that I didnt check the website until now. I guess all your doubts have already been cleared by craig. If still you have any problems, let me know and I will be glad to help you out.

Thanks,
Naveen

Hi Heather,

This is what code -8 means

Equ DSJE.NOTINSTAGE To -8 ;* StageName was DSJ.ME and the caller is not running within a stage

There was a small error in the logic i mentioned above, Please use the below logic in your transformer

You can use the following logic in your transformer to get the desired result

If (Count(UPCASE(INPUTLINK.COLA),"REVERSAL")) > 0 Then (INPUTLINK.COLB = INPUTLINK.COLB * -1) Else INPUTLINK.COLB

Try it and let me know if it works for ya.

I have used this approach in server jobs, I am not sure whether this works for a parallel job, but you can give it a try. Without using any special stage, you can do it in a regular sequential file 1) On the input to the sequential file , you will have all your individual columns 2) On the output of...

Hi Reddy,

After your Link Partitioner stage, Are you writing the data subsets into seperate sequential files, before sending them as inputs into the Link Collector stage?

Hi Ray,

Thanks for the prompt reply to my post. The parameter had some null space embedded in the string. I removed the null space and it worked. Once again thanks for pointing me in the right direction.

Thanks,
Naveen

Hi Satish,

I believe you can use Wait-For-File-Activity stage in the job sequencer and wait for the file to appear in the designated directory. After the file appears, you can kick of a datastage job, which processes the input file according to your transformation rules.

Thanks,
Naveen

Hi Morris,

I believe that the parent/child relationship can be modelled in datastage using complex flat file stage. Dsx Gurus, please correct me, if I am wrong.

Hi Ray, I tried to implement the solution pointed out by you and I am getting an error. I have defined a job parameter called TestOutput and have populated it with the output value of $CommandOutput (actual value is "Execute_Command_0.$CommandOutput") The following is the log of the job ru...

Hi Ray,

Thanks for the detailed solution to my problem. I will follow your solution.

Thanks,
Naveen

Hi Duke,

I am using server jobs, so I guess I can not use filter stage. I will try the other options.

Thanks,
Naveen

What version of datastage are you using?. I am using version 7.5 and I see that option in the sequential file stage on the ouput -> properties tab. Maybe the DS gurus can tell us more.