DB2 - Problem description
Problem IT20799 | Status: Closed |
CLP NOT PROPAGATING SQLCA | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - 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: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Apply v10.5 Fixpack 10 to system running DB2 CLP which * * receives the SQL413 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
See LOCAL FIX | |
BUG-Tracking | |
forerunner : IT20683 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 30.05.2017 16.07.2018 16.07.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |