Field descriptions
The values of certain columns from each row of PLAN_TABLE are displayed in each report line. To see more detailed information, including values of additional PLAN_TABLE columns, issue the “++” line command or press the ENTER key. For full descriptions of these columns, refer to DB2 Universal Database™ for z/OS®: Application Programming and SQL Guide.
| Under Heading | This is Displayed |
|---|---|
| Blk Num | The value of the QBLOCKNO column. This is also an input field. Use the “++” line command or press the ENTER key to display more information about the PLAN_TABLE row. |
| Plan Num | The value of the PLANNO column. |
| Mix Op | The value of the MIXOPSEQ column. |
| Join Mthd | The value of the METHOD column. |
| Acc Type | The value of the ACCESSTYPE column. |
| Match Cols | The value of the MATCHCOLS column. |
| Index Only | The value of the INDEXONLY column. |
| Sort New | U J O G The values of the SORTN_UNIQ, SORTN_JOIN, SORTN_ORDERBY and SORTN_GROUPBY columns. |
| Sort Comp | U J O G The values of the SORTC_UNIQ, SORTC_JOIN, SORTC_ORDERBY and SORTC_GROUPBY columns. |
| Table Name | The value of the TNAME column. |