DSXchange

Hi,
My input file date format is of type eg:17-May-2008.The database I am using is DB2 and its date format is yyyy-mm-dd.Can I have a solution for loading this type of input file format in terms of DB2 date?


Thanks in Advance
Kiran.

If you are using the data type of "Date" and correctly convert in the source string into that format then you should have no worries when writing that to DB2.

Thank you..In fact,my input file timestamp is 11-May-2008 22:21:00.So I have customized the timestamp format to %dd-%mmm-%yyyy and I got the timestamp output which is compatible to DB2.Previously Iam using varchar data type to load this format and hence I have a problem.

Thanks for your suggestions
Kiran