Executable SQL Statements

Using the Interactive SQL Service Facility › Executable SQL Statements

Executable SQL Statements

You can execute the following SQL statements in the Interactive SQL Service Facility of CA Datacom Datadictionary online. The following table lists the SQL statements in each language:

Data Definition Language (DDL)	Data Manipulation Language (DML)	SQL Control Statements
ALTER TABLE COMMENT ON CREATE INDEX CREATE PROCEDURE CREATE RULE CREATE SCHEMA CREATE SYNONYM CREATE TABLE CREATE TRIGGER CREATE VIEW DROP GRANT REVOKE	Non-cursor operations: DELETE (searched DELETE) INSERT SELECT UPDATE (searched UPDATE)	CALL EXECUTE PROCEDURE

Data Definition Language (DDL)

Data Manipulation Language (DML)

SQL Control Statements

ALTER TABLE
COMMENT ON
CREATE INDEX
CREATE PROCEDURE
CREATE RULE
CREATE SCHEMA
CREATE SYNONYM
CREATE TABLE
CREATE TRIGGER
CREATE VIEW
DROP
GRANT
REVOKE

Non-cursor operations:

DELETE (searched DELETE)
INSERT
SELECT
UPDATE (searched UPDATE)

CALL
EXECUTE PROCEDURE