Hi Sy,

If you look at the METHOD L clause of the LOAD statement, you'll see
that the 6th column is expected to be of 26 characters length (from
172 to 197). That's exactly the length of the TIMESTAMP datatype (for
example, "2003-01-01-00.00.00.000000"). On the other hand, you're
saying that it contains "2003-06-26" for the DATE column.

Since I don't know your table structure, I don't know whether the
problem is in the OracleCatalog_JAMESD2_NB_CONTACTDETAILS.out file, or
in NB_CONTACTDETAILS DB2 table, but they should be aligned.

I used extensively IBM Migration ToolKit, and I think it's still in
Beta phase for the Oracle->DB2 conversion, so it may be not perfect.

I'll be glad to assist you to fix this and other problems related to
your migration project.

Best Regards,

Dmitry Balin

***********************************************
OCP, MCP, IBM Certified Solutions Expert
DB Best Technologies LLC - Principal Colsultant
Database Migration is Our Expertise
web: www.dbbest.com
email: dmitry@dbbest.com
tel: (408)202-4567
***********************************************



sy.phan@aiaa.com.au (sy phan) wrote in message news:<515b8514.0307201558.17d4b3ea@posting.google. com>...
> Hi all,
>
> I used IBM Migration ToolKit to do the migration and got problem with
> converting a date to a date. DB2 tables are created as I wanted but
> there is no data because of error SQL3405N. The log is as below.
>
> LOAD CLIENT FROM C:\MTK_ora\projects\Test_jamesd2\DataOutScripts\Or acleCatalog_JAMESD2_NB_CONTACTDETAILS.out
> of ASC MODIFIED BY reclen=500 striptblanks METHOD L(1 68,70 137,139
> 143,145 149,151 170,172 197,199 216,218 247,249 278,280 299,301
> 317,319 327,329 330,332 351,353 372,374 393,395 414,416 465) NULL
> INDICATORS (0,468,470,472,474,476,478,480,482,484,486,488,490 ,492,494,496,498,500)
> INSERT INTO NB_CONTACTDETAILS
>
> SQL3501W The table space(s) in which the table resides will not be
> placed in
> backup pending state since forward recovery is disabled for the
> database.
>
> SQL3109N The utility is beginning to load data from file
> "C:\MTK_ora\projects\Test_jamesd2\DataOutScripts\O racleCatalog_JAMESD2_".
>
> SQL3500W The utility is beginning the "LOAD" phase at time
> "07-21-2003
> 09:32:03.082378".
>
> SQL3405N The beginning-ending location pair for inserting into column
> "6" is
> not valid for a date.
>
> Number of rows read = 0
> Number of rows skipped = 0
> Number of rows loaded = 0
> Number of rows rejected = 0
> Number of rows deleted = 0
> Number of rows committed = 0
>
> How should this problem be fixed?
> I check the out file, it contains "2003-06-26" for the date column.
>
> Thanks

Whenever you have problems with the MTK send a note to
mtk@us.ibm.com
These guys have a very fast turnaround to improve/fix especially while in
beta-mode.

Cheers
Serge