Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    184

    Question Unanswered: DB2 IMPORT from ASC file fails using DATEFORMAT

    The input file has date as listed below:
    2014-06-28

    Use of dateformat=”YYYY-MM-DD” in the IMPORT command still fails with SQL3192N.

    db2 “import from input.asc of asc modified by dateformat=”YYYY-MM-DD” method L (1 10) insert into tdate(ttdate)”

    "SQL3192N In the filetmod a user specified format "DATEFORMAT" beginning with the string ”YYYY-MM-DD” is not valid."

    Am I missing something here?

    Thanks in advance.

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    db2 "import from input.asc of asc modified by dateformat=\"YYYY-MM-DD\" method L (1 10) insert into tdate(ttdate)"
    Regards,
    Mark.

  3. #3
    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    184
    Thanks a ton Mark!

    After including the escape character (\) before the double quotation it is working now!

    Thanks again!!

Posting Permissions

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