Package Selection
The Package Selection screen (Package Selection Screen) displays when Package is selected on the SQL Plan Analysis Specification screen, or when a Collection ID is selected on the Collection ID Selection screen (Collection ID Selection Screen). This screen lists detailed package information, including collection ID, package name, bind timestamps, and version.
CMD
Specify the line command to be performed on the selected package.
S | Displays specific package information. The SQL Statement Selection screen (SQL Statement Selection Screen) displays. If no detailed information is available for the package, the error message NONE EXPLAINABLE displays. |
X | Performs an Explain of the entire 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 package, it must contain one of the following SQL statements: DECLARE CURSOR, DELETE, INSERT, SELECT, or UPDATE. If it cannot be explained, the error message NONE EXPLAINABLE displays. |
Package Selection Screen
Sorting Package Entries
The SORT primary command can be used to change the order in which 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)
- Collid (CI)
- Version (VER)
For example, to sort the display by the bind timestamp, enter the command SORT TI.
Related topics