Using CREATE in DQL Mode › Creating the Sample Query › Step 2: Select First or Only Table › Display Query Template

Display Query Template

To display the query template, follow these steps:

1. Place the cursor in the first blank line under the line marked TOP.
2. Press <PF9> TEMPLATE to display the query template.

Placing the cursor on the blank line indicates that the DQL statement selected from the query template will be inserted in that location. Pressing <PF9> displays the following panel.

 =>
 Enter the number of times each command is to be included in the query
 --------------------------------------------------------------------------DQD30
 DATAQUERY:  QUERY TEMPLATE
 -------------------------------------------------------------------------------
 Lower case words represent entries which must be replaced by the user.
 Parentheses indicate optional entries: these may be included by removing the
 parentheses only or deleted by removing both the parentheses and data.
 -------------------------------------------------------------------------------
 _  FIND (count)  table-name    ROWS
 _  WITH selection-criteria
 _  RELATED BY key-name
        TO (FIRST) table-name
 _  RELATED BY link-column
        VIA key-name column-name TO table-name
 _  SET result-column (13.2)
        = numeric-column-name arithmetic-expression numeric-literal
 _  SORT table-name       BY column-name (DOWN)



 -------------------------------------------------------------------------------
 <PF1>  HELP         <PF2>  RETURN       <PF3>  NOT USED    <PF4>  NOT USED
 <PF5>  NOT USED     <PF6>  NOT USED     <PF7>  BACKWARD    <PF8>  FORWARD