VB.NET application tries to load CSV file into DB2 using SYSPROC.ADMIN_CMD, but any records are not loaded without any exceptions.
Dim sSQL As String = "CALL SYSPROC.ADMIN_CMD('LOAD FROM "D:\test\datafile" OF DEL INSERT INTO MYSCHEMA.MYTABLE')"
Dim myCmd As DB2Command = aConnection.CreateCommand()
Dim myTrans As DB2Transaction =aConnection.BeginTransaction()
myCmd.Transaction = myTrans
Codes shown above are something wrong?
How can I get diagnosis information?
Pinned topic DB2 Load command via ADMIN_CMD doesn't work from VB.NET application
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-01-17T02:38:19Z at 2012-01-17T02:38:19Z by SystemAdmin
SystemAdmin 110000D4XK1731 Posts
Re: DB2 Load command via ADMIN_CMD doesn't work from VB.NET application2012-01-17T02:38:19ZThis is the accepted answer. This is the accepted answer.i would try to call the admin_cmd procedure without parameters and see if i get an error
this way you can check if it was called at all