Index
496
recovering from errors 389
responsibilities 415
scheduling 414
specifying tape devices on NT 386
third party 390
unattended 382, 409
wait time 388
base tables 120
batches
about 229, 238
control statements 239
data definition statements 239
SQL statements allowed 267
BIT data
converting 207
indexes allowed in 143
blanks
converting to NULLs 215
BLOCK FACTOR
BACKUP statement option 388
load option 181, 431
BLOCK SIZE
LOAD TABLE option 182
block size 113
relationship to IQ page size 430
buffer cache
monitoring 467
buffer cache monitor 467
examples 473
buffer caches 427
determining sizes 422
example 426
setting sizes 427
buffer manager
thrashing 476
buffer size
ODBC configuration 70
buffer space
ODBC configuration 70
buffers
disabling operating system buffering 437
build number 17
BYTE ORDER option
LOAD TABLE statement 182
C
-c switch 35
cache
See Also buffer cache 467
writing to 289
cache pages
prefetching 450
cache size
setting for Catalog Store 35
CALL statement
about 229
examples 232
parameters 245
syntax 239
case sensitivity
collations 342
command line 29
database and server names 32
international aspects 322
CASE statement
syntax 239
CATALOG ONLY
RESTORE option 407
Catalog Store
about 6
setting cache size 35
CBSize connection parameter
about 73
CBSpace connection parameter
about 73
CHAINED option
Open Client 491
CHAR data
zero-length cells 210
character data types
matching Adaptive Server Enterprise and Adaptive
Server IQ data 219
character set
application 325
determining 325
server 325
character set translation
about 348
error messages 336
character sets
about 315