

A QUERY session is started with one of the calls


In detail, the call can depend on the operating system (see the platform-specific ADABAS User Manual).
With the call (I), QUERY returns the INPUT form and waits for the input of an SQL statement.
With the call (II), QUERY returns the MENU of stored commands. There is no way for the user to access the INPUT form to enter individual SQL statements. This call is intended for end users who only work with previously determined commands.
When starting an SQL statement or one of the stored commands (with RUN), QUERY implicitly passes over to the EXECUTE mode and performs the command.
For a query to the database (SELECT), QUERY displays the result table in REPORT mode. The table can be scrolled through on the screen and may be edited in report format with the REPORT commands.
The values of certain control parameters can be set individually using the SET function; for example, the language of the guidance messages and the standard layout of reports.
The HELP function is available for single QUERY functions. It can be called in the INPUT, REPORT, and MENU modes by pressing the key
or
or by using the HELP
command.
Every SQL statement is issued with an implicit COMMIT. This means that a subsequent ROLLBACK has no effect. After a timeout has taken place, QUERY implicitly opens a new session for the next user activity. This is indicated by the message: 'Reconnected after timeout'. Afterwards, the previously produced result tables are no longer available.
The command EXIT terminates a QUERY session at any time.
Overview of the QUERY Command Modes:


