Index
513
locking 299
owner 355
permissions 355
qualified names 365, 367
See Also information in system tables 12
tabular data stream (TDS)
about 481
tape devices
for backup 385
TCP/IP
addresses 485
Open Server 489
TDS
about 481
TEMP environment variable
disk space 93
TEMP_CACHE_MEMORY_MB option 427
temporary storage
option to save space 312
Temporary Store
about 6
buffer cache size 427
temporary tables
about 120
loading 120
versioning 298
terminators
LOAD TABLE statement 177
The 439, 450
threads
management options 440
throughput 419
time data types
matching Adaptive Server Enterprise and Adaptive
Server IQ data 219
times
procedures 266
TMP environment variable
disk space 93
top table
size and performance 156
TRACEBACK function 257
transaction log
about 445
in system recovery 308
renaming 405
transaction processing
about 287
transactions
about 287
cursors in 311
definition 287
ending 288
in recovery 307
procedures 265
rolling back 307
savepoints 305
starting 288
subtransactions and savepoints 305
Translation driver
ODBC configuration 67
translation drivers
ODBC 348
troubleshooting
database connections 77
server address 487
server startup 94
startup, shutdown, and connections 93
TSQL_HEX_CONSTANT option
Open Client 491
TSQL_VARIABLES option
Open Client 491
U
UID connection parameter
about 73
UNC connection parameter
about 73
Unconditional connection parameter
73
Unicode character sets
about 336
UNIQUE constraints 277
UNIX
ODBC support 72
unloading data
from pre-Version 12 Adaptive Server IQ 186
unwired memory 436
setting iqsmem switch 35
UPDATE statement