Index

A

ABS function ABS function [Numeric]
ACOS function ACOS function [Numeric]
ActiveReq property Properties available for the server
Agent connection parameter Agent connection parameter
aggregate functions Aggregate functions
Alias property Properties available for each database
aliases : for columns SELECT statement
aliases : in the DELETE statement DELETE statement
ALL : conditions ALL or ANY conditions
ALL : keyword in SELECT statement SELECT statement
ALLOCATE DESCRIPTOR statement : syntax ALLOCATE DESCRIPTOR statement [ESQL]
allocating disk space ALTER DBSPACE statement
ALLOW_NULLS_BY_DEFAULT option Transact-SQLcompatibility options
ALLOW_NULLS_BY_DEFAULT option
ALTER DATABASE statement : syntax ALTER DATABASE statement
ALTER DBSPACE statement : syntax ALTER DBSPACE statement
ALTER PROCEDURE statement : syntax ALTER PROCEDURE statement
ALTER TABLE statement : syntax ALTER TABLE statement
ALTER TRIGGER statement : syntax ALTER TRIGGER statement
ALTER VIEW statement : syntax ALTER VIEW statement
ALTER WRITEFILE statement : syntax ALTER WRITEFILE statement
AND conditions Conditions with logical operators
ANSI : COMMIT behavior COOPERATIVE_COMMITS option
DELAYED_COMMITS option
ANSI : conformance SQL_FLAGGER_ERROR_LEVEL option
ANSI : cursors ANSI_CLOSE_CURSORS_ON_ROLLBACK option
ANSI : delete permissions ANSI_PERMISSIONS option
ANSI : update permissions ANSI_PERMISSIONS option
ANSI : variable behavior ANSI_BLANKS option
ANSINULL option ANSINULL option
ANSI_BLANKS option Transact-SQLcompatibility options
ANSI_BLANKS option
ANSI_CLOSE_CURSORS_ON_ROLLBACK option ANSI_CLOSE_CURSORS_ON_ROLLBACK option
ANSI_INTEGER_OVERFLOW option ANSI_INTEGER_OVERFLOW option
ANSI_PERMISSIONS option ANSI_PERMISSIONS option
ANY : conditions ALL or ANY conditions
APC_pw parameter The LTM configuration file
APC_user parameter The LTM configuration file
apostrophe : in strings Statement elements
approximate data types : about Numeric data types
ARGN function ARGN function [Miscellaneous]
arithmetic expressions Arithmetic operators
articles : system table for SYSARTICLE system table
SYSARTICLECOL system table
asademo.db file : about The sample database
ASCII : collating sequences Initialization utility options
ASCII file format INPUT_FORMAT option [ISQL
OUTPUT_FORMAT option [ISQL
ASCII function ASCII function [String]
ASIN function ASIN function [Numeric]
assertion failed error Internal errors (assertion failed)
AStart connection parameter AutoStart connection parameter [Astart]
AStop connection parameter AutoStop connection parameter [Astop]
Async2Read property Connection properties
Properties available for the server
asynchronous procedures : user ID for The LTM configuration file
AsyncRead property Connection properties
Properties available for the server
AsyncWrite property Connection properties
Properties available for the server
AT clause : create existing table CREATE EXISTING TABLE statement
ATAN function ATAN function [Numeric]
ATAN2 function ATAN2 function [Numeric]
auditing : controlling AUDITING option
AUDITING option General database options
AUDITING option
autoincrement : about CREATE TABLE statement
autoincrement : primary key values EXECUTE statement [ESQL]
automatic joins : and foreign keys Adaptive Server Anywhere SQL features
automatic joins : SELECT statement SELECT statement
AUTOMATIC_TIMESTAMP option Transact-SQLcompatibility options
AUTOMATIC_TIMESTAMP option
AutoStart connection parameter AutoStart connection parameter [Astart]
AutoStop connection parameter AutoStop connection parameter [Astop]
AUTO_COMMIT : Interactive SQL option AUTO_COMMIT option [ISQL
auto_commit : Interactive SQL option SET OPTION statement [ISQL]
AUTO_REFETCH : Interactive SQL option AUTO_REFETCH option [ISQL
AVG function AVG function [Aggregate]