Actions
You can use the following action codes in your Explain in one of the following ways:
- Type the action code in the space beside an object, and press Enter.
- Put the cursor in the space beside an object, and press Enter. A list of action codes is displayed. Specify an action code, and press Enter.
The action codes appear on the Explain Object Selection List and the Explain Results panels. To specify an action code for multiple objects, type the action code in the space beside an object, type an equal sign (=) in the space beside any subsequent objects on which you want to perform the same action, and press Enter.
The following table lists the action codes.
Action codes for Explain
Code | Action | Description |
|---|---|---|
H | Hide | Collapses the results of the previous action code |
P | Predicate | Displays a predicate report Explain automatically displays a predicate report if a statement has a mismatch in data type or length in the predicate. The predicates containing the mismatch are shown in red. |
R | Rules | Displays severe, warning, and informational rules for BIND parameters, SQL statements, access path steps, and statistics Severe rules are shown in red, warning rules are shown in yellow, and informational rules are shown in green. To learn more about a rule, type TSO PSSMSG BMC msgNum , where msgNum is the six-digit BMC message number. Do not include the severity code in this number. |
RI | Rules: Informational | Displays informational rules for BIND parameters, SQL statements, access path steps, and statistics |
RS | Rules: Severe | Displays severe rules for BIND parameters, SQL statements, access path steps, and statistics |
RW | Rules: Warning | Displays warning rules for BIND parameters, SQL statements, access path steps, and statistics |
S | Show | Expands a list of statements, shows a formatted version of statement text, or shows statistics or columns for the objects referenced in the access path step |
T | Text Compare | Compares the text of two SQL statements |
W | What-If Edit SQL | Performs a What-If Edit SQL Explain |
XB | Explain: Batch | Performs a batch Explain |
XC | Explain: Compare | Compares the results of a dynamic Explain with one or more static Explains |
XD | Explain: Dynamic | Performs a dynamic Explain |
XS | Explain: Static | Performs a static Explain |
XP | Explain: Package | Performs an Explain package, which reports on plan stability rows |
Related topics