|
Problem IC70224
|
Status: Closed |
ERROR SQL30020N REPORTED WHEN STORED PROCEDURE ON Z/OS REFERENCI NG A INSENSTIVE SCROLLABLE CURSOR IN A SELECT QUERY IS CALLED |
| product: |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 |
| Problem description: |
When the stored procedure referencing a insensitive scrollable
cursor on zOS is called , the output may be incomplete and the
command line processor (CLP) client might report SQL30020N
error. The problem is seen when the size of
rows is large and zOS server returns the partial rowset in the
first buffer. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* none *
****************************************************************
* PROBLEM DESCRIPTION: *
* When the stored procedure referencing a insensitive *
* scrollable cursor on *
* zOS is called , the output may be incomplete and command *
* line processor (CLP) client *
* might report SQL30020N error. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v9.5 fp7, v9.7 fp4, or v9.8 fp3 *
**************************************************************** |
| Local Fix: |
N/A |
| Solution |
Problem Fixed |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.07.2010
23.06.2011
30.06.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP7,
9.8.FP3
|
| Problem solved according to the fixlist(s) of the following version(s) |
