Using Operands
End users can enter a command on the command line at the top of any panel and press Enter to proceed directly to any authorized function or panel. Some CA Dataquery commands require you to enter additional information called operands after the command. If the needed operands are not entered, or if invalid operands are entered, CA Dataquery displays a helpful panel that prompts you for valid operands. These panels are documented in Panels.
Effect on <PF2> RETURN
Entering an operation command terminates all outstanding CA Dataquery processes, such as directory displays. If <PF2> RETURN is used on a function initiated by a command, CA Dataquery returns to the Main Menu.
Administrative Commands
If you are authorized to use Administrative commands, see the CA Dataquery User Guide for administrative command usage and syntax.
Chapter Organization
This chapter provides detailed instructions on CA Dataquery conventional user commands. The commands appear in alphabetic order with the command name listed in the top outside corner of the page. You can abbreviate any command by typing the fewest characters that uniquely identify it to CA Dataquery, as in EXE for EXECUTE.
Summary
The following summarizes valid user commands.
(Where nnnn represents a number) Scrolls forward nnnn pages on a multi-screen panel.
(Where nnnn represents a number) Scrolls backward nnnn pages on a multi-screen panel.
Displays Administrative Menu.
With an SQL authorization ID as an operand, changes the authid for the current session.
Scrolls to bottom of multi-screen panel.
Displays CA Dataquery Editor panel.
Entered on the report output panel, formats report to display the report as it is defined in the query, with detail and totals.
Displays Directory Selection panel.
Displays Key and Columns Display panel for named table.
With a table-name operand, creates a simple query that finds all simple columns.
Changes mode of operation from SQL Mode to DQL Mode.
With operand, displays Editor panel containing named text.
Display online execution panel for query named in command.
Displays Extract Active Found Set panel to save a set of data found by a query.
Followed by the name of an existing query or dialog, displays first panel for formatting the output created by executing an SQL query.
Displays the first panel for constructing a query with the Guided Query Creation function.
Displays Help panel topics you can select for additional Help.
Displays panel for saving query output.
With operands, displays directory of queries, terms, dialogs, files, or saved found data sets.
Displays Main Menu.
With operands, sends a message to designated user.
Entered on the DQL Mode report output panel, formats report to display query output without detail lines.
Entered on the DQL Mode report output panel, formats report to display query output without totals.
Issue after WRAP command to return wrapped report lines to multi-screen display.
Signs CA Dataquery off and returns to monitor.
Initiates Personal Database Facility.
Where n is a number from 1 to 12, acts as a numbered PF key.
Displays User Profile panel.
Displays Execution Statistics panel with expanded statistics and a PF key for viewing tables statistics.
Displays Execution Statistics panel for current query.
With unique, new table name operand, creates a personal table from active found set of data in DQL Mode or SQL Mode.
With query name, displays Batch Execution panel for query named.
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.
Displays current time and date.
Scrolls to the top of a multi-screen panel.
Entered on the report output panel, formats report to display only total lines and suppresses detail lines.
Entered on the report output panel, formats report to display only the results of DQL Mode WHEN/DO statements.
Moves off-screen lines to current screen of multi-screen display by wrapping each report line before starting the next report line.
|
Copyright © 2014 CA.
All rights reserved.
|
|