Hi,

I have DB2 UDB 7.2 workgroup edition on windows 2000 advanced server. I have applied Fixpack 5.
My VB6 program which reads data from a file and inserts that data in the database fails giving following error -
[IBM][CLI Driver][DB2/NT] SQL0727N An error occurred during implicit system action type "2". Information returned for the error includes SQLCODE "-7", SQLSTATE "42601" and message tokens "{|365' ,'0159422365' ,". SQLSTATE=56098, Returned from SQLEXECUTE

Insert statement is as follows-
INSERT INTO db2admin.TblUserFuncs (CUSTOMERID,USERCODE,UPDATEDATE,UPDATEDBY,VERIFIED
DATE,VERIFIEDBY,APPLCODE,FUNCTIONCODE,SUBFUNCTIONC
ODE) VALUES('0159422365' ,'0159422365' ,{ts '2002-02-21 16:55:06.555555'} ,'USERLOAD',{ts '2002-02-21 16:55:06.555555'},'USERLOAD',? ,? ,? )

But strange thing is that only first record gives error and subsequent records get inserted without any problems.

The same program works fine with same database when I use DB2 client 7.1 Enterprise edition.

Please help me here.


Thanks,
Deepali.