Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2007
    Posts
    47

    Unanswered: SQL3125W truncation question

    On Windows 9.5. For this error


    SQL3125W The character data in row "F10-1" and column "12" was truncated
    because the data is longer than the target database column.

    SQL3125W The character data in row "F0-2" and column "12" was truncated
    because the data is longer than the target database column.

    SQL3125W The character data in row "F6-1" and column "12" was truncated
    because the data is longer than the target database column.

    etc..

    This is a somewhat big file that is being loaded.

    What is row F10-1 etc..?

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    The LOAD utility partitions the input file to enable parallel processing. F10-1 means row 1 in partition 11. If you are not in a DPF environment, specify CPU_PARALLELISM 1 to disable partitioning, then F0-1 will refer to the first row in the input file. In a DPF environment you would need to use MODE PARTITION_ONLY to save the partitioned input files, then use LOAD_ONLY; the errors will reference the input file on each partition.

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    You should also see this warning message:
    IBM DB2 9.5 Information Center for Linux, UNIX, and Windows

Posting Permissions

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