DBIF_RSQL_SQL_ERROR

KAMES12 — Wed, 13 Nov 2013 03:08:32 GMT

Using a third party tool we are copying data between two systems both are Unicode. RFC is set up as Non Unicode.

While updating the data its giving us short dump

Runtime Errors DBIF_RSQL_SQL_ERROR

Except. CX_SY_OPEN_SQL_DB

SQL error "-804" when accessing table

What happened?

Error Text of the Database: "SQL0804N The application program parameters for

the current request are not valid. Reason code "106". If a host variable or

SQLVAR in the SQLDA is invalid then: host variable/SQLVAR number = "23",

SQLTYPE = "485", SQLLEN = "1282", host variable/SQLVAR"

How to correct the error

Internal call code.........: "[RSQL/INSR/

any suggestions ?

Re: DBIF_RSQL_SQL_ERROR

Former Member — Wed, 13 Nov 2013 13:58:14 GMT

Hello Aman,

perhaps it would be useful to see the whole dump here.

From the attached error message I see only that you have a DB2 database.

"SQL0804N" SQL error "-804" Reason code "106

"The SQLDATA pointer is invalid or points to insufficient storage."

br, Endre.