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] |