DBRM/Package Selection
The DBRM/Package Selection screen (see the following figure) displays when a plan is selected with the S line command on the SQL Plan Selection screen (SQL Plan Selection). This screen displays detailed DBRM or Package information.
DBRM/Package Selection Screen
CMD
Specify the line command to be performed on the selected DBRM/Package.
S | Displays detailed information for the selected DBRM or package. The SQL Statement Selection screen (SQL Statement Selection Screen) displays. |
X | Performs an Explain of the entire DBRM or package. If you entered 1 for online processing on the SQL Plan Analysis Specification screen (SQL Plan Analysis Specification Screen), the SQL Analysis Summary screen (SQL Analysis Summary) displays. If you entered 2 for batch processing on the SQL Plan Analysis Specification screen (SQL Plan Analysis Specification Screen), the Batch Plan Analysis Reports window (Batch Plan Analysis Reports Window) displays. See Explaining-Objects-in-Batch for more information. Note: To explain the DBRM or package, it must contain one of the following SQL statements: DECLARE CURSOR, DELETE, INSERT, SELECT, or UPDATE. If the DBRM or package cannot be explained, the error message NONE EXPLAINABLE displays. |
Sorting DBRMs or Packages
The SORT primary command can be used to change the order in which the DBRM or package entries are displayed. Multiple column names are not accepted. The selected columns are sorted in ascending sequence. The valid column names that can be used with the SORT command are listed below. Abbreviations are noted within parentheses.
- Name (NA)
- Time (TI)
- Dname (DN)
- Version (VER)
For example, to sort the display by dataset name, enter the command SORT DN.