Results 1 to 2 of 2

Thread: db2 load error

  1. #1
    Join Date
    Nov 2007
    Posts
    72

    Unanswered: db2 load error

    Hi ALL ,

    I am trying to load into a table here is the ddl of the table

    MSC_MERGE_FILE_TAB (
    FILENAME VARCHAR(2000),
    MEDIATION_TIMESTAMP TIMESTAMP,
    MSC_FILE_SEQ BIGINT,
    MSC_SWITCHNAME VARCHAR(500),
    RECORD_COUNT SMALLINT
    )

    and the command i am giving is
    db2 "load CLIENT from /home/dsadm/Datastage/Log/MSC_FILE_Stats.txt of del insert into MSC_MERGE_FILE_TAB

    But it is throwing one error SQL0180N The syntax of the string representation of a datetime value is incorrect. SQLSTATE=22007

    My file is having data as follows : 2010063000.00.08
    I want to insert data in this format into column MEDIATION_TIMESTAMP which if of datatype timestamp using load utility.
    Please suggest a way to insert this data into the specified table without changing the timestamp data format.

  2. #2
    Join Date
    Jan 2010
    Posts
    335
    load CLIENT from /home/dsadm/Datastage/Log/MSC_FILE_Stats.txt of del
    modified by timestampformat="YYYYMMDDHH.MM.SS"
    insert into MSC_MERGE_FILE_TAB

    LOAD
    The Modifiers are shown at the bottom of the statement.

Posting Permissions

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