| |
Home |
Return to Collection List
Enable Frames
| ASA Reference Manual |
![[+]](/dwicons/i_expand.gif)
| About This Book |
|
| Chapter 1: File Locations and Installation Settings |
|
| Chapter 2: The Database Server |
|
| Chapter 3: Connection and Communication Parameters |
|
| Chapter 4: Database Administration Utilities |
|
| Chapter 5: Database Options |
|
| Chapter 6: SQL Language Elements |
|
| Chapter 7: SQL Data Types |
|
| Chapter 8: SQL Functions |
![[-]](/dwicons/i_colpse.gif)
|
|
|
| Using the SQL statement reference |
| ALLOCATE DESCRIPTOR statement [ESQL] |
| ALTER DATABASE statement |
| ALTER DBSPACE statement |
| ALTER PROCEDURE statement |
| ALTER SERVER statement |
| ALTER TABLE statement |
| ALTER TRIGGER statement |
| ALTER VIEW statement |
| ALTER WRITEFILE statement |
| BACKUP statement |
| BEGIN... END statement |
| BEGIN TRANSACTION statement |
| CALL statement |
| CASE statement |
| CHECKPOINT statement |
| CLEAR statement [ISQL] |
| CLOSE statement [ESQL] [SP] |
| COMMENT statement |
| COMMIT statement |
| CONFIGURE statement [ISQL] |
| CONNECT statement [ESQL] [ISQL] |
| CREATE COMPRESSED DATABASE statement |
| CREATE DATABASE statement |
| CREATE DBSPACE statement |
| CREATE DOMAIN 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 SCHEMA statement |
| CREATE SERVER statement |
| CREATE TABLE statement |
| CREATE TRIGGER statement |
| CREATE TRIGGER statement [T-SQL] |
| CREATE VARIABLE statement |
| CREATE VIEW statement |
| CREATE WRITEFILE 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][ISQL] |
| DROP statement |
| DROP DATABASE statement |
| DROP CONNECTION statement |
| DROP EXTERNLOGIN statement |
| DROP OPTIMIZER STATISTICS statement |
| DROP SERVER statement |
| DROP STATEMENT statement [ESQL] |
| DROP VARIABLE statement |
| EXECUTE statement [ESQL] |
| EXECUTE statement [T-SQL] |
| EXECUTE IMMEDIATE statement [ESQL] [SP] |
| EXIT statement [ISQL] |
| 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 |
| HELP statement [ISQL] |
| IF statement |
| IF statement [T-SQL] |
| INCLUDE statement [ESQL] |
| INPUT statement [ISQL] |
| INSERT statement |
| INSTALL statement |
| LEAVE statement |
| LOAD TABLE statement |
| LOOP statement |
| MESSAGE statement |
| OPEN statement [ESQL] [SP] |
| OUTPUT statement [ISQL] |
| PARAMETERS statement [ISQL] |
| PREPARE statement [ESQL] |
| PREPARE TO COMMIT statement |
| PRINT statement [T-SQL] |
| PUT statement [ESQL] [SP] |
| RAISERROR statement [T-SQL] |
| READ statement [ISQL] |
| READTEXT statement [T-SQL] |
| RELEASE SAVEPOINT statement |
| REMOVE statement |
| RESIGNAL statement |
| RESTORE statement |
| RESUME statement |
| RETURN statement |
| REVOKE statement |
| ROLLBACK statement |
| ROLLBACK TO SAVEPOINT statement |
| ROLLBACK TRIGGER statement |
| SAVEPOINT statement |
| SELECT statement |
| SET statement |
| SET statement [T-SQL] |
| SET CONNECTION statement [ISQL][ESQL] |
| SET DESCRIPTOR statement [ESQL] |
| SET OPTION statement |
| SET OPTION statement [ISQL] |
| SET SQLCA statement [ESQL] |
| SETUSER statement |
| SIGNAL statement |
| START DATABASE statement [ISQL] |
| START ENGINE statement [ISQL] |
| START JAVA statement |
| STOP DATABASE statement [ISQL] |
| STOP ENGINE statement [ISQL] |
| STOP JAVA statement |
| SYSTEM statement [ISQL] |
| TRUNCATE TABLE statement |
| UNION operation |
| UNLOAD TABLE statement |
| UPDATE statement |
| UPDATE (positioned) statement |
| VALIDATE TABLE statement |
| WHENEVER statement [ESQL] |
| WHILE statement [T-SQL] |
| WRITETEXT statement [T-SQL] |
|
| Chapter 10: Database Error Messages |
|
| Chapter 11: SQL Preprocessor Error Messages |
|
| Chapter 12: Differences from Other SQL Dialects |
|
| Chapter 13: Physical Limitations |
|
| Chapter 14: System Procedures and Functions |
|
| Chapter 15: System Tables |
|
| Chapter 16: System Views |
|
| Appendix A: Database Performance and Connection Properties |