|
Problem IC62430
|
Status: Closed |
SQLROWCOUNT() RETURNS AN ESTIMATED ROW NUMBER FOR PREPARE STATEMENT |
| product: |
DB2 CONNECT / DB2CONNCT / 970 - DB2 |
| Problem description: |
After executing a PREPARE statement, SQLERRD3 will contain the
prepared statement's estimated cardinality. For SELECT
statements, this value is the estimated number of records
returned. If DB2 has to reprepare at execute(e.g. bind option
reopt(always)), the sqlca flows at sqlexecute. SQLRowCount()
returns this sqlca(estimated number of records) for select
statement instead of -1 or exact number of rows in some cases |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* SQLRowCoun() after SELECT statements prepared. *
****************************************************************
* PROBLEM DESCRIPTION: *
* After executing a PREPARE statement, SQLERRD3 will contain *
* the prepared statement's estimated cardinality. For SELECT *
* statements, this value is the estimated number of records *
* returned. If DB2 has to reprepare at execute(e.g. bind *
* option reopt(always)), the sqlca flows at sqlexecute. *
* SQLRowCount() returns this sqlca(estimated number of *
* records) for select statement instead of -1 or exact number *
* of rows in some cases *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 9.7 F1 orlater. *
**************************************************************** |
| Local Fix: |
N/A |
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
With DB2 9.7 FP1, SQLRowCount() returns -1 for SELECT
statement. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 07.08.2009
24.02.2010
24.02.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.,
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
