Previous Topic: All Editor CommandsNext Topic: DQL Statements


Operation Commands

+nnnn

(Where nnnn represents a number) Scrolls forward nnnn pages on a multi-screen panel.

-nnnn

(Where nnnn represents a number) Scrolls backward nnnn pages on a multi-screen panel.

ADMIN

Displays Administrative Menu.

AUTHID

(With an SQL authorization ID as an operand) Changes the authid for the current session.

BOTTOM

Scrolls to bottom of multi-screen panel.

CREATE

Displays CA Dataquery Editor panel.

DETAIL

(Entered on the report output panel) Formats report to display the report as it is defined in the query, with detail and totals.

DIRECTORY

Displays Directory Selection panel.

DISPLAY

Displays Key and Columns Display panel for named table.

DRAW

(With a table-name operand) Creates a simple query that finds all simple columns.

DQL

Changes mode of operation from SQL Mode to DQL Mode.

EDIT

(With operand) Displays Editor panel containing named text.

EXECUTE

Displays online execution panel for query named in command.

EXTRACT

Displays Extract Active Found Set panel to save a set of data found by a query.

FORMAT

(Followed by the name of an existing query or dialog) Displays first panel for formatting the output created by executing an SQL query.

GUIDE

Displays the first panel for constructing a query with the Guided Query Creation function.

HELP

Displays Help panel topics you can select for additional Help.

KEEP

Displays panel for saving query output.

LIST

(With operands) Displays directory of queries, terms, dialogs, files, or saved found data sets.

MENU

Displays Main Menu.

MSG

(With operands) Sends a message to designated user.

NO-DETAIL

(Entered on the DQL Mode report output panel) Formats report to display query output without detail lines.

NO-TOTALS

(Entered on the DQL Mode report output panel) Formats report to display query output without totals.

NOWRAP

Issue after WRAP command to return wrapped report lines to multi-screen display.

OFF

Signs CA Dataquery off and returns to monitor.

PDB

Initiates Personal Database Facility.

PFn

(Where n is a number from 1 to 12) Acts as a numbered PF key.

PROFILE

Displays User Profile panel.

SQL

Changes mode of operation from DQL Mode to SQL Mode. To use personal tables, the SQL option of CA Datacom/DB must be installed at your site and you must be authorized by your CA Dataquery Administrator to access the Personal Database Facility.

STALL

Displays Execution Statistics panel with expanded statistics and a PF key for viewing tables statistics.

STATS

Displays Execution Statistics panel for current query.

STORE

(With unique, new table name operand) Creates a personal table from active found set of data in DQL Mode or SQL Mode.

SUBMIT

(With query name) Displays Batch Execution panel for query named.

TIME

Displays current time and date.

TOP

Scrolls to the top of a multi-screen panel.

TOTALS

(Entered on the report output panel) Formats report to display only total lines and suppresses detail lines.

WHEN-ONLY

(Entered on the report output panel) Formats report to display only the results of DQL Mode WHEN/DO statements.

WRAP

Moves off-screen lines to current screen of multi-screen display by wrapping each report line before starting the next report line.