In Input mode, the QUERY screen has the following layout:
In the heading, QUERY displays the present command mode (Input), the currently displayed set of lines of the input form (nnn-mmm), and the current version number of the executed program (QUERY 10.01).
In the bottom boundary line of the input form, the SERVERDB name and the user name are displayed.
A section of the input form is displayed between the two horizontal boundary lines. This form can contain a maximum of 12 KB text and has a maximum width of 132 characters. Using the scroll keys, you can display any section of the form.
The input form is used for entering SQL statements. QUERY can execute various SQL statements with one RUN command. These statements must be separated from each other by comment lines (/ or *). If an error occurs, the statements remaining on the input form will not be executed.
SELECT statements can be combined with REPORT commands in order to edit the result table. The REPORT commands must be separated from the SELECT statements by a line containing the keyword REPORT.
Entering and modifying long statements is facilitated by user-friendly editor functions (see the platform-specific ADABAS User Manual).
EDIT <command name> copies the stored command having the specified name into the input area. A previously defined command can be read from an external file using the editing function GET <filename> and be written back to the file using the editing function PUT <filename>.
An example of how to enter a SELECT statement:
... and the following is a SELECT statement which could
be stored under a command name by means of STORE:
If the INPUT area is marked with '===' at the left margin, editor commands can be entered at this prefix.