Other Modes › SQL Mode - Interactive SQL Service Facility

SQL Mode - Interactive SQL Service Facility

Use the Interactive SQL Service Facility to edit and execute SQL statements, to perform administrative functions such as deleting or rebinding plans, and to set session default authorization identifiers.

If you are authorized to use this mode, the Interactive SQL Service Facility Menu displays when you select the SQL Mode.

 =>
 =>
 =>

 -----------------------------------------------------------------------------
 Interactive SQL Service Facility

 Enter desired option number ===> __    (There are 05 options on the menu)

  1. SQLMAINT                     SQL member maintenance/execution
  2. SQLADMIN                     SQL administrative functions
  3. SET MODE                     Reset DATADICTIONARY processing mode
  4. IDEAL                        Transfer to IDEAL application
  5. OFF                          End session

Note: If CA Ideal is not installed on your system, the OFF option appears in place of the CA Ideal option on the preceding panel.

For more information about the Interactive SQL Service Facility, see the CA Datacom/DB SQL User Guide.