ASA SQL Reference

SQL Statements

About this chapter 

This chapter presents detailed descriptions of SQL statements in alphabetical order.

Using the SQL statement reference
ALLOCATE DESCRIPTOR statement [ESQL]
ALTER DATABASE statement
ALTER DBSPACE statement
ALTER EVENT statement
ALTER FUNCTION statement
ALTER INDEX statement
ALTER PROCEDURE statement
ALTER PUBLICATION statement
ALTER REMOTE MESSAGE TYPE statement [SQL Remote]
ALTER SERVER statement
ALTER SERVICE statement
ALTER SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]
ALTER SYNCHRONIZATION USER statement [MobiLink]
ALTER TABLE statement
ALTER TRIGGER statement
ALTER VIEW statement
ALTER WRITEFILE statement
BACKUP statement
BEGIN statement
BEGIN TRANSACTION statement
CALL statement
CASE statement
CHECKPOINT statement
CLEAR statement [Interactive SQL]
CLOSE statement [ESQL] [SP]
COMMENT statement
COMMIT statement
CONFIGURE statement [Interactive SQL]
CONNECT statement [ESQL] [Interactive SQL]
CREATE COMPRESSED DATABASE statement
CREATE DATABASE statement
CREATE DBSPACE statement
CREATE DECRYPTED FILE statement
CREATE DOMAIN statement
CREATE ENCRYPTED FILE statement
CREATE EVENT statement
CREATE EXISTING TABLE statement
CREATE EXTERNLOGIN statement
CREATE FUNCTION statement
CREATE INDEX statement
CREATE MESSAGE statement [T-SQL]
CREATE PROCEDURE statement
CREATE PROCEDURE statement [T-SQL]
CREATE PUBLICATION statement
CREATE REMOTE MESSAGE TYPE statement [SQL Remote]
CREATE SCHEMA statement
CREATE SERVER statement
CREATE SERVICE statement
CREATE STATISTICS statement
CREATE SUBSCRIPTION statement [SQL Remote]
CREATE SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]
CREATE SYNCHRONIZATION USER statement [MobiLink]
CREATE TABLE statement
CREATE TRIGGER statement
CREATE TRIGGER statement [SQL Remote]
CREATE TRIGGER statement [T-SQL]
CREATE VARIABLE statement
CREATE VIEW statement
CREATE WRITEFILE statement
DEALLOCATE statement
DEALLOCATE DESCRIPTOR statement [ESQL]
Declaration section [ESQL]
DECLARE statement
DECLARE CURSOR statement [ESQL] [SP]
DECLARE CURSOR statement [T-SQL]
DECLARE LOCAL TEMPORARY TABLE statement
DELETE statement
DELETE (positioned) statement [ESQL] [SP]
DESCRIBE statement [ESQL]
DISCONNECT statement [ESQL] [Interactive SQL]
DROP statement
DROP DATABASE statement
DROP CONNECTION statement
DROP EXTERNLOGIN statement
DROP PUBLICATION statement
DROP REMOTE MESSAGE TYPE statement [SQL Remote]
DROP SERVER statement
DROP SERVICE statement
DROP STATEMENT statement [ESQL]
DROP STATISTICS statement
DROP SUBSCRIPTION statement [SQL Remote]
DROP SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]
DROP SYNCHRONIZATION USER statement [MobiLink]
DROP VARIABLE statement
EXCEPT operation
EXECUTE statement [ESQL]
EXECUTE statement [T-SQL]
EXECUTE IMMEDIATE statement [SP]
EXIT statement [Interactive SQL]
EXPLAIN statement [ESQL]
FETCH statement [ESQL] [SP]
FOR statement
FORWARD TO statement
FROM clause
GET DATA statement [ESQL]
GET DESCRIPTOR statement [ESQL]
GET OPTION statement [ESQL]
GOTO statement [T-SQL]
GRANT statement
GRANT CONSOLIDATE statement [SQL Remote]
GRANT PUBLISH statement [SQL Remote]
GRANT REMOTE statement [SQL Remote]
GRANT REMOTE DBA statement [SQL Remote]
HELP statement [Interactive SQL]
IF statement
IF statement [T-SQL]
INCLUDE statement [ESQL]
INPUT statement [Interactive SQL]
INSERT statement
INSTALL JAVA statement
INTERSECT operation
LEAVE statement
LOAD STATISTICS statement
LOAD TABLE statement
LOCK TABLE statement
LOOP statement
MESSAGE statement
OPEN statement [ESQL] [SP]
OUTPUT statement [Interactive SQL]
PARAMETERS statement [Interactive SQL]
PASSTHROUGH statement [SQL Remote]
PREPARE statement [ESQL]
PREPARE TO COMMIT statement
PRINT statement [T-SQL]
PUT statement [ESQL]
RAISERROR statement [T-SQL]
READ statement [Interactive SQL]
READTEXT statement [T-SQL]
RELEASE SAVEPOINT statement
REMOTE RESET statement [SQL Remote]
REMOVE JAVA statement
REORGANIZE TABLE statement
RESIGNAL statement
RESTORE DATABASE statement
RESUME statement
RETURN statement
REVOKE statement
REVOKE CONSOLIDATE statement [SQL Remote]
REVOKE PUBLISH statement [SQL Remote]
REVOKE REMOTE statement [SQL Remote]
REVOKE REMOTE DBA statement [SQL Remote]
ROLLBACK statement
ROLLBACK TO SAVEPOINT statement
ROLLBACK TRIGGER statement
SAVEPOINT statement
SELECT statement
SET statement
SET statement [T-SQL]
SET CONNECTION statement [Interactive SQL] [ESQL]
SET DESCRIPTOR statement [ESQL]
SET OPTION statement
SET OPTION statement [Interactive SQL]
SET REMOTE OPTION statement [SQL Remote]
SET SQLCA statement [ESQL]
SETUSER statement
SIGNAL statement
START DATABASE statement
START ENGINE statement [Interactive SQL]
START JAVA statement
START LOGGING statement [Interactive SQL]
START SUBSCRIPTION statement [SQL Remote]
START SYNCHRONIZATION DELETE statement [MobiLink]
STOP DATABASE statement
STOP ENGINE statement
STOP JAVA statement
STOP LOGGING statement [Interactive SQL]
STOP SUBSCRIPTION statement [SQL Remote]
STOP SYNCHRONIZATION DELETE statement [MobiLink]
SYNCHRONIZE SUBSCRIPTION statement [SQL Remote]
SYSTEM statement [Interactive SQL]
TRIGGER EVENT statement
TRUNCATE TABLE statement
UNION operation
UNLOAD statement
UNLOAD TABLE statement
UPDATE statement
UPDATE (positioned) statement [ESQL] [SP]
UPDATE statement [SQL Remote]
VALIDATE INDEX statement
VALIDATE TABLE statement
WAITFOR statement
WHENEVER statement [ESQL]
WHILE statement [T-SQL]
WRITETEXT statement [T-SQL]