DSXchange

Toldya, he is SuperMan.
Ray, for the hundreth time, let us in on the secret, please

add a -jobstatus with the dsjob command. Then it will return the status of the job its calling. 0 wont be successful anymore, you have to code for appropriate steps for different job status.

Ok, Ray has provided instructions in thispost on how to get the meaning of 'Fault Type Errors'.
As per your script, its not coded properly, the exit status of dsjob will be 0, its the jobstatus that you should be worried about. Are you checking that in your script ?

Ray is Superman

That means that the Jobs never ran. An error was encountered in the sequence itself.

Also you were asked to reset the job and not recompile. Re-run the job and see if the error persists. If it does, reset the job and see if any additional messages pop up in the log that might help us, specifically message saying "From previous run...()"

That means none of them ran. The error was in your Master sequence itself. Try diagnostic tests layed out by Kumar and post your finds.

Also you need to check what job caused an error which was picked up by the controling sequence.

I highly doubt the ticks will work surrounding wc-l. Just provide

Yes need much more info?
The Control Process, is it written in BASIC as a batch job?
What does the log of this batch job say?

Use DSExecute() to run OS level commands inside Basic code. Read about DSExecute() in DS help or search the forums.

kumar_s wrote:Different rows.

the values of columns at row 1 should be swapped with the values of columns at row 100.

Thank you Kumar. I should just shutup today. Sorry guys.

I must be missing something here. If the columns within a single row are to be re-arranged, no join is required. Just re-arrange them in the transformer. Right

Use the transformer, re-arrange the columns. No join is required in this case.

Kumar beat me to it.