home *** CD-ROM | disk | FTP | other *** search
/ OS/2 Shareware BBS: 29 Fixes_o / 29-Fixes_o.zip / wr07012.zip / wr07012.PKZ / QRW3COU.bnd (.txt) < prev    next >
DB2 Bind  |  1993-07-14  |  48KB  |  341 lines
  1. QRW3E3A02AdWPOHJNULLID  0
  2. BEGIN DECLARE SECTION
  3. END DECLARE SECTION
  4. DECLARE SCgauCur CURSOR FOR        SELECT CREATOR   , REMARKS        FROM   SYSIBM.SYSTABLES        WHERE  CREATOR        LIKE :H_AUTHID
  5. OPEN SCgauCur
  6. FETCH SCgauCur INTO :H_AUTHID, :H_COMM:H_COMMIND
  7. CLOSE SCgauCur
  8. DECLARE SCgtaCur CURSOR FOR        SELECT NAME, KEYCOLUMNS, REMARKS        FROM   SYSIBM.SYSTABLES        WHERE  CREATOR           = :H_AUTHID          AND  TYPE              = :H_SORT          AND  NAME           LIKE :H_NAME          AND  NAME              <> 'QRWSYS_OBJECT'        ORDER BY NAME
  9. OPEN SCgtaCur
  10. FETCH SCgtaCur INTO :H_NAME, :H_KEYCOLS:H_NULLIND, :H_COMM:H_COMMIND
  11. CLOSE SCgtaCur
  12. DECLARE SCgtagrpCur CURSOR FOR        SELECT DISTINCT TTNAME, TABAUTH, KEYCOLUMNS, REMARKS        FROM   SYSIBM.SYSTABAUTH, SYSIBM.SYSTABLES        WHERE  TTNAME = NAME          AND  CREATOR           = :H_AUTHID          AND  TCREATOR          = :H_AUTHID          AND  (     GRANTEE     = :H_GRP1                 OR  GRANTEE     = :H_GRP2                 OR  GRANTEE     = :H_GRP3                 OR  GRANTEE     = :H_GRP4                 OR  GRANTEE     = :H_GRP5                 OR  GRANTEE     = :H_GRP6                 OR  GRANTEE     = :H_GRP7                 OR  GRANTEE     = :H_GRP8                 OR  GRANTEE     = :H_GRP9                 OR  GRANTEE     = :H_GRP10                 OR  GRANTEE     = :H_GRP11                 OR  GRANTEE     = :H_GRP12                 OR  GRANTEE     = :H_GRP13                 OR  GRANTEE     = :H_GRP14                 OR  GRANTEE     = :H_GRP15                 OR  GRANTEE     = :H_GRP16                 OR  GRANTEE     = :H_GRP17                 OR  GRANTEE     = :H_GRP18                 OR  GRANTEE     = :H_GRP19                 OR  GRANTEE     = :H_GRP20  )          AND  TYPE              = :H_SORT          AND  NAME           LIKE :H_NAME          AND  NAME              <> 'QRWSYS_OBJECT'      ORDER BY TTNAME
  13. OPEN SCgtagrpCur
  14. FETCH SCgtagrpCur INTO :H_NDXN, :H_CNO, :H_KEYSEQ:H_CLEN, :H_TEMP:H_CPAGE
  15. CLOSE SCgtagrpCur
  16. y&DECLARE SCgtalgCur CURSOR FOR        SELECT DISTINCT TTNAME, TABAUTH, KEYCOLUMNS, REMARKS        FROM   SYSIBM.SYSTABAUTH, SYSIBM.SYSTABLES        WHERE  TTNAME = NAME          AND  CREATOR           = :H_AUTHID          AND  TCREATOR          = :H_AUTHID          AND  GRANTEE IN (:H_GRP1,                           :H_GRP2,                           :H_GRP3,                           :H_GRP4,                           :H_GRP5,                           :H_GRP6,                           :H_GRP7,                           :H_GRP8,                           :H_GRP9,                           :H_GRP10,                           :H_GRP11,                           :H_GRP12,                           :H_GRP13,                           :H_GRP14,                           :H_GRP15,                           :H_GRP16,                           :H_GRP17,                           :H_GRP18,                           :H_GRP19,                           :H_GRP20,                           :H_GRP21,                           :H_GRP22,                           :H_GRP23,                           :H_GRP24,                           :H_GRP25,                           :H_GRP26,                           :H_GRP27,                           :H_GRP28,                           :H_GRP29,                           :H_GRP30,                           :H_GRP31,                           :H_GRP32,                           :H_GRP33,                           :H_GRP34,                           :H_GRP35,                           :H_GRP36,                           :H_GRP37,                           :H_GRP38,                           :H_GRP39,                           :H_GRP40,                           :H_GRP41,                           :H_GRP42,                           :H_GRP43,                           :H_GRP44,                           :H_GRP45,                           :H_GRP46,                           :H_GRP47,                           :H_GRP48,                           :H_GRP49,                           :H_GRP50,                           :H_GRP51,                           :H_GRP52,                           :H_GRP53,                           :H_GRP54,                           :H_GRP55,                           :H_GRP56,                           :H_GRP57,                           :H_GRP58,                           :H_GRP59,                           :H_GRP60,                           :H_GRP61,                           :H_GRP62,                           :H_GRP63,                           :H_GRP64,                           :H_GRP65,                           :H_GRP66,                           :H_GRP67,                           :H_GRP68,                           :H_GRP69,                           :H_GRP70,                           :H_GRP71,                           :H_GRP72,                           :H_GRP73,                           :H_GRP74,                           :H_GRP75,                           :H_GRP76,                           :H_GRP77,                           :H_GRP78,                           :H_GRP79,                           :H_GRP80,                           :H_GRP81,                           :H_GRP82,                           :H_GRP83,                           :H_GRP84,                           :H_GRP85,                           :H_GRP86,                           :H_GRP87,                           :H_GRP88,                           :H_GRP89,                           :H_GRP90,                           :H_GRP91,                           :H_GRP92,                           :H_GRP93,                           :H_GRP94,                           :H_GRP95,                           :H_GRP96,                           :H_GRP97,                           :H_GRP98,                           :H_GRP99,                           :H_GRP100,                           :H_GRP101,                           :H_GRP102,                           :H_GRP103,                           :H_GRP104,                           :H_GRP105,                           :H_GRP106,                           :H_GRP107,                           :H_GRP108,                           :H_GRP109,                           :H_GRP110,                           :H_GRP111,                           :H_GRP112,                           :H_GRP113,                           :H_GRP114,                           :H_GRP115,                           :H_GRP116,                           :H_GRP117,                           :H_GRP118,                           :H_GRP119,                           :H_GRP120,                           :H_GRP121,                           :H_GRP122,                           :H_GRP123,                           :H_GRP124,                           :H_GRP125,                           :H_GRP126,                           :H_GRP127,                           :H_GRP128,                           :H_GRP129,                           :H_GRP130,                           :H_GRP131,                           :H_GRP132,                           :H_GRP133,                           :H_GRP134,                           :H_GRP135,                           :H_GRP136,                           :H_GRP137,                           :H_GRP138,                           :H_GRP139,                           :H_GRP140,                           :H_GRP141,                           :H_GRP142,                           :H_GRP143,                           :H_GRP144,                           :H_GRP145,                           :H_GRP146,                           :H_GRP147,                           :H_GRP148,                           :H_GRP149,                           :H_GRP150,                           :H_GRP151,                           :H_GRP152,                           :H_GRP153,                           :H_GRP154,                           :H_GRP155,                           :H_GRP156,                           :H_GRP157,                           :H_GRP158,                           :H_GRP159,                           :H_GRP160,                           :H_GRP161,                           :H_GRP162,                           :H_GRP163,                           :H_GRP164,                           :H_GRP165,                           :H_GRP166,                           :H_GRP167,                           :H_GRP168,                           :H_GRP169,                           :H_GRP170,                           :H_GRP171,                           :H_GRP172,                           :H_GRP173,                           :H_GRP174,                           :H_GRP175,                           :H_GRP176,                           :H_GRP177,                           :H_GRP178,                           :H_GRP179,                           :H_GRP180,                           :H_GRP181,                           :H_GRP182,                           :H_GRP183,                           :H_GRP184,                           :H_GRP185,                           :H_GRP186,                           :H_GRP187,                           :H_GRP188,                           :H_GRP189,                           :H_GRP190,                           :H_GRP191,                           :H_GRP192,                           :H_GRP193,                           :H_GRP194,                           :H_GRP195,                           :H_GRP196,                           :H_GRP197,                           :H_GRP198,                           :H_GRP199,                           :H_GRP200,                           :H_GRP201,                           :H_GRP202,                           :H_GRP203,                           :H_GRP204,                           :H_GRP205,                           :H_GRP206,                           :H_GRP207,                           :H_GRP208,                           :H_GRP209,                           :H_GRP210,                           :H_GRP211,                           :H_GRP212,                           :H_GRP213,                           :H_GRP214,                           :H_GRP215,                           :H_GRP216,                           :H_GRP217,                           :H_GRP218,                           :H_GRP219,                           :H_GRP220,                           :H_GRP221,                           :H_GRP222,                           :H_GRP223,                           :H_GRP224,                           :H_GRP225,                           :H_GRP226,                           :H_GRP227,                           :H_GRP228,                           :H_GRP229,                           :H_GRP230,                           :H_GRP231,                           :H_GRP232,                           :H_GRP233,                           :H_GRP234,                           :H_GRP235,                           :H_GRP236,                           :H_GRP237,                           :H_GRP238,                           :H_GRP239,                           :H_GRP240,                           :H_GRP241,                           :H_GRP242,                           :H_GRP243,                           :H_GRP244,                           :H_GRP245,                           :H_GRP246,                           :H_GRP247,                           :H_GRP248,                           :H_GRP249,                           :H_GRP250,                           :H_GRP251,                           :H_GRP252,                           :H_GRP253,                           :H_GRP254,                           :H_GRP255,                           :H_GRP256,                           :H_GRP257,                           :H_GRP258)          AND  TYPE              = :H_SORT          AND  NAME           LIKE :H_NAME          AND  NAME              <> 'QRWSYS_OBJECT'      ORDER BY TTNAME
  17. OPEN SCgtalgCur
  18. FETCH SCgtalgCur INTO :H_NDXN, :H_CNO, :H_KEYSEQ:H_CLEN, :H_TEMP:H_CPAGE
  19. CLOSE SCgtalgCur
  20. DECLARE SCgviCur CURSOR FOR        SELECT NAME, REMARKS        FROM   SYSIBM.SYSTABLES        WHERE  CREATOR           = :H_AUTHID          AND  TYPE              = :H_SORT          AND  NAME           LIKE :H_NAME      ORDER BY NAME
  21. OPEN SCgviCur
  22. FETCH SCgviCur INTO :H_NAME, :H_COMM:H_COMMIND
  23. CLOSE SCgviCur
  24. DECLARE SCgvigrpCur CURSOR FOR        SELECT DISTINCT TTNAME, TABAUTH, REMARKS        FROM   SYSIBM.SYSTABAUTH, SYSIBM.SYSTABLES        WHERE  TTNAME = NAME          AND  CREATOR           = :H_AUTHID          AND  TCREATOR          = :H_AUTHID          AND  (     GRANTEE     = :H_GRP1                 OR  GRANTEE     = :H_GRP2                 OR  GRANTEE     = :H_GRP3                 OR  GRANTEE     = :H_GRP4                 OR  GRANTEE     = :H_GRP5                 OR  GRANTEE     = :H_GRP6                 OR  GRANTEE     = :H_GRP7                 OR  GRANTEE     = :H_GRP8                 OR  GRANTEE     = :H_GRP9                 OR  GRANTEE     = :H_GRP10                 OR  GRANTEE     = :H_GRP11                 OR  GRANTEE     = :H_GRP12                 OR  GRANTEE     = :H_GRP13                 OR  GRANTEE     = :H_GRP14                 OR  GRANTEE     = :H_GRP15                 OR  GRANTEE     = :H_GRP16                 OR  GRANTEE     = :H_GRP17                 OR  GRANTEE     = :H_GRP18                 OR  GRANTEE     = :H_GRP19                 OR  GRANTEE     = :H_GRP20  )          AND  TYPE              = :H_SORT          AND  NAME           LIKE :H_NAME      ORDER BY TTNAME
  25. OPEN SCgvigrpCur
  26. FETCH SCgvigrpCur INTO :H_NDXN, :H_CNO, :H_TEMP:H_CPAGE
  27. CLOSE SCgvigrpCur
  28. :&DECLARE SCgvilgCur CURSOR FOR        SELECT DISTINCT TTNAME, TABAUTH, REMARKS        FROM   SYSIBM.SYSTABAUTH, SYSIBM.SYSTABLES        WHERE  TTNAME = NAME          AND  CREATOR           = :H_AUTHID          AND  TCREATOR          = :H_AUTHID          AND  GRANTEE IN (:H_GRP1,                           :H_GRP2,                           :H_GRP3,                           :H_GRP4,                           :H_GRP5,                           :H_GRP6,                           :H_GRP7,                           :H_GRP8,                           :H_GRP9,                           :H_GRP10,                           :H_GRP11,                           :H_GRP12,                           :H_GRP13,                           :H_GRP14,                           :H_GRP15,                           :H_GRP16,                           :H_GRP17,                           :H_GRP18,                           :H_GRP19,                           :H_GRP20,                           :H_GRP21,                           :H_GRP22,                           :H_GRP23,                           :H_GRP24,                           :H_GRP25,                           :H_GRP26,                           :H_GRP27,                           :H_GRP28,                           :H_GRP29,                           :H_GRP30,                           :H_GRP31,                           :H_GRP32,                           :H_GRP33,                           :H_GRP34,                           :H_GRP35,                           :H_GRP36,                           :H_GRP37,                           :H_GRP38,                           :H_GRP39,                           :H_GRP40,                           :H_GRP41,                           :H_GRP42,                           :H_GRP43,                           :H_GRP44,                           :H_GRP45,                           :H_GRP46,                           :H_GRP47,                           :H_GRP48,                           :H_GRP49,                           :H_GRP50,                           :H_GRP51,                           :H_GRP52,                           :H_GRP53,                           :H_GRP54,                           :H_GRP55,                           :H_GRP56,                           :H_GRP57,                           :H_GRP58,                           :H_GRP59,                           :H_GRP60,                           :H_GRP61,                           :H_GRP62,                           :H_GRP63,                           :H_GRP64,                           :H_GRP65,                           :H_GRP66,                           :H_GRP67,                           :H_GRP68,                           :H_GRP69,                           :H_GRP70,                           :H_GRP71,                           :H_GRP72,                           :H_GRP73,                           :H_GRP74,                           :H_GRP75,                           :H_GRP76,                           :H_GRP77,                           :H_GRP78,                           :H_GRP79,                           :H_GRP80,                           :H_GRP81,                           :H_GRP82,                           :H_GRP83,                           :H_GRP84,                           :H_GRP85,                           :H_GRP86,                           :H_GRP87,                           :H_GRP88,                           :H_GRP89,                           :H_GRP90,                           :H_GRP91,                           :H_GRP92,                           :H_GRP93,                           :H_GRP94,                           :H_GRP95,                           :H_GRP96,                           :H_GRP97,                           :H_GRP98,                           :H_GRP99,                           :H_GRP100,                           :H_GRP101,                           :H_GRP102,                           :H_GRP103,                           :H_GRP104,                           :H_GRP105,                           :H_GRP106,                           :H_GRP107,                           :H_GRP108,                           :H_GRP109,                           :H_GRP110,                           :H_GRP111,                           :H_GRP112,                           :H_GRP113,                           :H_GRP114,                           :H_GRP115,                           :H_GRP116,                           :H_GRP117,                           :H_GRP118,                           :H_GRP119,                           :H_GRP120,                           :H_GRP121,                           :H_GRP122,                           :H_GRP123,                           :H_GRP124,                           :H_GRP125,                           :H_GRP126,                           :H_GRP127,                           :H_GRP128,                           :H_GRP129,                           :H_GRP130,                           :H_GRP131,                           :H_GRP132,                           :H_GRP133,                           :H_GRP134,                           :H_GRP135,                           :H_GRP136,                           :H_GRP137,                           :H_GRP138,                           :H_GRP139,                           :H_GRP140,                           :H_GRP141,                           :H_GRP142,                           :H_GRP143,                           :H_GRP144,                           :H_GRP145,                           :H_GRP146,                           :H_GRP147,                           :H_GRP148,                           :H_GRP149,                           :H_GRP150,                           :H_GRP151,                           :H_GRP152,                           :H_GRP153,                           :H_GRP154,                           :H_GRP155,                           :H_GRP156,                           :H_GRP157,                           :H_GRP158,                           :H_GRP159,                           :H_GRP160,                           :H_GRP161,                           :H_GRP162,                           :H_GRP163,                           :H_GRP164,                           :H_GRP165,                           :H_GRP166,                           :H_GRP167,                           :H_GRP168,                           :H_GRP169,                           :H_GRP170,                           :H_GRP171,                           :H_GRP172,                           :H_GRP173,                           :H_GRP174,                           :H_GRP175,                           :H_GRP176,                           :H_GRP177,                           :H_GRP178,                           :H_GRP179,                           :H_GRP180,                           :H_GRP181,                           :H_GRP182,                           :H_GRP183,                           :H_GRP184,                           :H_GRP185,                           :H_GRP186,                           :H_GRP187,                           :H_GRP188,                           :H_GRP189,                           :H_GRP190,                           :H_GRP191,                           :H_GRP192,                           :H_GRP193,                           :H_GRP194,                           :H_GRP195,                           :H_GRP196,                           :H_GRP197,                           :H_GRP198,                           :H_GRP199,                           :H_GRP200,                           :H_GRP201,                           :H_GRP202,                           :H_GRP203,                           :H_GRP204,                           :H_GRP205,                           :H_GRP206,                           :H_GRP207,                           :H_GRP208,                           :H_GRP209,                           :H_GRP210,                           :H_GRP211,                           :H_GRP212,                           :H_GRP213,                           :H_GRP214,                           :H_GRP215,                           :H_GRP216,                           :H_GRP217,                           :H_GRP218,                           :H_GRP219,                           :H_GRP220,                           :H_GRP221,                           :H_GRP222,                           :H_GRP223,                           :H_GRP224,                           :H_GRP225,                           :H_GRP226,                           :H_GRP227,                           :H_GRP228,                           :H_GRP229,                           :H_GRP230,                           :H_GRP231,                           :H_GRP232,                           :H_GRP233,                           :H_GRP234,                           :H_GRP235,                           :H_GRP236,                           :H_GRP237,                           :H_GRP238,                           :H_GRP239,                           :H_GRP240,                           :H_GRP241,                           :H_GRP242,                           :H_GRP243,                           :H_GRP244,                           :H_GRP245,                           :H_GRP246,                           :H_GRP247,                           :H_GRP248,                           :H_GRP249,                           :H_GRP250,                           :H_GRP251,                           :H_GRP252,                           :H_GRP253,                           :H_GRP254,                           :H_GRP255,                           :H_GRP256,                           :H_GRP257,                           :H_GRP258)          AND  TYPE              = :H_SORT          AND  NAME           LIKE :H_NAME      ORDER BY TTNAME
  29. OPEN SCgvilgCur
  30. FETCH SCgvilgCur INTO :H_NDXN, :H_CNO, :H_TEMP:H_CPAGE
  31. CLOSE SCgvilgCur
  32. DECLARE SCgtvCur CURSOR FOR        SELECT NAME, TYPE, REMARKS        FROM   SYSIBM.SYSTABLES        WHERE  CREATOR           = :H_AUTHID          AND  NAME           LIKE :H_NAME          AND  NAME              <> 'QRWSYS_OBJECT'      ORDER BY NAME
  33. OPEN SCgtvCur
  34. FETCH SCgtvCur INTO :H_NAME, :H_SORT, :H_COMM:H_COMMIND
  35. CLOSE SCgtvCur
  36. DECLARE SCgrpCur CURSOR FOR        SELECT DISTINCT TTNAME, TABAUTH, TYPE, REMARKS        FROM   SYSIBM.SYSTABAUTH, SYSIBM.SYSTABLES        WHERE  TTNAME = NAME          AND  CREATOR           = :H_AUTHID          AND  TCREATOR          = :H_AUTHID          AND  (     GRANTEE     = :H_GRP1                 OR  GRANTEE     = :H_GRP2                 OR  GRANTEE     = :H_GRP3                 OR  GRANTEE     = :H_GRP4                 OR  GRANTEE     = :H_GRP5                 OR  GRANTEE     = :H_GRP6                 OR  GRANTEE     = :H_GRP7                 OR  GRANTEE     = :H_GRP8                 OR  GRANTEE     = :H_GRP9                 OR  GRANTEE     = :H_GRP10                 OR  GRANTEE     = :H_GRP11                 OR  GRANTEE     = :H_GRP12                 OR  GRANTEE     = :H_GRP13                 OR  GRANTEE     = :H_GRP14                 OR  GRANTEE     = :H_GRP15                 OR  GRANTEE     = :H_GRP16                 OR  GRANTEE     = :H_GRP17                 OR  GRANTEE     = :H_GRP18                 OR  GRANTEE     = :H_GRP19                 OR  GRANTEE     = :H_GRP20  )      ORDER BY TTNAME
  37. OPEN SCgrpCur
  38. FETCH SCgrpCur INTO :H_NDXN, :H_CNO, :H_NULLS, :H_TEMP:H_CPAGE
  39. CLOSE SCgrpCur
  40. %DECLARE SCgtvlgCur CURSOR FOR        SELECT DISTINCT TTNAME, TABAUTH, TYPE, REMARKS        FROM   SYSIBM.SYSTABAUTH, SYSIBM.SYSTABLES        WHERE  TTNAME = NAME          AND  CREATOR           = :H_AUTHID          AND  TCREATOR          = :H_AUTHID          AND  GRANTEE IN (:H_GRP1,                           :H_GRP2,                           :H_GRP3,                           :H_GRP4,                           :H_GRP5,                           :H_GRP6,                           :H_GRP7,                           :H_GRP8,                           :H_GRP9,                           :H_GRP10,                           :H_GRP11,                           :H_GRP12,                           :H_GRP13,                           :H_GRP14,                           :H_GRP15,                           :H_GRP16,                           :H_GRP17,                           :H_GRP18,                           :H_GRP19,                           :H_GRP20,                           :H_GRP21,                           :H_GRP22,                           :H_GRP23,                           :H_GRP24,                           :H_GRP25,                           :H_GRP26,                           :H_GRP27,                           :H_GRP28,                           :H_GRP29,                           :H_GRP30,                           :H_GRP31,                           :H_GRP32,                           :H_GRP33,                           :H_GRP34,                           :H_GRP35,                           :H_GRP36,                           :H_GRP37,                           :H_GRP38,                           :H_GRP39,                           :H_GRP40,                           :H_GRP41,                           :H_GRP42,                           :H_GRP43,                           :H_GRP44,                           :H_GRP45,                           :H_GRP46,                           :H_GRP47,                           :H_GRP48,                           :H_GRP49,                           :H_GRP50,                           :H_GRP51,                           :H_GRP52,                           :H_GRP53,                           :H_GRP54,                           :H_GRP55,                           :H_GRP56,                           :H_GRP57,                           :H_GRP58,                           :H_GRP59,                           :H_GRP60,                           :H_GRP61,                           :H_GRP62,                           :H_GRP63,                           :H_GRP64,                           :H_GRP65,                           :H_GRP66,                           :H_GRP67,                           :H_GRP68,                           :H_GRP69,                           :H_GRP70,                           :H_GRP71,                           :H_GRP72,                           :H_GRP73,                           :H_GRP74,                           :H_GRP75,                           :H_GRP76,                           :H_GRP77,                           :H_GRP78,                           :H_GRP79,                           :H_GRP80,                           :H_GRP81,                           :H_GRP82,                           :H_GRP83,                           :H_GRP84,                           :H_GRP85,                           :H_GRP86,                           :H_GRP87,                           :H_GRP88,                           :H_GRP89,                           :H_GRP90,                           :H_GRP91,                           :H_GRP92,                           :H_GRP93,                           :H_GRP94,                           :H_GRP95,                           :H_GRP96,                           :H_GRP97,                           :H_GRP98,                           :H_GRP99,                           :H_GRP100,                           :H_GRP101,                           :H_GRP102,                           :H_GRP103,                           :H_GRP104,                           :H_GRP105,                           :H_GRP106,                           :H_GRP107,                           :H_GRP108,                           :H_GRP109,                           :H_GRP110,                           :H_GRP111,                           :H_GRP112,                           :H_GRP113,                           :H_GRP114,                           :H_GRP115,                           :H_GRP116,                           :H_GRP117,                           :H_GRP118,                           :H_GRP119,                           :H_GRP120,                           :H_GRP121,                           :H_GRP122,                           :H_GRP123,                           :H_GRP124,                           :H_GRP125,                           :H_GRP126,                           :H_GRP127,                           :H_GRP128,                           :H_GRP129,                           :H_GRP130,                           :H_GRP131,                           :H_GRP132,                           :H_GRP133,                           :H_GRP134,                           :H_GRP135,                           :H_GRP136,                           :H_GRP137,                           :H_GRP138,                           :H_GRP139,                           :H_GRP140,                           :H_GRP141,                           :H_GRP142,                           :H_GRP143,                           :H_GRP144,                           :H_GRP145,                           :H_GRP146,                           :H_GRP147,                           :H_GRP148,                           :H_GRP149,                           :H_GRP150,                           :H_GRP151,                           :H_GRP152,                           :H_GRP153,                           :H_GRP154,                           :H_GRP155,                           :H_GRP156,                           :H_GRP157,                           :H_GRP158,                           :H_GRP159,                           :H_GRP160,                           :H_GRP161,                           :H_GRP162,                           :H_GRP163,                           :H_GRP164,                           :H_GRP165,                           :H_GRP166,                           :H_GRP167,                           :H_GRP168,                           :H_GRP169,                           :H_GRP170,                           :H_GRP171,                           :H_GRP172,                           :H_GRP173,                           :H_GRP174,                           :H_GRP175,                           :H_GRP176,                           :H_GRP177,                           :H_GRP178,                           :H_GRP179,                           :H_GRP180,                           :H_GRP181,                           :H_GRP182,                           :H_GRP183,                           :H_GRP184,                           :H_GRP185,                           :H_GRP186,                           :H_GRP187,                           :H_GRP188,                           :H_GRP189,                           :H_GRP190,                           :H_GRP191,                           :H_GRP192,                           :H_GRP193,                           :H_GRP194,                           :H_GRP195,                           :H_GRP196,                           :H_GRP197,                           :H_GRP198,                           :H_GRP199,                           :H_GRP200,                           :H_GRP201,                           :H_GRP202,                           :H_GRP203,                           :H_GRP204,                           :H_GRP205,                           :H_GRP206,                           :H_GRP207,                           :H_GRP208,                           :H_GRP209,                           :H_GRP210,                           :H_GRP211,                           :H_GRP212,                           :H_GRP213,                           :H_GRP214,                           :H_GRP215,                           :H_GRP216,                           :H_GRP217,                           :H_GRP218,                           :H_GRP219,                           :H_GRP220,                           :H_GRP221,                           :H_GRP222,                           :H_GRP223,                           :H_GRP224,                           :H_GRP225,                           :H_GRP226,                           :H_GRP227,                           :H_GRP228,                           :H_GRP229,                           :H_GRP230,                           :H_GRP231,                           :H_GRP232,                           :H_GRP233,                           :H_GRP234,                           :H_GRP235,                           :H_GRP236,                           :H_GRP237,                           :H_GRP238,                           :H_GRP239,                           :H_GRP240,                           :H_GRP241,                           :H_GRP242,                           :H_GRP243,                           :H_GRP244,                           :H_GRP245,                           :H_GRP246,                           :H_GRP247,                           :H_GRP248,                           :H_GRP249,                           :H_GRP250,                           :H_GRP251,                           :H_GRP252,                           :H_GRP253,                           :H_GRP254,                           :H_GRP255,                           :H_GRP256,                           :H_GRP257,                           :H_GRP258)      ORDER BY TTNAME
  41. OPEN SCgtvlgCur
  42. FETCH SCgtvlgCur INTO :H_NDXN, :H_CNO, :H_NULLS, :H_TEMP:H_CPAGE
  43. CLOSE SCgtvlgCur
  44. DECLARE SCginCur CURSOR FOR        SELECT NAME        FROM   SYSIBM.SYSINDEXES        WHERE  CREATOR           = :H_AUTHID          AND  NAME           LIKE :H_NDXN
  45. OPEN SCginCur
  46. FETCH SCginCur INTO :H_NDXN
  47. CLOSE SCginCur
  48. H_AUTHID
  49. H_GRANTEE
  50. H_GRANTOR
  51. H_GRP1
  52. H_GRP2
  53. H_GRP3
  54. H_GRP4
  55. H_GRP5
  56. H_GRP6
  57. H_GRP7
  58. H_GRP8
  59. H_GRP9
  60. H_GRP10
  61. H_GRP11
  62. H_GRP12
  63. H_GRP13
  64. H_GRP14
  65. H_GRP15
  66. H_GRP16
  67. H_GRP17
  68. H_GRP18
  69. H_GRP19
  70. H_GRP20
  71. H_GRP21
  72. H_GRP22
  73. H_GRP23
  74. H_GRP24
  75. H_GRP25
  76. H_GRP26
  77. H_GRP27
  78. H_GRP28
  79. H_GRP29
  80. H_GRP30
  81. H_GRP31
  82. H_GRP32
  83. H_GRP33
  84. H_GRP34
  85. H_GRP35
  86. H_GRP36
  87. H_GRP37
  88. H_GRP38
  89. H_GRP39
  90. H_GRP40
  91. H_GRP41
  92. H_GRP42
  93. H_GRP43
  94. H_GRP44
  95. H_GRP45
  96. H_GRP46
  97. H_GRP47
  98. H_GRP48
  99. H_GRP49
  100. H_GRP50
  101. H_GRP51
  102. H_GRP52
  103. H_GRP53
  104. H_GRP54
  105. H_GRP55
  106. H_GRP56
  107. H_GRP57
  108. H_GRP58
  109. H_GRP59
  110. H_GRP60
  111. H_GRP61
  112. H_GRP62
  113. H_GRP63
  114. H_GRP64
  115. H_GRP65
  116. H_GRP66
  117. H_GRP67
  118. H_GRP68
  119. H_GRP69
  120. H_GRP70
  121. H_GRP71
  122. H_GRP72
  123. H_GRP73
  124. H_GRP74
  125. H_GRP75
  126. H_GRP76
  127. H_GRP77
  128. H_GRP78
  129. H_GRP79
  130. H_GRP80
  131. H_GRP81
  132. H_GRP82
  133. H_GRP83
  134. H_GRP84
  135. H_GRP85
  136. H_GRP86
  137. H_GRP87
  138. H_GRP88
  139. H_GRP89
  140. H_GRP90
  141. H_GRP91
  142. H_GRP92
  143. H_GRP93
  144. H_GRP94
  145. H_GRP95
  146. H_GRP96
  147. H_GRP97
  148. H_GRP98
  149. H_GRP99
  150. H_GRP100
  151. H_GRP101
  152. H_GRP102
  153. H_GRP103
  154. H_GRP104
  155. H_GRP105
  156. H_GRP106
  157. H_GRP107
  158. H_GRP108
  159. H_GRP109
  160. H_GRP110
  161. H_GRP111
  162. H_GRP112
  163. H_GRP113
  164. H_GRP114
  165. H_GRP115
  166. H_GRP116
  167. H_GRP117
  168. H_GRP118
  169. H_GRP119
  170. H_GRP120
  171. H_GRP121
  172. H_GRP122
  173. H_GRP123
  174. H_GRP124
  175. H_GRP125
  176. H_GRP126
  177. H_GRP127
  178. H_GRP128
  179. H_GRP129
  180. H_GRP130
  181. H_GRP131
  182. H_GRP132
  183. H_GRP133
  184. H_GRP134
  185. H_GRP135
  186. H_GRP136
  187. H_GRP137
  188. H_GRP138
  189. H_GRP139
  190. H_GRP140
  191. H_GRP141
  192. H_GRP142
  193. H_GRP143
  194. H_GRP144
  195. H_GRP145
  196. H_GRP146
  197. H_GRP147
  198. H_GRP148
  199. H_GRP149
  200. H_GRP150
  201. H_GRP151
  202. H_GRP152
  203. H_GRP153
  204. H_GRP154
  205. H_GRP155
  206. H_GRP156
  207. H_GRP157
  208. H_GRP158
  209. H_GRP159
  210. H_GRP160
  211. H_GRP161
  212. H_GRP162
  213. H_GRP163
  214. H_GRP164
  215. H_GRP165
  216. H_GRP166
  217. H_GRP167
  218. H_GRP168
  219. H_GRP169
  220. H_GRP170
  221. H_GRP171
  222. H_GRP172
  223. H_GRP173
  224. H_GRP174
  225. H_GRP175
  226. H_GRP176
  227. H_GRP177
  228. H_GRP178
  229. H_GRP179
  230. H_GRP180
  231. H_GRP181
  232. H_GRP182
  233. H_GRP183
  234. H_GRP184
  235. H_GRP185
  236. H_GRP186
  237. H_GRP187
  238. H_GRP188
  239. H_GRP189
  240. H_GRP190
  241. H_GRP191
  242. H_GRP192
  243. H_GRP193
  244. H_GRP194
  245. H_GRP195
  246. H_GRP196
  247. H_GRP197
  248. H_GRP198
  249. H_GRP199
  250. H_GRP200
  251. H_GRP201
  252. H_GRP202
  253. H_GRP203
  254. H_GRP204
  255. H_GRP205
  256. H_GRP206
  257. H_GRP207
  258. H_GRP208
  259. H_GRP209
  260. H_GRP210
  261. H_GRP211
  262. H_GRP212
  263. H_GRP213
  264. H_GRP214
  265. H_GRP215
  266. H_GRP216
  267. H_GRP217
  268. H_GRP218
  269. H_GRP219
  270. H_GRP220
  271. H_GRP221
  272. H_GRP222
  273. H_GRP223
  274. H_GRP224
  275. H_GRP225
  276. H_GRP226
  277. H_GRP227
  278. H_GRP228
  279. H_GRP229
  280. H_GRP230
  281. H_GRP231
  282. H_GRP232
  283. H_GRP233
  284. H_GRP234
  285. H_GRP235
  286. H_GRP236
  287. H_GRP237
  288. H_GRP238
  289. H_GRP239
  290. H_GRP240
  291. H_GRP241
  292. H_GRP242
  293. H_GRP243
  294. H_GRP244
  295. H_GRP245
  296. H_GRP246
  297. H_GRP247
  298. H_GRP248
  299. H_GRP249
  300. H_GRP250
  301. H_GRP251
  302. H_GRP252
  303. H_GRP253
  304. H_GRP254
  305. H_GRP255
  306. H_GRP256
  307. H_GRP257
  308. H_GRP258
  309. H_NAME
  310. H_NDXN
  311. H_COMM
  312. H_TEMP
  313. H_COMMIND
  314. H_NULLIND
  315. H_SORT
  316. H_COLN
  317. H_COLTYPE
  318. H_NULLS
  319. H_CPAGE
  320. H_CLEN
  321. H_CSCALE
  322. H_CNO
  323. H_KEYCOLS
  324. H_KEYSEQ
  325. H_ADMAUTH
  326. H_CTABAUTH
  327. H_BNDAUTH
  328. H_CONAUTH
  329. H_CTRAUTH
  330. H_ALTAUTH
  331. H_DELAUTH
  332. H_IDXAUTH
  333. H_INSAUTH
  334. H_SELAUTH
  335. H_UPDAUTH
  336. H_TABAUTH
  337. H_REFAUTH
  338. H_COLNAMES
  339. H_PKNAMES
  340. H_UNIQUE
  341.