Load Date X(10) from flat file to DB2 table (DAte External)

shivsingla · New User Joined: 14 Jul 2006 Posts: 15 Location: New Delhi

Hi,

How to load date which is X(10) in a flat file into DB2 table field which is Date external. Date is like 29.05.2011 in flat file. I am using Load utility to load.

Getting Data type mismatch.

Thanks in anticipation.

Nic Clouston · Posted: Thu Jun 16, 2011 1:32 pm

DB2 dates are ccyy-mm-dd. You are trying to insert dd.mm.ccyy.

dbzTHEdinosauer · Posted: Thu Jun 16, 2011 2:06 pm

not knowing which utility your are using to load,
makes it really difficult to provide you with a solution.

suggest,
when you determine which utility you are using,
that you look at the manual and see if there are facilites within your load utility to cast.

if not, reformat the file (quick sort) or use a different utility.