Index
500
about 73
DatabaseName connection parameter
about 73
databases
Adaptive Server Anywhere 6
Adaptive Server IQ data 6
benefits of denormalizing 455
block size 113
character set 336
checking consistency 393
choosing a location 110
connecting to 50, 77
creating 106
custom collations 351
default characteristics 108
denormalizing for performance 454
designing 99
displaying status information 9
displaying validation results 9
dropping 118
estimating space requirements 9
initializing 107
listing size 9
management tasks 2
managing 454
managing with Interactive SQL 101
moving 108
moving files 400
multiple on server 493
naming at startup 32
overview of setup 101
owner role 4
page size 111
permission to start 46
permissions 4, 36, 353
preallocating space 104
privileges needed to create 103
relative pathnames 109
security overview 3
size 111
stopping 47
temporary data 6
unloading 46
utility 18
validating 9
working with objects 99
DatabaseSwitches connection parameter
about 73
DataSourceName connection parameter
about 73
DATE
conversion option 204
load conversion option 210
DATE data type
specifying format for conversion 210
date data types
matching Adaptive Server Enterprise and Adaptive
Server IQ data 219
DATE format
converting two-digit dates 212
dates
procedures 266
DATETIME
conversion option 204
load conversion option 212
DATETIME data type 213
format for conversion 213
DBA (database administrator)
defined 354
responsibilities 2
role of 4
DBA authority
about 354
granting 358
not inheritable 363
DBASE format 172
DBCOLLAT utility 351
custom collations 349
DBF connection parameter
about 73
embedded databases 57
DBG connection parameter
about 73
DBISQL
command line parameters 55
committing transactions 289
inserting data interactively 195
introduction 101
logon window 56
See Also Interactive SQL 101
specifying output format 173
DB-Library