Panels › (DQD40) Query Template

(DQD40) Query Template

 =>
 Enter the number of times each statement 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

Description

This continuation of the query template appearing on DQD30 presents a list of remaining CA Dataquery statements and syntax in the order in which they should appear in a query (following the statement templates on DQD30). Each statement contains DQL words in uppercase letters (like PRINT and FROM) and words in lowercase letters (like table-name) that you type over. You can copy one or more statements to the Editor or simply use the panel as a reference for query syntax.

Action

Enter a number in the field next to any statements you want to use in your query. The number represents the number of times you want the statement template to appear on the Editor panel in the position indicated by the cursor when you press <PF9> TEMPLATE during Editor display. You can select all statements at once, return to the Query Template panel to copy one or more statements at a time, or return without copying any statements.

Scroll backward with <PF7> BACKWARD to see previous statement templates on DQD30.

Template Text

Each statement template contains DQL Language words in uppercase letters (like PRINT and FROM) and words you type over on the Editor panel in lowercase letters (like table-name).

Entry Fields

Refer to the following chart for valid entries in the fields on this panel. Use the Tab and arrow keys to move the cursor. To change an entry, write or space over it. When entries are complete, press Enter or a valid PF key.

PF Keys

The following lists the PF keys for this panel, with a brief description of each function.

<PF1> HELP

Displays Help information about the current panel.

<PF2> RETURN

Returns to Editor panel with any selected statements.

<PF7> BACKWARD

Views previous statement templates (DQD30) if terminal screen is shorter than 43 lines.

<PF8> FORWARD

Scrolls forward to see additional templates if terminal screen is shorter than 43 lines.