SQL Statements that DSQL Can Process
Go Up to Writing a DSQL Application
DSQL can process most but not all SQL statements. The following table lists SQL statement that are available to DSQL:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
The following ESQL statements cannot be processed by DSQL: CLOSE, DECLARE, CURSOR, DESCRIBE, EXECUTE, EXECUTE IMMEDIATE, FETCH, OPEN, PREPARE
.
The following ISQL commands cannot be processed by DSQL: BLOBDUMP
, EDIT
, EXIT
, HELP
, INPUT
, OUTPUT
, QUIT
, SET
, SET AUTODDL
, SET BLOBDISPLAY
, SET COUNT
, SET ECHO
, SET LIST
, SET NAMES
, SET PLAN
, SET STATS
, SET TERM
, SET TIME
, SHELL
, SHOW CHECK
, SHOW DATABASE
, SHOW DOMAINS
, SHOW EXCEPTIONS
, SHOW FILTERS
, SHOW FUNCTIONS
, SHOW GENERATORS
, SHOW GRANT
, SHOW INDEX
, SHOW PROCEDURES
, SHOW SYSTEM
, SHOW TABLES
, SHOW TRIGGERS
, SHOW VERSION
, SHOW VIEWS
.