KEYCOLS

Edit online

Creates a variable of the same name for any columns in a query and assigns the value of the variable to this name. Creating a variable allows fields that uniquely identify a row of data to be saved for a subsequent query (drilldown) using that row of data. KEYCOLS is invoked only after a row of data is selected. This setting must be specified after the subpanel's QUERY statement.

Possible values: ALL
displays all the columns specified in the query.; One or more column names specified in the query
Use a comma-delimited list to specify more than one column name. Enclose the list in quotation marks.
Note: Using ALL results in increased overhead.
Default value: None

KEYCOLS='HUBNAME, LPAR, TRANSID'

allows these variables to be used in a future query such as:

SELECT ... WHERE HUBNAME=&HUBNAME AND LPAR=&LPAR AND TRANSID=&TRANSID