Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC62811 Status: Closed

CLI ARRAY INPUT CHAIN RETURNS FUNCTION SEQUENCE ERROR CLI0125E

product:
DB2 CONNECT / DB2CONNCT / 950 - DB2
Problem description:
If a warning is returned when you prepare a statement within a 
CLI array input chain that you started with the function 
SQLSetStmtAttr() and its attribute SQL_ATTR_CHAINING_BEGIN, the 
call of the function SQLSetStmtAttr() with attribute 
SQL_ATTR_CHAINING_END incorrectly returns SQL_ERROR and the 
application gets error CLI0125E Function sequence. 
 
The reason for error CLI0125E: 
The call of the function SQLSetStmtAttr() with attribute 
SQL_ATTR_CHAINING_BEGIN will get a warning, and the function 
exits without completing processing of SQL_ATTR_CHAINING_BEGIN 
attribute. 
This cause error CLI0125E during call to SQLSetStmtAttr() with 
SQL_ATTR_CHAINING_END attribute.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 CLI applications                                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* If a warning is returned when you prepare a statement within * 
* a CLI array input chain that you started with the function   * 
* SQLSetStmtAttr() and its attribute SQL_ATTR_CHAINING_BEGIN,  * 
* the call of the function SQLSetStmtAttr() with attribute     * 
* SQL_ATTR_CHAINING_END incorrectly returns SQL_ERROR and the  * 
* application gets error CLI0125E Function sequence.           * 
*                                                              * 
* The reason for error CLI0125E:                               * 
* The call of the function SQLSetStmtAttr() with attribute     * 
* SQL_ATTR_CHAINING_BEGIN will get a warning, and the function * 
* exits without completing processing of                       * 
* SQL_ATTR_CHAINING_BEGIN attribute.                           * 
* This cause error CLI0125E during call to SQLSetStmtAttr()    * 
* with SQL_ATTR_CHAINING_END attribute.                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.5 FP6 or later.                             * 
****************************************************************
Local Fix:
available fix packs:
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

Solution
With DB2 9.5 FP6 thre is no error.
Workaround
N/A
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC62854 IC62855 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
27.08.2009
16.04.2010
16.12.2010
Problem solved at the following versions (IBM BugInfos)
9.5.FP6
Problem solved according to the fixlist(s) of the following version(s)