IZ52211: WITH CLI STATEMENT CHAINING ON, AFTER YOU SUCCESSFULLY INSERT ROWS, SQLROWCOUNT() WRONGLY INDICATES ZERO ROWS WERE INSERTED.

DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• In CLI (Call Level Interface) applications, after you begin CLI
  array input chaining
  by setting the statement attribute SQL_ATTR_CHAINING_BEGIN,
  then you insert rows using a statement whose parameter markers
  are bound with column-wise array input,
  when you then call SQLRowCount() it wrongly indicates that zero
  rows were inserted.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of CLI (Call Level Interface) applications with DB2    *
  * for Linux, UNIX and Windows                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * In CLI (Call Level Interface) applications, after you begin  *
  * CLI array input chaining by setting the statement attribute  *
  * SQL_ATTR_CHAINING_BEGIN, then you insert rows using a        *
  * statement whose parameter markers are bound with column-wise *
  * array input, when you then call SQLRowCount() it wrongly     *
  * indicates that zero rows were inserted.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * .                                                            *
  ****************************************************************
  

Problem conclusion

• Problem was first fixed in Version 9.5 Fix Pack 5.
  At a minimum, this fix should be applied on the client.
  

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:

  IC61359 IZ55353

Modules/Macros

• ENGN_CLI
  

Fix information

• Fixed component name

  DB2 CEE AIX

• Fixed component ID

  5765F3000

Applicable component levels

• R910 PSN

     UP

• R950 PSN

     UP