DSXchange

I dont think that exists in a parallel job.
For a sequential file you can have an after job subroutine to rename your output file suffixed with date. If you want date in the table then you will have to pass it as a parameter from outside the job before it even starts.

Yes. By just exporting job and routine executables.

Your kidding me right

Sweet.

Ok. cd to the DSEngine. Check for execute permission on dsenv. See if you have it. If not then you need it. Once you get it. Try running the same command again.

You have to execute the script just like I showed you. Did you copy paste the command. Dont put ksh or sh before it. Just copy paste it as it is.
There is a dot, space, dot and then the fullyqualified path. Try that first.

How did you select? By just doing a " Select DATECOLUM from table "? This will give you only the date format that has been masked in your sql tool. Provide the following SELECT TO_CHAR(DATECOLUMN, 'YYYY-MM-DD 24HH:MI:SS') FROM Table Now you will see the complete timestamp. As per your other ...

What happens when you execute the following?

I did. I did that yesterday itself when you first posted it. Pretty interesting stuff. Thanks for the link Ken.

Hmm, great. Hey Craig, I did'nt know you were a windoze guy too

Processor affinity huh, did not know about that. Is it only restricted to AIX boxes or all unix platforms?
I think this answers the OP's question. Seperate id's, seperate cpu's.

Increase the length. What is the numeric value you are expecting from the stored procedure? An arithmatic overflow, in a nutshell, means that the number produced is larger than what can occupy in the variable and hence my apprehension about the length.

I am sure you can. Make copies of your input using copy stage and let them go to all your tables. Truncate it and then load.

What is the error that you got when you applied my method? Are you sure that your incoming empty column is infact NULL and not an empty space?

What is the datatype that you have defined for your RETURN value in your other job? Is it the same in your new job?