DB2 Load Problem

tommy.chen · #1 (**permalink**) 10-27-03, 05:15

Dear Experts

I am encountering a problem in DB2 load utility. The situation is that I am trying to load data from flat file to database. In case there is error, the log file display the location (row) of records that encountered error incorrectly.

Current database setting is partitioned into 2 partitions.

Is there any options/parameters to be set in order to rectify this?

sathyaram_s · #2 (**permalink**) 10-27-03, 05:28

Can you give an example, please ?

Cheers
Sathyaram

Quote:

Originally posted by tommy.chen
Dear Experts

I am encountering a problem in DB2 load utility. The situation is that I am trying to load data from flat file to database. In case there is error, the log file display the location (row) of records that encountered error incorrectly.

Current database setting is partitioned into 2 partitions.

Is there any options/parameters to be set in order to rectify this?

tommy.chen · #3 (**permalink**) 10-27-03, 22:14

Please refer to the attached Document file for the details
Thank you.

db2os390udbdba · #4 (**permalink**) 10-28-03, 18:35

load from filename of del MODIFIED BY COLDEL, DATEFORMAT="YYYY.MM.DD" replace/insert into table name

try this , let me know if any questions

Thank You

Raju Ennam

Internet Services

Web Development

Digital Marketing

Consumer Tech