Index

D

daemon : running the server as -ud command-line option
data type conversion : about Data type conversions
data type conversion : errors CONVERSION_ERROR option
data type conversion : functions Data type conversion functions
data type conversion : Java-to-SQL Java to-SQL-data type conversion
data type conversion : SQL-to-Java SQL-to-Java data type conversion
data types SYSSERVERS system table
data types : about CHAPTER 7. SQL Data Types
data types : and roundoff errors Numeric data types
data types : binary Binary data types
data types : bit Bit data type
data types : character Character data types
data types : compatibility Compatibility of string-to-date/time conversions
data types : converting Java and SQL Java / SQL data type conversion
data types : creating CREATE DOMAIN statement
data types : date Date and time data types
data types : dropping user-defined DROP statement
data types : in the system tables SYSDOMAIN system table
SYSUSERTYPE system table
data types : Java class Java class data types
data types : money Money data types
data types : numeric Numeric data types
data types : time Date and time data types
data types : user-defined User-defined data types
CREATE DOMAIN statement
SYSUSERTYPE system table
data types in system tables SYSEXTENT system table
SYSEXTERNLOGINS system table
database files : creating CREATE DBSPACE statement
database files : dbspaces CREATE DBSPACE statement
database files : deleting DROP DATABASE statement
database files : erasing The Erase utility
database files : storing indexes in CREATE INDEX statement
database files : uncompressing The DBEXPAND command-line utility
database information The DBINFO command-line utility
database name : setting - n command-line option
database options : cursors Duration of options
database options : DATE_ORDER Unambiguous dates and times
database options : duration Duration of options
database options : initial settings Initial option settings
sp_login_environment system procedure
sp_tsql_environment system procedure
database options : QUOTED_IDENTIFIER The quoted_identifier option
database options : Transact-SQL compatibility sp_tsql_environment system procedure
database pages : displaying size of The Information utility
database properties : displaying System and catalog stored procedures
database schema : about CHAPTER 15. System Tables
database server : command line The database server
database server : name - n command-line option
database server : NetWare The database server
database server : shutting down -tq time command-line option
database servers : preventing from starting AutoStart connection parameter [Astart]
database servers : starting START ENGINE statement [ISQL]
database servers : stopping Unconditional connection parameter [UNC]
STOP ENGINE statement [ISQL]
database size : limit Size and number limitations
database statistics : about Monitoring database statistics from the Windows NT Performance Monitor
DatabaseFile connection parameter DatabaseFile connection parameter [DBF]
DatabaseName connection parameter DatabaseName connection parameter [DBN]
databases : automatic stopping -ga command-line option
databases : backing up BACKUP statement
databases : compressed The DBEXPAND command-line utility
CREATE COMPRESSED DATABASE statement
databases : CREATE DATABASE statement CREATE DATABASE statement
databases : creating The DBINIT command-line utility
databases : deleting files DROP DATABASE statement
databases : erasing The Erase utility
databases : files SYSFILE system table
databases : information The Information utility
databases : initializing The DBINIT command-line utility
databases : loading data into LOAD TABLE statement
databases : page usage The Information utility
databases : permissions to start -gd command-line option
databases : permissions to stop -gk command-line option
databases : properties of Properties available for each database
databases : rebuilding The REBUILD component
databases : schema CHAPTER 15. System Tables
databases : starting START DATABASE statement [ISQL]
databases : stopping The DBSTOP command-line utility
STOP DATABASE statement [ISQL]
databases : structure CHAPTER 15. System Tables
databases : system procedures CHAPTER 14. System Procedures and Functions
databases : system tables CHAPTER 15. System Tables
databases : unloading The Unload utility
The DBUNLOAD command-line utility
databases : unloading tables from UNLOAD TABLE statement
databases : upgrading The Upgrade utility
Upgrading a database from Sybase Central
The DBUPGRAD command-line utility
ALTER DATABASE statement
databases : validating sa_validate system procedure
databases : write files The DBWRITE command-line utility
DatabaseSwitches connection parameter DatabaseSwitches connection parameter [DBS]
datalength Adaptive Server Enterprise function Connection properties
DATALENGTH function DATALENGTH function [System]
DATALENGTH function [System]
DataSourceName connection parameter DataSourceName connection parameter [DSN]
data_pgs Adaptive Server Enterprise function Connection properties
date and time functions Date and time functions
DATE data type : about DATE data type [Date and Time]
date format : database option DATE_FORMAT option
DATE function DATE function [Date and time]
date order : database option DATE_ORDER option
date to string conversions Date to string conversions
DATEADD function DATEADD function [Date and time-TSQL]
DATEDIFF function DATEDIFF function [Date and time-TSQL]
DATEFORMAT function DATEFORMAT function [Date and time]
DATENAME function DATENAME function [Date and time-TSQL]
DATEPART function DATEPART function [Date and time-TSQL]
dates Sending dates and times to the database
dates : ambiguous string conversions Ambiguous string to date conversions
Date to string conversions
dates : comparing Date and time comparisons
dates : conversion problems Date to string conversions
dates : interpreting strings as dates Unambiguous dates and times
dates : queries Retrieving dates and times from the database
dates : unambiguous specification of Unambiguous dates and times
dates : year 2000 Year 2000 compliance
DATETIME function DATETIME function [Date and time]
DATE_FORMAT option General database options
DATE_FORMAT option
DATE_ORDER option General database options
DATE_ORDER option
Unambiguous dates and times
DATE_ORDER option : and ODBC Unambiguous dates and times
DAY function DAY function [Date and time]
DAYNAME function DAYNAME function [Date and time]
DAYS function DAYS function [Date and time]
DBA authority : in the system tables SYSUSERPERM system table
dBASE file format INPUT_FORMAT option [ISQL
OUTPUT_FORMAT option [ISQL
DBBACKUP Backup utility options
DBBACKUP : command line The DBBACKUP command-line utility
dbcc function Transaction log utility options
dbcli6 : command line The client compatibility executable
DBCOLLAT The DBCOLLAT command-line utility
DBCONSOL : command line The Console utility
dbeng6 command line The database server
DBERASE The Erase utility
DBEXPAND The DBEXPAND command-line utility
DBF connection parameter DatabaseFile connection parameter [DBF]
DBG connection parameter Debug connection parameter [DBG]
DBINFO The DBINFO command-line utility
dbinit utility : command line The DBINIT command-line utility
dbisql : command line The Interactive SQL utility
dblgen6.res : locating How Adaptive Server Anywhere locates files
DBLOG : command line The DBLOG command-line utility
dbltm utility : about The Log Transfer Manager
DBN connection parameter DatabaseName connection parameter [DBN]
DBNumber property Connection properties
dbo user : system objects The Unload utility
dbping The DBPing utility
DBS connection parameter DatabaseSwitches connection parameter [DBS]
DBSHRINK The DBSHRINK command-line utility
DBSPACE : SYSFILE system table SYSFILE system table
dbspaces : altering ALTER DBSPACE statement
dbspaces : creating CREATE DBSPACE statement
dbspaces : dropping DROP statement
dbspaces : limit Size and number limitations
dbsrv6 command line The database server
DBSTOP The DBSTOP command-line utility
dbstop utility : permissions -gk command-line option
DBTRAN : command line The DBTRAN command-line utility
DBUNLOAD The DBUNLOAD command-line utility
DBUPGRAD The DBUPGRAD command-line utility
DBWRITE The DBWRITE command-line utility
db_id Adaptive Server Enterprise function Connection properties
DB_ID function DB_ID function [System]
db_name Adaptive Server Enterprise function Connection properties
DB_NAME function DB_NAME function [System]
DB_PROPERTY function DB_PROPERTY function [System]
db_property function : about Obtaining database statistics from a client application
DDE : about - x command-line option
deadlock : identifying sa_conn_info system procedure
DEALLOCATE DESCRIPTOR : syntax DEALLOCATE DESCRIPTOR statement [ESQL]
Debug connection parameter Debug connection parameter [DBG]
DECIMAL data type : about DECIMAL data type [Numeric]
decimal precision : database option PRECISION option
declaration section Declaration section [ESQL]
DECLARE CURSOR statement : syntax DECLARE CURSOR statement [ESQL] [SP]
DECLARE CURSOR statement [T-SQL]
DECLARE LOCAL TEMPORARY TABLE statement : syntax DECLARE LOCAL TEMPORARY TABLE statement
DECLARE statement : compound statements BEGIN... END statement
DECLARE statement : syntax BEGIN... END statement
DECLARE statement
DECLARE statement : Transact-SQL compatibility BEGIN... END statement
defaults : autoincrement CREATE TABLE statement
defaults : CURRENT DATE Constants in expressions
defaults : CURRENT PUBLISHER Constants in expressions
defaults : CURRENT TIME Constants in expressions
defaults : CURRENT TIMESTAMP Constants in expressions
defaults : CURRENT USER Constants in expressions
defaults : LAST USER Constants in expressions
defaults : NULL Constants in expressions
defaults : SQLCODE Constants in expressions
defaults : SQLSTATE Constants in expressions
DEFAULT_TIMESTAMP_INCREMENT option General database options
DEFAULT_TIMESTAMP_INCREMENT option
DEGREES function DEGREES function [Numeric]
DELAYED_COMMITS option DELAYED_COMMITS option
DELAYED_COMMIT_TIMEOUT option General database options
DELAYED_COMMIT_TIMEOUT option
DELETE positioned statement : syntax DELETE (positioned) statement [ESQL] [SP]
DELETE statement : syntax DELETE statement
deletes : ANSI behavior ANSI_PERMISSIONS option
deletes : Transact-SQL permissions ANSI_PERMISSIONS option
DELETE_OLD_LOGS : replication option DELETE_OLD_LOGS option
DELETE_OLD_LOGS option : resetting truncation offset Transaction log utility options
DELETE_OLD_LOGS option : transaction log options Transaction log utility options
deleting all rows from a table TRUNCATE TABLE statement
derived tables : FROM clause FROM clause
desciptors : setting SET DESCRIPTOR statement [ESQL]
DESCRIBE statement : long column names DESCRIBE statement [ESQL]
DESCRIBE statement : syntax DESCRIBE statement [ESQL]
DESCRIBE_JAVA_FORMAT option DESCRIBE_JAVA_FORMAT option [ISQL]
descriptor : allocating memory ALLOCATE DESCRIPTOR statement [ESQL]
descriptor : deallocating DEALLOCATE DESCRIPTOR statement [ESQL]
descriptor : DESCRIBE statement DESCRIBE statement [ESQL]
descriptor : EXECUTE statement EXECUTE statement [ESQL]
descriptor : FETCH statement FETCH statement [ESQL] [SP]
descriptor : getting GET DESCRIPTOR statement [ESQL]
descriptor : PREPARE statement PREPARE statement [ESQL]
descriptor : UPDATE (positioned) statement UPDATE (positioned) statement
descriptor PUT statement PUT statement [ESQL] [SP]
DIF file format INPUT_FORMAT option [ISQL
OUTPUT_FORMAT option [ISQL
DIFFERENCE function DIFFERENCE function [String]
digits : maximum number PRECISION option
DIRECTFS.NLM The database server
directories : executable Installed files
directories : installation Installed files
directory structure Installation directory structure
DisableMultiRowFetch connection parameter DisableMultiRowFetch connection parameter [DMRF]
DISCONNECT statement : syntax DISCONNECT statement [ESQL][ISQL]
disk access : asynchronous -di command-line option
-df command-line option
disk access : switches - d command-line option
disk cache : operating system - u command-line option
DiskRead property Connection properties
Properties available for the server
DiskReadIndInt property Connection properties
Properties available for the server
DiskReadIndLeaf property Connection properties
Properties available for the server
DiskReadTable property Connection properties
Properties available for the server
DiskSyncRead property Connection properties
Properties available for the server
DiskSyncWrite property Connection properties
Properties available for the server
DiskWaitRead property Connection properties
Properties available for the server
DiskWaitWrite property Connection properties
Properties available for the server
DiskWrite property Connection properties
Properties available for the server
DISTINCT keyword SELECT statement
DIVIDE_BY_ZERO_ERROR option DIVIDE_BY_ZERO_ERROR option
DLL : location How Adaptive Server Anywhere locates files
DLL communication parameter DLL parameter
DMRF connection parameter DisableMultiRowFetch connection parameter [DMRF]
DOBROADCAST communication parameter DOBROADCAST parameter
documentation : conventions Documentation conventions
domains CREATE DOMAIN statement
dot operator : and >> Java expressions
DOUBLE data type : about DOUBLE data type [Numeric]
DOW function DOW function [Date and time]
DROP CONNECTION statement : syntax DROP CONNECTION statement
DROP DATABASE statement : syntax DROP DATABASE statement
DROP DATATYPE statement : syntax DROP statement
DROP DBSPACE statement : syntax DROP statement
DROP DOMAIN statement : syntax DROP statement
DROP FUNCTION statement : syntax DROP statement
DROP INDEX statement : syntax DROP statement
DROP OPTIMIZER STATISTICS statement : syntax DROP OPTIMIZER STATISTICS statement
DROP PROCEDURE statement : syntax DROP statement
DROP statement : syntax DROP statement
DROP STATEMENT statement : syntax DROP STATEMENT statement [ESQL]
DROP TABLE statement : syntax DROP statement
DROP TRIGGER statement : syntax DROP statement
DROP VARIABLE statement : syntax DROP VARIABLE statement
DROP VIEW statement : syntax DROP statement
dropping : users REVOKE statement
DSN connection parameter DataSourceName connection parameter [DSN]
DYNAMIC SCROLL cursors DECLARE CURSOR statement [ESQL] [SP]