DSXchange

You data is fine. The numeric number before you date is just the internal format which is pulled up along with the date when ever you do view data. The main issue here is that you have a unique constraint issue. Check with you dba on which column has unique index on it and handle duplicates

Thats one heck of a job your developer has there

You might want to be careful with what option you choose. If the data size is relatively small, you could go with setting the transaction size to 0. But if its in millions, then go for the Bulk loader, else your temp space might run out on the database end.

Welcome Aboard
Apply DecimalToString(). Use Field() to get everything before the decimal and, concatenate the time and then use StringToTimestamp().

And I was just fooling around I guess

That will help. "IF" is out of question
This has to be done while creating your source file.

Check the table for unique index. It will tell you what column has unique index on it.

You have a unique index on one of the columns which has duplicates from your source. Handle them before loading them.
About the date part, I have no idea whats going on with your date. How is it coming in from the source?

ray.wurlod wrote:

Krazykoolrohit wrote:It just blows up when run with 12 other jobs parallely through sequence.

All trying to write to the same sequential file? Tch! Tch!

Thats a good one,

You can find a batch job at Kims Home Page. to do the same for you.

If its a flat file then the OP can make it a character field and then use the Field() function.

You are not giving any argument for RType. By default its trunc_zero and hence truncating everything after the decimal point. In DS Help type DecimalToDecimal, it will give you the help. Read over it and provide the correct RType.

Check your source data whether your data is really coming in decimal format. Or this time you got an integer?

I guess your hitting a limit somewhere. This is what IBM has to say about SQL 1652N. SQL1652N File I/O error occurred. Explanation: Error occurred either opening, reading, writing, or closing a file. User Response: Check the db2diag.log for details. Also, check for disk full conditions, file permiss...

I would say extract and check. Use Field() to extract month, then check length if 1, prefix it with zero. Do the same with day and year. You can do this in a stage variable. Then once the formatting is done in the stage variable, feed it to the StringToDate() function.