Using the Interactive SQL Service Facility

Using the Interactive SQL Service Facility

You can use the online panels in the CA Datacom Datadictionaryy Interactive SQL Service Facility for data definition, manipulation and control, and to perform administrative tasks associated with SQL usage. You must be authorized in CA Datacom Datadictionary to use the Interactive SQL Service Facility. See the person responsible for CA Datacom Datadictionary security on your system for authorization.

You should be familiar with the SQL relational sub-language and its languages, listed following, before you use the Interactive SQL Service Facility.

Data Definition Language (DDL)

You can use specific SQL statements to create indexes, tables, and views, create schemas, create alternative names (synonyms) for tables and views, and enter descriptive information. You can also remove definitions.

Note: Because DDL statements are not recorded to the Log Area (LXX), they are not recoverable using the RECOVERY function of the CA Datacom/DB Utility (DBUTLTY). In the case of DDL statements, it is therefore your responsibility to ensure the existence of the Directory (CXX) definitions necessary for recovery.

Data Manipulation Language (DML)

You can use specific SQL statements to insert, update, and delete the data in the production database.

SQL Control Statements

includes the CALL and EXECUTE PROCEDURE statements that support the CA Datacom/DB implementation of procedures and triggers (see Procedures and Triggers and Datadictionary Support for Triggers and Procedures).