DSXchange

You Iconv function need to be changed.
Iconv(stgvar1,"D/MDY[2,2,4]")

Craig, I use to see some of your other posts as well where you insist not using User defined SQL. Will there be any performance improvement in using Bult in SQL or just for the sake of avoiding some generic errors?

It may be restriction of awk input argument that limited to 199.
Since $0 reads as whole line, you might not got it. Anyway whats is the error that you get?

So fine. Read the field as Char or varchar. Change the target to userdefined SQL, and modify your TO_DATE() function to fit this value. TO_DATE(Input.File,'MM/DD/YYYY HH24:MI:SS') If you dont want to touch the target for any chance (which is not resonable), convert the change the char field into req...

$0 returns the whole line. Where I guess, printf receives each word as argument and prints out. So the alignment might vary. But I dont think you get the work truncated.
Btw, where are you using this, and whats your effect of output?

If that is the case, and if you are using Generated SQL, check the TO_DATE() function build automatically. And make sure the output of your job refer to that format. To test, you can write the data to an intermediate sequential file and check the out format.

Not in transformer, but in the SQL used in Oracle stage.

User To_Date() function before loading it into Oracle. You need to make sure the date format is compatible with Oracle, rather than Datastage to get rid of this oracle error.

I guess you are using Auto partition in Remove Duplicate stage. It might be using the SAME partition, i.e., Sequential mode to operated. "
->eCollectAny"

As noted, what you see when you vi the file in Unix server.

Did you produced the output of the previous job in the same format as the current job's input? Does the metadata exactly matches? FieldDelimiter and Records Delimiter and all others?

Use "Oracle Enterprise" stage.

Use NullFieldValue to give some Defaults to Null value.
By keeping date field as Char with mm/dd/yyyy datatype, 10/01/1999 might come the first order before 01/01/2007 by lexical sorting. Check it out.

Do you mean to say, one wait till the other one finishes?

No option to export from server side.