Using CREATE in DQL Mode › Creating the Sample Query › Step 7: Specify Mathematical Function › Display Query Template

Display Query Template

To display the query template, follow these steps:

1. Scroll line 10 to the top of the display to insert a WHEN-DO template.
2. Press <PF9> TEMPLATE to display the query template.

At the end of Step 6, the cursor appears after the edit pattern in line 10 since it is not necessary to insert a blank line on the CREATE MODE panel to insert a statement format. Pressing <PF9> displays the query template. You know from Step 6 that TEMPLATE has two panels. The WHEN/DO format is displayed on the second panel. Scrolling forward from the first panel displays the following panel.

If your terminal displays more than 24 lines at a time, CA Dataquery displays the query template on one panel.

 =>
 Enter the number of times each command is to be included in the query
 --------------------------------------------------------------------------DQD40
 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
 -------------------------------------------------------------------------------
 _  PRINT FROM table-name     ROWS
            column-name ('optional-heading') (PICTURE 'picture-clause')
 _  DISPLAY FROM table-name
            column-name ('optional-heading') (PICTURE 'picture-clause')
 _  WHEN named-control-break-object FINISHED  BREAKS
     DO 'legend-for-display'  function  column-name (PICTURE 'picture-clause')






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