IC89882: WHEN EXECUTING ARRAY INSERTS, THE STATUS FOR THE SUCCESSFUL INSERTS IS SET TO 4 INSTEAD OF SQL_PARAM_SUCCESS.

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 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