Index 339
TO_VIEW= statement, CV2VIEW proce-
dure 281
trace information 222, 225
trace information for threaded reads 44
TRACE= option, SAS/ACCESS LIBNAME state-
ment 129
TRACEFILE= option, SAS/ACCESS LIBNAME
statement 130
TRAP151= data set option 213
triggers 22
truncating data 173
Two Pass Processing 47
TYPE statement, DBLOAD procedure (relational
databases) 324
U
UID statement, CV2ODBC procedure 287
UNION operations, passing to DBMS 37
UNIQUE statement, ACCESS procedure (rela-
tional databases) 308
unsupported characters, replacing 12
UPDATE statement, ACCESS procedure (rela-
tional databases) 308
UPDATE statement, including in SQL EXE-
CUTE 235
UPDATEBUFF= data set option 217
UPDATEBUFF= option, SAS/ACCESS LIB-
NAME statement 134
UPDATE_ISOLATION_LEVEL= data set op-
tion 214
UPDATE_ISOLATION_LEVEL= option, SAS/
ACCESS LIBNAME statement 130
UPDATE_LOCK_TYPE= data set option 215
UPDATE_LOCK_TYPE= option, SAS/ACCESS
LIBNAME statement 131
UPDATE_MODE_WAIT= data set option 216
UPDATE_MODE_WAIT= option, SAS/ACCESS
LIBNAME statement 132
UPDATE_MULT_ROWS= option, SAS/ACCESS
LIBNAME statement 132
UPDATE_SQL= data set option 216
UPDATE_SQL= option, SAS/ACCESS LIB-
NAME statement 133
updating DBMS data, ACCESS statement 52
USE_ODBC_CL= option, SAS/ACCESS LIB-
NAME statement 135
USER= statement, CV2ODBC procedure 287
V
VALIDVARNAME= option, CONNECT state-
ment 10, 17, 231
VALIDVARNAME system option 225
variable names 225
variable names and column/table names 10, 11
view descriptors 6, 309
AS/400 289
converting into PROC SQL views 6
converting into PROC SQL views, exam-
ples 282
MS SQL server 290
VIEW option, REPLACE statement
(CV2VIEW) 279
VIEWDESC= option, PROC ACCESS statement
(relational databases) 298
views of DBMS data 5, 6
deļ¬ning 24
W
WHERE clauses, optimizing 37
passing to DBMS 38
WHERE statement, DBLOAD procedure (rela-
tional databases) 325
writing data library attributes to SAS log 66
