DSXchange

This will work in a parallel job as well. Just sort on the key and hash partition so that all identical keys end up in one partition.

If it is a fixed width file, you need to check for each and every one. As there are no nulls in a fixed width file. They are all character fields.

What is the exact error message that you are getting?

The Exception Handler does not accept any input links whereas the Terminator stage does. 1)Does that mean that we put the Exception Handler anywhere on the sequencer? Yes anywhere. When an exception occurs as explained, the control will be passed on to the exception handler, no matter where it is. ...

You can use the pivot stage. Read about the pivot stage to see how this can be accomplised. Since its dynamic, I would just write a shell script to do it.

Try running on a single node, just for debuggin purposes and see if the problem persists.

Why dont you think it will work again? Keep apending the values to the stage variable untill a key change is encountered. In that case reset the stage variable and start appending untill the next key change is encountered. Do this till the last record. Then pass the output to remove duplicate stage ...

I need to Backtrack recent salary Effective date. Emplid EffDate Salary Monthly 1234 02-02-2001 3000 1234 01-12-2006 4000 1234 01-01-2007 4000 1234 01-02-2007 4000 In Above sistuation recent salary Effectivity date as 01-12-2006. The way I am looking at it, you are, infact, getting the date when th...

Stick in a semicolon at the end of the command. Also try with call instead of exec.

Welcome Aboard
You have posted the in wrong forum. This question is Enterprise Edition specific and hence needs to go to that forum.
You cannot view datasets via unix commands. You need to use the DataSet Management Utility in the DataStage Director, under "tools".

"%yyyy%mm%dd" is the conversion mask/code. Did you use that with DateToString()? From your previous post, it does not look like you used it.

Did you give the conversion mask?

I am a little confused. When you say you need the "backtrack date", do you mean the date that particular salary first came in effect? If thats the case, pass your data through an aggregator, group by EmpId and Salary and get the min(Eff_Dt). This will bring you to different salaries for a particular...

Are you using it as a Transform procedure? Use it as an "extract" procedure.

A small correction. Its "%mm/%dd/%yyyy %hh:%nn:%ss (without any space in the time mask.)