DB2 - Problem description
| Problem IT10012 | Status: Closed |
SQLCODE -302 IS RETURNED DURING STATIC SQL EXECUTION INSTEAD OF BIND/REBIND | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
| Problem description: | |
Binding or rebinding a static application should detect invalid host variable information (such as a DECIMAL with precision 0) and return SQLCODE -302. In some circumstances, the invalid host variable information may not be detected at bind/rebind, and is recorded in the section. This results in SQLCODE -302 at execution time instead. | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 10.5 fix pack 7 * **************************************************************** | |
| Local Fix: | |
Ensure host variable information is valid | |
| Solution | |
First fixed in DB2 version 10.5 fix pack 7 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.07.2015 20.01.2016 20.01.2016 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 10.5.0.7 |
|