|
Problem IT15589
|
Status: Closed |
USE OF UNTYPED PARAMETER MARKER MIGHT FAIL IF DEFERRED PREPARE SEMANTICS IS ENABLED. |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
Use of untyped parameter marker might fail with SQL0418N
if all the following conditions are met.
- Deferred prepare semantics is enabled.
- The same prepared statement in the package is executed more
than once.
- Parameter marker is used in the prepared statement. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 10.5 Fix Pack 5 *
**************************************************************** |
| Local Fix: |
Consider casting the parameter marker(s) to prevent running into
the problem.
Try cleaning up the package cache if an application gets the
error, note that FLUSH PACKAGE CACHE statement does not ensure
the remove all the cache entries. |
| Solution |
First Fixed in DB2 10.5 Fix Pack 8 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 05.06.2016
09.05.2017
09.05.2017 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
