DSXchange

Hi,

When i use a DB2 Connector to load the data into DB2 using Bulk Load Option. I am getting a Information message saying
"The DB2 Load API call failed with SQLCODE 3,107"

I am unable to trace out what was the problem.

If anyone faced with the same issue kindly help me out.

Thanks.
Naveen

Is the database cataloged on your server?

The DB2 connector used a certain system table to detect if it was DB2 or UDB, I can't remember it off the top of my head, but it was present on DB2 and not there on UDB, so they tested that return code. BUT... should you not have access to the table on DB2, the process failed. A patch was created to resolve that issue.

What does your DB2 DBA have to say about that return code?

Hi naveen.p

SQLCODE 3107 means that there is at least one message in the message file - check it out and ask your DBA if you do not know what it means.

The message file is a option in the DB2 Connector.....

regards
MT