- This topic has 1 reply, 1 voice, and was last updated 13 years, 4 months ago by .
I am invoking a DB2 (OS/390) stored procedure that is returning a field defined as:
[odbc SQLBindParameter $hstmt $bind_num SQL_PARAM_OUTPUT SQL_C_VARCHAR SQL_VARCHAR 800 0 pdsntiar 800 NULL]
Upon return from invoking the Stored Procedure I am getting the following error:
[DataDirect][ODBC DB2 Wire Protocol driver]Invalid character value. Error in parameter 35
Parameter 35 is the parameter defined above.
The DBA says there is a 2 byte binary length (for 800 the maximum length of the and no actual data which he claims is the way DB2 (Mainframe) sends VARCHAR data.
The definition of the parmameter in the COBOL program on the mainframe is VARCHAR.
I am guessing the binary value is being treated as data and I need to bind my parameter differently. The DBA is of little help – just says ‘maybe DataDirect is no good – this works with JDBC’.
Anybody have any suggestion?
- The forum ‘Cloverleaf’ is closed to new topics and replies.