DSXchange

DecimalToDecimal should work. you have some option in Modify stage as well. I dont have access to DS right now to get you the right info. But you can optionally convert it to char and trim the 0's it if required and convert it back to decimal.

Give another chance thorugh safe mode.

Hope you are not getting confused with the new line character seen through a special text editior.

You can also map it in series, tranformer-->DB-Delete-->transformer-->DB-Insert.

If it is fixed width, whats the point having delimiter, or the vise versa?
Can you give some example.

Alright, I was carried away with "sqlldr failure".

It is something like a path for the shell to be called, you can use it in command field as well. But you can always check with the echo #parameter# in the command field.
And look at the director log to ensure the parameter value is getting utilized.

This is to Monitor your row count. To turn it on, you have the variables in Datastage Admisntrator client.
Something like, DISABLE_JOBMON under monitor. Set it to true. Some other relevent parameters are APT_MONITOR_TIME and APT_MONITOR_SIZE.

Pls dont hijack the thread, Create a new post for this purpose.

Each job will create its own BASIC code, but still you have set of hashed files, where it acts as a common repository for the metadata of datastage. Where the guys who answere above in your post were very much expert in extracting the required data from it. Generally it is not suggested.

Sort-Merge-Transformer combination will also work.

So Sort based on "Key" as well as "date2", but "date2" in reverse order.

If you are using the same, it shouldnt be a problem unless some of link is been accessed some where. First make sure the Datastage services are not running. Then try to uninstall from control pannel.
Also give a search for 'Ascential' or 'Datgastage' in Registry and clean it up if required.

Were you able to view the data?

Is this the only warning?