APAR status
Closed as fixed if next.
Error description
You insert NROWS rows via ODBC using code similar to the following on a table with primary key: #define NROWS 3 INT aC1[NROWS] = {1,2,1}; /*the 3rd row is a duplicate of the 1st so it will fail */ SQLLEN cbC1[NROWS]; SQLUSMALLINT status[NROWS]; SQLPrepare(hstm,"insert into tab1 values (?)",SQL_NTS); SQLSetStmtAttr(hstm,SQL_ATTR_PARAMSET_SIZE, NROWS, 0); SQLBindParameter(hstm,1,SQL_PARAM_INPUT,SQL_C_SLONG,SQL_INTEGER, 0,0,aC1,0,&cbC1); SQLSetStmtAttr(hstm,SQL_ATTR_PARAM_STATUS_PTR,&status,SQL_IS_POI NTER); SQLExecute(hstm); which you run without setting "Enable insert cursors" in the ODBC control panel for your DSN. If you check the content of the status array for the example above, you will get these values (3rd insert is a duplicate): pos value 0 4 1 4 2 SQL_PARAM_ERROR (5) while you should get pos value 0 SQL_PARAM_SUCCESS (0) 1 SQL_PARAM_SUCCESS (0) 2 SQL_PARAM_ERROR (5)
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Array insert operation by using ODBC application * **************************************************************** * PROBLEM DESCRIPTION: * * Array insert operation by using ODBC application trying to * * check status of the inserted array elements may not see the * * status if there is a failure happening in between the * * insert. * **************************************************************** * RECOMMENDATION: * * The fix is in CSDK 3.70.xC8; please migrate the product to * * this version or higher. * ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
IC89882
Reported component name
IBM CSDK
Reported component ID
5724C2381
Reported release
370
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-01-28
Closed date
2014-02-26
Last modified date
2014-02-26
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
R370 PSN
UP
R370 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVRDE","label":"Informix Client Software Development Kit"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
26 February 2014