SQL Statement Selection

The SQL Statement Selection screen (see the following figure) displays when a DBRM or package is selected with the S line command on the DBRM/Package Selection screen (DBRM/Package Selection Screen) or the DBRM Selection screen (DBRM Selection Screen).

SQL Statement Selection Screen

image2021-3-11_19-39-13.png

CMD

Specify the line command to be performed on the selected SQL statement:

X

Enter X to perform an Explain of the selected SQL statement. The Plan Table Analysis screen (Plan Table Analysis Screen) displays.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*