User's Guide Part VI. SQL Anywhere ReferenceThis chapter presents detailed descriptions of the SQL statements available in the Watcom-SQL language---one of two SQL dialects native to SQL Anywhere.
This chapter contains an alphabetical listing of all Watcom-SQL statements, including some that can only be used from Embedded SQL, and ISQL.
For information on Transact-SQL support, see the chapters "Using Transact-SQL with SQL Anywhere" and "Transact-SQL Procedure Language".
Descriptions of SQL, ISQL and Embedded SQL statements, as well as the elements that make up those statements, are included in this chapter.
ALLOCATE DESCRIPTOR statement ALTER DBSPACE statement ALTER PROCEDURE statement ALTER PUBLICATION statement ALTER REMOTE MESSAGE TYPE statement ALTER TABLE statement ALTER TRIGGER statement ALTER VIEW statement CALL statement CASE statement CHECKPOINT statement CLOSE statement COMMENT statement COMMIT statement Compound statements CONFIGURE statement CONNECT statement CREATE DATATYPE statement CREATE DBSPACE statement CREATE FUNCTION statement CREATE INDEX statement CREATE PROCEDURE statement CREATE PUBLICATION statement CREATE REMOTE MESSAGE TYPE statement CREATE SCHEMA statement CREATE SUBSCRIPTION statement CREATE TABLE statement CREATE TRIGGER statement CREATE VARIABLE statement CREATE VIEW statement DBTOOL statement Declaration section DECLARE CURSOR statement DECLARE TEMPORARY TABLE statement DEALLOCATE DESCRIPTOR statement DELETE statement DELETE (positioned) statement DESCRIBE statement DISCONNECT statement DROP statement DROP CONNECTION statement DROP OPTIMIZER STATISTICS statement DROP PUBLICATION statement DROP REMOTE MESSAGE TYPE statement DROP STATEMENT statement DROP VARIABLE statement DROP SUBSCRIPTION statement EXECUTE statement EXECUTE IMMEDIATE statement EXIT statement EXPLAIN statement FETCH statement FOR statement FROM clause GET DATA statement GET DESCRIPTOR statement GET OPTION statement GRANT statement GRANT CONSOLIDATE statement GRANT PUBLISH statement GRANT REMOTE statement HELP statement IF statement INCLUDE statement INPUT statement INSERT statement LEAVE statement LOAD TABLE statement LOOP statement MESSAGE statement NULL value OPEN statement OUTPUT statement PARAMETERS statement PASSTHROUGH statement PREPARE statement PREPARE TO COMMIT statement PUT statement READ statement RELEASE SAVEPOINT statement RESIGNAL statement RESUME statement RETURN statement REVOKE statement REVOKE CONSOLIDATE statement REVOKE PUBLISH statement REVOKE REMOTE statement ROLLBACK statement ROLLBACK TO SAVEPOINT statement ROLLBACK TRIGGER statement SAVEPOINT statement SELECT statement SET statement SET CONNECTION statement SET DESCRIPTOR statement SET OPTION statement SET SQLCA statement SIGNAL statement START DATABASE statement START ENGINE statement START SUBSCRIPTION statement STOP DATABASE statement STOP ENGINE statement STOP SUBSCRIPTION statement SYNCHRONIZE SUBSCRIPTION statement SYSTEM statement TRUNCATE TABLE statement UNION operation UNLOAD TABLE statement UPDATE statement UPDATE (positioned) statement VALIDATE TABLE statement WHENEVER statement