Sybase Adaptive Server Anywhere - Page 4

iv
The Server Location utility ....................................................125
The Service Creation utility...................................................126
The Spawn utility...................................................................129
The Stop utility ......................................................................130
The Transaction Log utility....................................................132
The Uncompression utility.....................................................136
The Unload utility ..................................................................138
The Upgrade utility................................................................145
The Validation utility..............................................................148
The Write File utility ..............................................................151
5 Database Options.......................................................... 155
Introduction to database options...........................................156
General database options.....................................................161
Transact-SQL and SQL/92 compatibility options..................163
Replication options................................................................166
Interactive SQL options.........................................................167
Alphabetical list of options ....................................................169
6 SQL Language Elements .............................................. 219
Keywords ..............................................................................220
Identifiers...............................................................................223
Strings...................................................................................224
Operators ..............................................................................225
Expressions...........................................................................230
Search conditions .................................................................239
Special values.......................................................................247
Variables ...............................................................................250
Comments.............................................................................259
NULL value ...........................................................................260
7 SQL Data Types............................................................. 263
Character data types.............................................................264
Numeric data types...............................................................268
Money data types..................................................................275
Bit data type ..........................................................................276
Date and time data types......................................................277
Binary data types ..................................................................284
Domains................................................................................286
Java class data types............................................................288
Data type conversions ..........................................................293
Java / SQL data type conversion..........................................294
Year 2000 compliance ..........................................................297