Previous Topic: Mixed Mode ProgrammingNext Topic: Dynamic SQL

Getting Started › Statement Execution Table

Statement Execution Table

The following table summarizes the methods by which each SQL statement can be executed. An asterisk indicates that the statement is executable by that method.

SQL Statement

CA Datacom Datadictionary
Interactive SQL
Service Facility
(Interactive)

In an application
program
prepared using
an CA Datacom/DB
SQL Preprocessor
(Embedded)

CA Dataquery
(SQL & Batch
Modes)

ALTER TABLE

*

*

*

CALL

YES (if no
parms are passed)

*

YES (if no
parms are passed)

CLOSE

 

*

 

COMMENT ON

*

*

*

COMMIT WORK

*

*

 

CREATE INDEX

*

*

*

CREATE PROCEDURE

*

*

*

CREATE RULE

*

*

*

CREATE SCHEMA

*

*

 

CREATE SYNONYM

*

*

*

CREATE TABLE

*

*

*

CREATE TRIGGER

*

*

*

CREATE VIEW

*

*

*

DECLARE CURSOR

 

*

 

DECLARE STATEMENT

*

 

 

DELETE (positioned)

 

*

 

DELETE (searched)

*

*

*

DESCRIBE

 

*

 

DROP INDEX

*

*

 

DROP RULE

*

*

*

DROP PROCEDURE

*

*

*

DROP SYNONYM

*

*

*

DROP TABLE

*

*

*

DROP TRIGGER

*

*

*

DROP VIEW

*

*

*

EXECUTE

 

*

 

EXECUTE IMMEDIATE

 

*

 

EXECUTE PROCEDURE

YES (if no
parms are passed)

*

YES (if no
parms are passed)

FETCH

 

*

 

GRANT

*

*

*

INSERT

*

*

*

LOCK TABLE

*

*

 

OPEN

 

*

 

PREPARE

 

*

 

REVOKE

*

*

*

ROLLBACK WORK

*

*

 

select-into statement

 

*

 

select-statement

*

(use
DECLARE CURSOR)

*

full-select statement

(part of the
select-statement)

(part of the
select-statement)

(part of the
select-statement)

subselect

(part of full-select statement)

(part of full-select statement)

(part of full-select statement)

SET CURRENT SQLID

 

*

 

UPDATE (positioned)

 

*

 

UPDATE (searched)

*

*

*

WHENEVER

 

*