Results 1 to 4 of 4
  1. #1
    Join Date
    May 2005
    Posts
    25

    Unanswered: Load utility log info problem

    Hi,

    I use the following code in UNIX to execute delimited flat file

    Code:
    db2 -x "load from 'abc' of del modified by coldel~ replace into a.emp" > a.log
    if any error happens i.e. data field size is less and is not able to store value from flat file or any other database related error it logs error like

    Code:
    SQL3107W  There is at least one warning message in the message file.
    How can I find out exact error occured while loading?

    Thanks.

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    chk load command options :
    [MESSAGES msg-file]
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  3. #3
    Join Date
    May 2005
    Posts
    25
    Thanks for your suggestion

    I gave like below, it thrown me error

    Code:
    db2 -x "load from 'abc' of del modified by coldel~ MESSAGES=a replace into a.emp" > a.log

    saying

    Code:
    SQL3016N  An unexpected keyword "MESSAGES=conn" was found in the filetmod
    parameter for the filetype.
    Let me know where do I insert MESSAGES in my snippet.

    Thanks.

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    MESSAGES=a --- Space between the words. No =
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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