Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2007
    Location
    Bratislava, Slovakia
    Posts
    85

    Unanswered: return cursor datatype

    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
    Beer contains just a small amount of vitamines - that's why it's necessary to drink lot of it.

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Feb 2007
    Location
    Bratislava, Slovakia
    Posts
    85
    guyprzytula:
    thanks, but this is for 9x ... and 8.2.3 have another fields...
    can i select this from any catalog view ?
    Beer contains just a small amount of vitamines - that's why it's necessary to drink lot of it.

  4. #4
    Join Date
    Jun 2006
    Posts
    471
    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
    Last edited by guyprzytula; 06-04-07 at 11:07.
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  5. #5
    Join Date
    Feb 2007
    Location
    Bratislava, Slovakia
    Posts
    85
    guyprzytula:
    thanks, i saw this page.
    my problem was wrong number of output variables.
    thanks for help again.
    Beer contains just a small amount of vitamines - that's why it's necessary to drink lot of it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •