home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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)