Index 337
G
GRANT statement, including in SQL EXE-
CUTE 235
I
IN= data set option 192
IN= option, SAS/ACCESS LIBNAME state-
ment 101
Informix interface, supported features 58
initialization commands
DBCONINIT 85
DBLIBINIT 89
INSERT statement, including in SQL EXE-
CUTE 235
INSERTBUFF= data set option 194
INSERTBUFF= option, SAS/ACCESS LIB-
NAME statement 103
INSERT_SQL= data set option 193
INSERT_SQL= option, SAS/ACCESS LIB-
NAME statement 102
INTERFACE= option, SAS/ACCESS LIBNAME
statement 104
J
joins
options for improving performance 38
passing to DBMS 34
passing to DBMS, limitations on 35
K
KEEP= option 29
KEEP statement 30
KEYSET_SIZE= data set option 195
KEYSET_SIZE= option, SAS/ACCESS LIB-
NAME statement 105
L
LABEL statement, DBLOAD procedure (rela-
tional databases) 318
LIBNAME statement 3
advantages and disadvantages 4
how it works 50
protecting connection information 23
LIBNAME statement, passing operations 33
DISTINCT and OPTION operations 37
functions 34
joins 34, 35
WHERE clauses 38
LIBNAME statement, relational databases 65
connection options 65
embedded in PROC SQL views 66
engine name 65
example 67
LIBNAME options 65, 68
overview 63
librefs
assigning interactively 64
assigning to remote DBMS 68
assigning with SAS/ACCESS LIBNAME state-
ment 67
clearing 66
LIMIT statement, DBLOAD procedure (relational
databases) 319
limiting retrieval capabilities 29
LIST statement, ACCESS procedure (relational
databases) 302
LIST statement, DBLOAD procedure (relational
databases) 319
LOAD statement, DBLOAD procedure (relational
databases) 320
LOCATION= data set option 196
LOCATION= option, SAS/ACCESS LIBNAME
statement 105
locking data 26
passing joins to DBMS 36
LOCKTABLE= data set option 196
LOCKTABLE= option, SAS/ACCESS LIB-
NAME statement 106
LOCKTIME= option, SAS/ACCESS LIBNAME
statement 107
LOCKWAIT= option, SAS/ACCESS LIBNAME
statement 107
M
macro facility 219
macro variables 219
MAX_CONNECTS= option, SAS/ACCESS LIB-
NAME statement 108
MDX command 76, 77, 168
MEANS procedure 254
Microsoft SQL Server interface, supported fea-
tures 58
missing values
null values vs. 27
NULLCHAR 197
NULLCHARVAL 198
MOD function 46
MODIFY statement, DATASETS procedure 23
MULTI_DATASRC_OPT Join feature 108
MULTI_DATASRC_OPT= option 38
MULTI_DATASRC_OPT= option, SAS/ACCESS
LIBNAME statement 108
N
name literals 8, 17
naming conventions 7
default behaviors 9
examples 12
name literals 8, 17
null values
result set inconsistencies 27
NULL values
DBLOAD procedure 321
NULLCHAR= data set option 197
NULLCHAR= option 28
NULLCHARVAL= data set option 198
NULLS statement, DBLOAD procedure (rela-
tional databases) 321
O
ODBC cursor library 135
ODBC interface, supported features 59
OLE DB interface, supported features 59
optimizing PROC SQL 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
optimizing WHERE clauses 37
Oracle hints 200
Oracle interface, supported features 60
Oracle Rdb interface, supported features 60
ORACLE_73_OR_ABOVE= data set option 199
ORACLE_73_OR_ABOVE= option, SAS/AC-
CESS LIBNAME statement
See OR_UPD_NOWHERE= option, SAS/AC-
CESS LIBNAME statement
ORDER BY statement
data ordering with threaded reads 47
performance considerations 31
ordering data
sorting DBMS data 31
threaded reads and 47
ordering DBMS data 171
ORHINTS= data set option 200
OR_UPD_NOWHERE= data set option 199
OR_UPD_NOWHERE= option, SAS/ACCESS
LIBNAME statement 110
OUT= option, PROC ACCESS statement (rela-
tional databases) 298
P
PACKETSIZE= option, SAS/ACCESS LIB-
NAME statement 111
Pass-Through Facility 33, 228
advantages and disadvantages 4
how it works 51
overview 227
syntax 228
passing operations to DBMS 33
DISTINCT and OPTION operations 37
functions 34
joins 34, 35
WHERE clauses 38
password protection 22
PASSWORD statement, CV2ODBC proce-
dure 288
performance
optimizing PROC SQL 33
repeatedly accessing data 30
retrieval limits 29
sorting data 31
threaded reads and 45
throughput, increasing 29
WHERE clauses 37
PREFETCH= option, SAS/ACCESS LIBNAME
statement 111
PRESERVE_COL_NAMES= data set op-
tion 201
PRESERVE_COL_NAMES= option, LIBNAME
statement 10, 13
