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.

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.