(DQD30) Query Template

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

Description

The Query Template panel presents a list of CA Dataquery statements and syntax in the order in which they should appear in a query. Each statement contains DQL words in uppercase letters (like FIND and WIDTH) and lowercase letters (like table-name) to indicate where you need to provide information. You can copy one or more statements to the Editor or simply use the panel as a reference for query syntax.

On a terminal screen with 43 lines, the remainder of the statement templates available to you also appear on this panel. On a terminal screen with fewer lines, the remaining statement templates appear on DQD40 when you use <PF8> FORWARD while displaying this panel.

Action

Enter a number or a character 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. Entering a character means you want to return to the Editor panel with one copy of the statement template. 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 forward with <PF8> FORWARD to see additional statement templates if your terminal screen is smaller than 43 lines.

Template Text

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

Entry Fields

Refer to the following chart for valid entries in the field 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.

Field	Required?	Valid Entries	Default
__	N	A number showing the number of times to appear on the Editor or any character to select once.	None

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: Scrolls backward one panel.
<PF8> FORWARD: Scrolls remaining statement templates (DQD40) if terminal screen is shorter than 43 lines.