DSXchange

Do you have oracle client installed on your datastage server? If yes then you need to set ORACLE_HOME to point to it in the dsenv file presend in DSHOME directory.
DSHOME = cd `/.dshome`

What do you mean by dumm'ing a part of your job? Do you mean not run half your job and only execute the remaining half???

Reset (and not re-compile) the job. See if any additional messages pop up in the log, specifically that starts with, "From previous run ....". If yes, then post its, complete, contents here.

Well without warning messages its hard to tell whats going on. Make sure you are not sending any nulls to not null columns, all lengths are correct and no data mismatch, i.e, sending non-numeric characters to numeric fields etc. ON second thought, the lookup might be failing and hence all records ar...

In the sequential file stage, activate filter command and put the following in the filter command box

This will delete the last line before the stage even starts reading it.

Define unwanted data? What is the error message that you are getting?

Get rid of the reject file so that the error messages pop up in the log. Once you know the culprit, fix the error and then put the reject file back.

Try changing char to varchar. Do you have a reject link?

What have you tried so far? Did you look at StringToDate() function?

O comeon, that was funny, it could very well be the opening statement of SOAP convention

Any warning/error message?

I have never used them. You can try contacting support for a direct, confirmed answer.

There must be a key column in your file that contains the generated keys and the other file. Do a lookup on the keys. Or thats not the case? If not, then how do you want to attach the keys generated by one table with the other file?

Ans = Field(UnixOutput, @FM, 1)