Stored Procedures panel

You use the Stored Procedures panel to display information about the stored procedures you have selected.

Panel and field definitions

The columns that are displayed include the SEL field and columns of SYSIBM.SYSROUTINES.

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)                  Stored Procedures
 Location:                                                          Format TABL


 SEL    SCHEMA   NAME               ORIGINEX OWNER    ROUTINEX         CREATEDB
        *        *                  *        *        *                *       
 ----   #1--+--- #3--+----1----+--- #90-+--- #2--+--- #89-+----1----+- #5--+---
 ****  Top of data  ****
        SYSPROC  DSNWZP             External CJUNELL  Stored procedure CJUNELL
        SYSPROC  DSNWSPM            External CJUNELL  Stored procedure CJUNELL
        SYSPROC  DSNUTILS           External CJUNELL  Stored procedure CJUNELL
        SYSPROC  DSNUTILU           External CJUNELL  Stored procedure CJUNELL
        SYSPROC  DSNTPSMP           External CJUNELL  Stored procedure CJUNELL
        SYSPROC  WLM_REFRESH        External CJUNELL  Stored procedure CJUNELL
        SQLJ     INSTALL_JAR        External CJUNELL  Stored procedure CJUNELL
        SQLJ     REPLACE_JAR        External CJUNELL  Stored procedure CJUNELL
        SQLJ     REMOVE_JAR         External CJUNELL  Stored procedure CJUNELL
        SYSPROC  DSNACICS           External CJUNELL  Stored procedure CJUNELL
        SYSPROC  DSNACCOR           External CJUNELL  Stored procedure CJUNELL
 Command ===>                                                       Scroll PAGE
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel
Note:
  1. The system option, Show all catalog table columns, affects which columns FM/Db2 displays when you use the Object List utility.
  2. You can also customize which columns FM/Db2 displays when you use the Object List utility. For details, see the File Manager Customization Guide.

To view other columns on this panel, press the Right function key (F11).

For a complete list of columns, refer to Db2® catalog tables in the DB2 for z/OS SQL Reference relevant to your version of Db2®.

SEL
Line command area.
For a list of the line commands you can use on this panel, see Object list line commands.

Parent panels

Child panels

To display this panel… Use/do this
Alter Stored Procedure panel Line command A
See Comment panels Line command COM
Create Procedure panel Line command CR
See Drop panels Line command DR
Grant privileges panels Line command G
Generate SQL From Db2 Catalog panel Line command GEN
Details panels Line command I
Privileges panels Line command P
Routine Parameters panel Line command PARM
Application Packages panel Line command PKG
Line command PS
Revoke privileges panels Line command R
Display Row panel Line command ROW
Schemas panel Line command SCH
Sort Fields panel Primary command SORT

Related tasks