DB2 - Problem description
Problem IT20683 | Status: Closed |
CLP NOT PROPAGATING SQLCA | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
When DB2 CLP receives an error, the SQLCA should contain the error. In the example below, SQL0413 fails to be returned to SQLCA. db2 -a "call TEST2(?,?,?)" Value of output parameters -------------------------- Parameter Name : OUT_SQLCODE Parameter Value : - Parameter Name : OUT_SQLSTATE Parameter Value : - Parameter Name : OUT_MESSAGE_TEXT Parameter Value : - Result set 1 -------------- COL1_ID 2 ----------- -------------------- 1 9223372036854775807 SQL0413N Overflow occurred during numeric data type conversion. SQLSTATE=22003 Return Status = 0 SQLCA Information sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0 sqlerrmc: sqlerrp : SQL10057 sqlerrd : (1) 0 (2) 0 (3) -1 (4) 0 (5) 0 (6) 0 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: 00000 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DB2 CLP * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Apply v11.1 M3 Fixpack 3 to DB2 Server * **************************************************************** | |
Local Fix: | |
available fix packs: | |
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows | |
Solution | |
First fixed in v11.1 M3 Fixpack 3. | |
Workaround | |
See LOCAL FIX. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 19.05.2017 15.03.2018 15.03.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |