338 Index
PRESERVE_COL_NAMES= option, SAS/AC-
CESS LIBNAME statement 112
PRESERVE_NAMES= option, LIBNAME state-
ment 15
PRESERVE_TAB_NAMES= option, LIBNAME
statement 10
PRESERVE_TAB_NAMES= option, SAS/AC-
CESS LIBNAME statement 113
PROC CV2ODBC statement, CV2ODBC proce-
dure 286
PROC SQL views 6
converting view descriptors into 6
converting view descriptors into, exam-
ples 282
embedded LIBNAME statements in 66
prompting window 94, 184
PWD statement, CV2ODBC procedure 288
Q
QUALIFIER= data set option 202
QUALIFIER= option, SAS/ACCESS LIBNAME
statement 115
QUALIFY_ROWS= option, SAS/ACCESS LIB-
NAME statement 116
QUERY_TIMEOUT= data set option 203
QUERY_TIMEOUT= option, SAS/ACCESS LIB-
NAME statement 117
QUIT statement, ACCESS procedure (relational
databases) 303
QUIT statement, DBLOAD procedure (relational
databases) 321
QUOTE_CHAR= option, SAS/ACCESS LIB-
NAME statement 117
QUOTED_IDENTIFIER= option, SAS/ACCESS
LIBNAME statement 118
R
RANK procedure 257
RDBCONST= data set option 203
RDBLOCK= data set option 205
READBUFF= data set option 208
READBUFF= option, SAS/ACCESS LIBNAME
statement 121
reading DBMS data, ACCESS statement 52
READ_ISOLATION_LEVEL= data set op-
tion 206
READ_ISOLATION_LEVEL= option, SAS/AC-
CESS LIBNAME statement 119
READ_LOCK_TYPE= data set option 207
READLOCK_TYPE= option, LIBNAME state-
ment 26
READ_LOCK_TYPE= option, SAS/ACCESS
LIBNAME statement 119
READ_MODE_WAIT= data set option 208
READ_MODE_WAIT= option, SAS/ACCESS
LIBNAME statement 121
remote DBMS, assigning libref to 68
RENAME statement, ACCESS procedure (rela-
tional databases) 304
RENAME statement, DBLOAD procedure (rela-
tional databases) 322
repeatedly accessing data 30
REPLACE statement, CV2ODBC proce-
dure 289
REPLACE statement, CV2VIEW procedure 279
REREAD_EXPOSURE= option, SAS/ACCESS
LIBNAME statement 122
RESET statement, ACCESS procedure (relational
databases) 305
RESET statement, DBLOAD procedure (rela-
tional databases) 322
retrieval limits, setting 29
return codes, Pass-Through Facility 228
REVOKE statement, including in SQL EXE-
CUTE 235
S
sample data 271
SAS/ACCESS LIBNAME statement, relational
databases
See LIBNAME statement, relational databases
SAS/ACCESS views (view descriptors) 6
converting into PROC SQL views 6
converting into PROC SQL views, exam-
ples 282
SAS data libraries
clearing librefs 66
writing attributes to SAS log 66
SAS data sets
combining DBMS data and SAS data 243
creating from DBMS data 242
creating with UPDATE statement 245
reading data from multiple data sets 244
SAS log, writing data library attributes to 66
SAS system options 220
SASDATEFMT= data set option 209
SASTRACE system option 222
SASTRACELOC system option 225
sastracing 44
SAVE statement, CV2ODBC procedure 288
SAVEAS= statement, CV2VIEW procedure 280
SCHEMA= data set option 211
SCHEMA= option, SAS/ACCESS LIBNAME
statement 123
schemas 24
security
DBMS security 21
protecting connection information 23
SAS system security 22
triggers 22
SEGMENT_NAME= data set option 212
SELECT statement, ACCESS procedure (rela-
tional databases) 306
SETPASSWORD command 22
SHOW_SYNONYMS= option, SAS/ACCESS
LIBNAME statement 124
SORT procedure 31
sorting DBMS data 31
SORTPGM= option 31
SPOOL= option, SAS/ACCESS LIBNAME state-
ment 125
SQL procedure
CONNECT statement 229
CONNECTION TO component 235
creating DBMS tables 253
DBMS data with 246
DISCONNECT statement 233
DQUOTE= option 10, 13, 15
EXECUTE statement 234
interactions with SAS/ACCESS 227
querying a single table 246
querying multiple tables 249
updating DBMS data 251
SQL procedure, optimizing 33
passing DISTINCT and OPTION operations to
DBMS 37
passing functions to DBMS 34
passing joins to DBMS 34, 35
passing WHERE clauses to DBMS 38
SQL statement, DBLOAD procedure (relational
databases) 323
SQL_FUNCTIONS= option, SAS/ACCESS LIB-
NAME statement 126
SQLLDR control statements 141
SQLLDR executable file 164
SQL*Loader DIRECT option 153
SQLXMSG macro variable 220, 228
SQLXRC macro variable 220, 228
statistics calculation 259
STRINGDATES= option, SAS/ACCESS LIB-
NAME statement 126
SUBMIT statement, CV2ODBC procedure 288
SUBMIT statement, CV2VIEW procedure 281
SUBSET statement, ACCESS procedure (rela-
tional databases) 306
subsetting DBMS data 171
example 260
SYBASE interface, supported features 61
SYSDBMSG macro variable 219
SYSDBRC macro variable 219
system options 220
T
TABLE= statement, ACCESS procedure (rela-
tional databases) 307
TABLE= statement, DBLOAD procedure (rela-
tional databases) 324
tables, DBMS
creating with DBLOAD procedure 53
join performance, improving 38
naming based on data set names 12, 18
naming based on variable names 11
passing joins to DBMS 34
passing joins to DBMS, limitations on 35
preserving names 14
TABULATE procedure 258
Teradata interface, supported features 61
termination commands
DBCONTERM 86
DBLIBTERM 91
threaded reads 41
data ordering 47
options 43
performance considerations 45
scope of 42
technology for 41
trace information 44
Two Pass Processing 47
throughput 29
TO VIEW statement, CV2ODBC procedure 286
TO_LIBREF= statement, CV2VIEW proce-
dure 281
