=> Place a nonblank beside each statement that is to be included in the query --------------------------------------------------------------------------DQD50 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. ------------------------------------------------------------------------------- _ SELECT column1, column2, count(column3) _ FROM table1, table2 _ WHERE table1.column1 = table2.column2 and column3 > 0 _ GROUP BY column1, column2 _ ORDER BY column1 ------------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> NOT USED <PF4> NOT USED
Description
The SQL Mode Query Template panel presents a list of SQL syntax in the order in which they should appear in a query. You can copy one or more statement templates 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 pressed <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 words in uppercase letters (like SELECT and FROM) and words you type over on the Editor panel in lowercase letters (like column1).
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.
|
Field |
Required? |
Valid Entries |
Default |
|---|---|---|---|
|
__ |
N |
A number showing |
None |
PF Keys
The following lists the PF keys for this panel, with a brief description of each function.
Displays Help information about the current panel.
Returns to Editor panel with any selected statements.
|
Copyright © 2014 CA.
All rights reserved.
|
|