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.