Index

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

513

Page 533
Image 533
Sybase 12.4.2 manual 513