DSXchange

Look into surrogate key generator.

Use convert.

Where do you want to run this routine? In a sequence job or inside a parallel job?
If former then you can use wait for file activity stage and set the time to 00:00:00.
If latter then you need to write a C routine to do this, how good are your C skills?

So you want to split your file into four files, one for each zone, yes?
On what basis do you want do get the average age?

Can you post the exact error message? Also reset the job and see if any additional messages pop up in the log file, specifically "From previous run.."

1)Copy_pre_xform: Error when checking operator: When binding output schema variable "outRec": When binding output interface field "INVOICE_CREATION_DATE" to field "INVOICE_CREATION_DATE": No default type conversion from type "string[max=38]" to type "timestamp". You need to change varchar to timest...

No such thing. Recover the job from backup.

Well, dont know if its going to work or not. You will have to find out yourself or wait until someone, who has actually tried it, drops in a line or two.
A piece of advice, dont develop code on an unsupported environment. Keep it real from the very begining.

In that case, I highly doubt its possible with db2. In oracle, the OCI stage provides "Transaction grouping" which allows you to do that. But I highly doubt DB2 API stage supports that. Why do you want to do this? Cant you create one load ready file and then in seperate job(s) update the tables? As ...

Did you try the IBM site that lists out the supported platforms in a matrix?

Craig has explained "The oracle timestamp phenomenon" so many times. Please search the archives.
Also, what happens if you pass it as it is. The format you are showing is what oracle expects. No formatting might be required.

In datastage, jobstatus 1 (Finished) and 2 (finished with warnings) is considered successful and hence the behaviour.

Sure. Send two links down to two different database stages. Specify the link ordering. Also specify the transaction size to 1.
Or I got your requirement wrong ???

Why dont you test it out and let us know.

I found this post where Ray explains the ownership of datastage.