|
Problem IC62430
|
Status: Geschlossen |
SQLROWCOUNT() RETURNS AN ESTIMATED ROW NUMBER FOR PREPARE STATEMENT |
| Produkt: |
DB2 CONNECT / DB2CONNCT / 970 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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 |
| verfügbare FixPacks: |
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
|
| Lösung |
With DB2 9.7 FP1, SQLRowCount() returns -1 for SELECT
statement. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 07.08.2009
24.02.2010
24.02.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.,
9.7.FP1
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.1
|
 |
