Using Commands › Command Summary

Command Summary

+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.

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.

DQL

Changes mode of operation from SQL Mode to DQL Mode.

DRAW

With a table-name operand, creates a simple query. See Creating a Simple Query Using DRAW for details.

EDIT

With operand, displays EDITOR panel containing named text. Can be used to change a private query (by updating) or to display and copy any query by changing the name and saving it.

EXECUTE

Displays ONLINE EXECUTION panel for query named in command.

EXTRACT

(DQL only). Displays EXTRACT ACTIVE FOUND SET panel to save a set of data found by a query.

FORMAT

(SQL only) Displays the first REPORT FORMAT panel for the active query.

GUIDE

Displays the first panel for constructing a query with the GUIDE function.

HELP

Displays HELP panel topics you can select for additional Help.

KEEP

(DQL only). Displays panel for saving query output.

LIST

With operands, displays directory of queries, dialogs, or tables.

MENU

Displays MAIN MENU.

MSG

With operands, sends a message to designated user.

NO-TOTALS

Entered on the 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.

STATS

Displays EXECUTION STATISTICS panel for current query.

STORE

With unique, table name operand, creates a personal table from active found set of data.

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.

WRAP

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