Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Unanswered: DB2 Load Problem

    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?

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: DB2 Load Problem

    Can you give an example, please ?

    Cheers
    Sathyaram

    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?
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Oct 2003
    Posts
    2

    Re: DB2 Load Problem

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

  4. #4
    Join Date
    Oct 2003
    Posts
    8

    Re: DB2 Load Problem

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •