My environment
DB2 9.1.4 on Sun OS
I write a C embedded SQL to load data.
I declare host vars as:
EXEC SQL BEGIN DECLARE SECTION;
SQL TYPE IS CLOB(599999) sqlStr;
EXEC SQL END DECLARE SECTION;
then set sqlStr and execute sqlStr as
sprintf(sqlStr.data, "%s, %d, %d, '%s')", staticStr, recId, seqno, data);
sqlStr.length = strlen(sqlStr.data);
EXEC SQL EXECUTE IMMEDIATE :sqlStr;
my staticStr contains table name, column names in run time and "data" can contains very long string. "data" is also inserted into a clob column in the table specified inside staticStr.
The compilation is OK but in execution I get this error:
EXECUTE IMMEDIATE ERROR: SQLCODE: -805 SQLSTATE 51002: The package corresponding to an SQL statement execution request
was not found.
Does this mean I am missing a DB2 library in during compilation ??
I check and -805 means "The DBRM or package name not found in plan"
What does this mean ????
Please help. Thanks