Operation Commands › SQL - Change to SQL Mode

SQL - Change to SQL Mode

Purpose

Use the SQL command when you want to leave DQL Mode to use CA Dataquery for CA Datacom in SQL Mode. To use SQL, the SQL option of CA Datacom/DB must be installed at your site and you must be authorized by your CA Dataquery for CA Datacom Administrator to use SQL Mode.

When to Use It

To create, execute, or maintain SQL queries and dialogs.

Syntax

Example

 => sql
 
 ------------------------------------------------------------------------DQKE0
 DATAQUERY:  ADMINISTRATIVE MENU
 ----------------------------------------------------------------------------
 
 ENTER DESIRED OPTION NUMBER ===>  __
 
  1.  PROFILE               - Display and update user profile

Result

 =>
 
 ------------------------------------------------------------------------DQZ50
 DATAQUERY:  MAIN MENU
 
 ENTER THE NUMBER OF THE DESIRED FUNCTION ===>  _
 
  1.  DIRECTORIES         - Lists of Queries and Tables
  2.  CREATE              - Query, Dialog creation
  3.  GUIDE               - Structured query creation
  4.  PDB                 - List, create and maintain personal tables
  5.  ADMINISTRATION      - DATAQUERY system management
  6.  HELP                - Display Help Information
  7.  OFF                 - DATAQUERY session termination
 
 
 
 
 
 
 
 -----------------------------------------------------------------------------