CA Dataquery Operation Commands

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.
datacom151
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.
The following topics are discussed on this page:
 
 
Using Operands
Some 
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, 
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 
Dataquery
 processes, such as directory displays. If <PF2> RETURN is used on a function initiated by a command, 
Dataquery
 returns to the Main Menu.
Operation Commands Summary
The following summarizes valid user 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 
    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.
  •  
    Displays Directory Selection panel.
  •  
    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.
  •  
    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.
  •  
     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.
  •  
    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.
  •  
     NOWRAP 
    Issue after WRAP command to return wrapped report lines to multi-screen display.
  •  
     OFF 
    Signs 
    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.
  •  
    Displays User Profile panel.
  •  
     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.
  •  
    SQL
    Changes mode of operation from DQL Mode to SQL Mode. To use personal tables, the SQL option of 
    Datacom/DB
     must be installed at your site and you must be authorized by your 
    Dataquery
     Administrator to access the Personal Database Facility.
  •  
     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.
  •  
    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.