Option O. Stored Procedures

Use the Stored Procedures panel to display information about the stored procedures in the Db2 catalog.

Select option O on the System Catalog panel to display the Stored Procedures panel, as shown in the following figure.

Figure 1. Stored Procedures panel (ADB21O)
 ADB21O in ---------------- DD1A Stored Procedures ---------- Row 1 to 9 of 363 
                                                                                
 Commands: GRANT                                                                
 Line commands:                                                                 
  AH - Schema auth  A - Auth  DROP - Drop  AL - Alter  K - Package  PA - Parms  
  DIS - Display  STO - Stop  STA - Start  GR - Grant  COM - Comment  CALL - Call
  ? - Show all line commands                                                    
                                                               S                
                                                         Res   Q S P C External 
 Sel  Schema   Name               Version  A Lang Parms  Set O L R T R Name     
      *        *                  *        * *         *   * * * * * * *        
 ---- -------- ------------------ -------- - ---- ------ --- - - - - - ---------
      SYSPROC  ADMIN_COMMAND_DB2             C        12   2 E M N M N DSNADMCD 
      SYSPROC  ADMIN_COMMAND_DSN             REXX      2   1 E M N M N DSNADMCS 
      SYSPROC  ADMIN_COMMAND_MVS             C        11   1 E M N M N DSNADMCM 
      SYSPROC  ADMIN_COMMAND_UNIX            C         6   1 E M N M N DSNADMCU 
      SYSPROC  ADMIN_DS_BROWSE               ASSE      6   1 E M N M N DSNADMDB 
      SYSPROC  ADMIN_DS_DELETE               ASSE      6   0 E M N M N DSNADMDD 
      SYSPROC  ADMIN_DS_LIST                 ASSE      7   1 E M N M N DSNADMDL 
      SYSPROC  ADMIN_DS_RENAME               ASSE      7   0 E M N M N DSNADMDR 
      SYSPROC  ADMIN_DS_SEARCH               ASSE      6   0 E M N M N DSNADMDE

The following primary command is valid on this panel:

GRANT
Issues a GRANT command on multiple stored procedures.
Tip: The GRANT command operates on each row that is displayed in the table. If you want to omit some of the rows before you issue the command, you can use the minus (-) line command to remove rows from the display. The GRANT command operates only on rows that are listed.

The following columns are on this panel:

Sel
Input field where you enter one of the line commands listed on the panel.
Schema
Schema of the stored procedure.
Name
Name of the stored procedure.
Version
The version identifier for a native SQL procedure.
A
Identifies the active version of a routine.
Lang
Implementation language.
Parms
Number of parameters for the stored procedure.
Res Set
Maximum number of result sets that can be returned.
O
Origin of the routine:
E
External.
Q
SQL.
S
System generated.
U
User-defined or built-in function.
N
Native SQL procedure.
SQL
This field indicates whether SQL statements are allowed, which is one of the following values:
N
No SQL statement, SQL is not allowed.
C
Contains SQL statements.
R
Reads SQL data.
M
Modifies SQL data.
blank
Not applicable.
SR
This field indicates whether the program should remain resident when it ends. This field contains one of the following values:
Y
Program remains resident.
N
Program does not remain resident.
blank
Not external or user-defined function.
PT
Program type, which is one of the following values:
M
Main.
S
Subroutine.
blank
Not applicable.
CR
Commit on return. This field contains one of the following values:
Y
Unit of work is committed immediately.
N
Unit of work continues.
A
Autonomous. Only the unit of work from the procedure is committed. Work from the application that calls the procedure is not immediately committed.
External Name
Load module name for the stored procedure.