IC84568: SQLSETSTMTATTR WITH SQL_ATTR_CHAINING_END INCORRECTLY RETURNS SUCCESS

DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• If you have an application that is using CLI array input
  chaining and at least one statement in the chain of statements
  returned SQL_ERROR or SQL_SUCCESS_WITH INFO, SQL_SUCCESS is
  incorrectly returned when settiing SQL_ATTR_CHAINING_END
  
  
  To reproduce :
  
  quickc 1 1 sample db2inst1 db2inst1
  sqlallocstmt 1
  sqlexecdirect 1 "drop table test" -3
  sqlexecdirect 1 "create table test (c1 smallint, c2 char(2))" -3
  sqlprepare 1 "insert into test values (?, ?)" -3
  getmemarray 1 1 10 sql_c_long
  getmemarray 1 2 10 sql_c_char 3
  
  
  sqlsetstmtattr 1 SQL_ATTR_CHAINING_BEGIN 1
  
  
  sqlbindparameter 1 1 sql_param_input sql_c_long sql_integer 0 0
  1 memarray
  sqlbindparameter 1 2 sql_param_input sql_c_char sql_char 2 0 2
  memarray
  
  updateelem 1 -1 value 32761
  updateelem 2 -1 value 2 "ch"
  sqlexecute 1
  
  sqlbindparameter 1 1 sql_param_input sql_c_long sql_integer 0 0
  1 memarray
  sqlbindparameter 1 2 sql_param_input sql_c_char sql_char 2 0 2
  memarray
  
  updateelem 1 -1 value 32768
  updateelem 2 -1 value 2 "ch"
  sqlexecute 1
  
  sqlsetstmtattr 1 SQL_ATTR_CHAINING_END 1
  sqlrowcount 1
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * CLI users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 10.1 FP1 or later                             *
  ****************************************************************
  

Problem conclusion

• The problem is first fixed in DB2 10.1 FP1
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  IC82056

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 CONNECT

• Fixed component ID

  DB2CONNCT

Applicable component levels

• R970 PSY

     UP

• RA10 PSY

     UP