Hi all,
please where i can find out datatypes of cursor, which returns stored procedure?
procedure in question is sysproc.reorgchk_ix_stats, database is LUW 8.2.3, win version
thanks

have a look at online infocenter
http://publib.boulder.ibm.com/infoce...c/r0011871.htm

guyprzytula:
thanks, but this is for 9x ... and 8.2.3 have another fields...
can i select this from any catalog view ?

the result set for V8 is not defined in detail, but these are the fields
The result set returned by this procedure includes the following information:

* TABLE_SCHEMA
* TABLE_NAME
* INDEX_SCHEMA
* INDEX_NAME
* CARD (cardinality, or number of rows in the base table)
* NLEAF (total number of index leaf pages)
* NUM_EMPTY_LEAFS (number of pseudo-empty index leaf pages)
* NLEVELS (number of index levels)
* ISIZE (index size)
* NUMRIDS_DELETED (number of pseudo-deleted RIDs)
* FULLKEYCARD (number of unique index entries that are not marked 7 deleted)
* F4 (F4 formula value)
* F5 (F5 formula value)
* F6 (F6 formula value)
* F7 (F7 formula value)
* F8 (F8 formula value)
* REORG (a 5-character field, each character mapping to one of the five formulas: F4, F5, F6, F7, and F3; a dash means that the formula value is in the recommended range; an asterisk means that the formula value is out of the recommended range, indicating a need for reorganization)

the catalog should return the real datatype and definition

guyprzytula:
thanks, i saw this page.
my problem was wrong number of output variables.
thanks for help again.