Overview of the Interactive SQL Service Facility

Overview of the Interactive SQL Service Facility

The following chapters describe the Interactive SQL Service Facility of CA Datacom Datadictionary online. The Service Facility is designed primarily to allow you to create and test SQL objects and execute certain SQL statements. See the list of SQL statements that you can submit in Executable SQL Statements.

• Using the Interactive SQL Service Facility

  Overview of the Interactive SQL Service Facility and using this mode in CA Datacom Datadictionary online. The following sections contain detailed information.

  • Executable SQL Statements
  • Specifying Unique SQL Names
  • Submitting SQL Statements
  • Using Commands
  • COPY SQL Command
  • DELETE SQL Command
  • DISPLAY SQL Command
  • EDIT SQL Command
  • EXECUTE Command
  • REBIND Command
  • SCROLL Command
  • Using Line Commands
  • Using Margin Commands
  • Using PF Keys
  • Maintaining Source and Output Members
  • Editing and Executing Source Members
  • Displaying Source and Output Members
  • Copying Source Members
  • Deleting Source and Output Members
• Creating SQL Objects

  Overview of the Data Definition Language statements you submit through the Interactive SQL Service Facility to create objects or alter a table. The following sections contain step-by-step instructions and examples.

  • Creating a Schema
  • Creating a Table
  • Altering a Table
  • Creating an Index
  • Creating a View
  • Creating a Synonym
  • Adding and Replacing Comments
• Deleting SQL Objects

  Overview of the DROP statement and its impact on definitions in CA Datacom Datadictionary. The following sections contain step-by-step instructions and examples.

  • Deleting a Schema
  • Dropping an Index
  • Dropping a Table
  • Dropping a View
  • Dropping a Synonym
• Manipulating Data in SQL Tables

  Overview of the Data Manipulation Language statements you can submit through the Interactive SQL Service Facility.

• Controlling Access Through SQL Statements

  Overview of the Data Control Language statements you can submit through the Interactive SQL Service Facility.

• Performing SQL Administrative Tasks

  Overview of the administrative tasks which can be performed for SQL processing using the Interactive SQL Service Facility The following sections contain step-by-step instructions and examples.

  • Setting the Session Authorization ID
  • Deleting a Plan
  • Rebinding a Plan
  • Displaying Index of SQL Plans
  • Specifying Plan Options in a Source Member
  • Coding Plan Options

Note: For information about the CA Datacom/DB implementation of support for procedures and triggers, see Procedures and Triggers and Datadictionary Support for Triggers and Procedures.