336 Index
CREATE statement, including in SQL EXE-
CUTE 235
creating DBMS objects
naming behavior 11
creating DBMS tables 53
CURSOR_TYPE= data set option 169
CURSOR_TYPE= option, SAS/ACCESS LIB-
NAME statement 83
CV2ODBC 285
CV2ODBC procedure 285
examples 289
CV2VIEW procedure 277
examples 282
D
DATA= option, PROC DBLOAD statement (rela-
tional databases) 315
data set options, relational databases 137
data sets
extracting DBMS data to 24, 30
data types
overriding 185
database administrator (DBA) 21
DATASETS procedure 255
password assignment 23
DB2 OS/390 interface, supported features 58
DB2 UNIX/PC interface, supported features 57
DBA (database administrator) 21
DBCOMMIT= data set option 170
DBCOMMIT= option, SAS/ACCESS LIBNAME
statement 84
DBCONDITION= data set option 171
DBCONINIT= option, CONNECT state-
ment 230
DBCONINIT= option, LIBNAME statement 26
DBCONINIT= option, SAS/ACCESS LIBNAME
statement 85
DBCONTERM= option, CONNECT state-
ment 230
DBCONTERM= option, LIBNAME state-
ment 26
DBCONTERM= option, SAS/ACCESS LIB-
NAME statement 86
DBCREATE_TABLE_OPTS= data set op-
tion 172
DBCREATE_TABLE_OPTS= option, SAS/AC-
CESS LIBNAME statement 87
DBFORCE= data set option 173
DBGEB_NAME= option, CONNECT state-
ment 231
DBGEN_NAME= data set option 174
DBGEN_NAME= option, SAS/ACCESS LIB-
NAME statement 88
DBINDEX= data set option 175
DBINDEX= option 39, 40
DBINDEX= option, SAS/ACCESS LIBNAME
statement 89
DBKEY= data set option 177
DBKEY= option 39
DBLABEL= data set option 178
DBLIBINIT= option, SAS/ACCESS LIBNAME
statement 89
DBLIBTERM= option, SAS/ACCESS LIBNAME
statement 91
DBLINK= data set option 179
DBLINK= option, SAS/ACCESS LIBNAME
statement 92
DBLOAD procedure 4
how it works 53
naming behaviors 9
DBLOAD procedure, relational databases 314
options 315
overview 313
statements 314
DBMASTER= data set option 180
DBMAX_TEXT= data set option 181
DBMAX_TEXT= option, CONNECT state-
ment 231
DBMAX_TEXT= option, SAS/ACCESS LIB-
NAME statement 92
DBMS connections
controlling 25
customizing connect and disconnect exits 26
protecting connection information 23
DBMS data
combining with SAS data 243, 261
creating SAS data sets from 242
joining DBMS and SAS data 261
ordering 171
PRINT procedure with 242
SQL procedure with 246
subsetting 171
updating 251
DBMS data views 5, 6
deļ¬ning 24
DBMS= option, CV2VIEW procedure 278
DBMS= option, PROC ACCESS statement (rela-
tional databases) 298
DBMS= option, PROC CV2ODBC state-
ment 286
DBMS= option, PROC DBLOAD statement (rela-
tional databases) 315
DBMS table names, preserving 113
DBMS tables
appending data to 259
creating with SQL procedure 253
means calculation 254
querying a single table 246
querying multiple tables 249
ranking data 257
reading data from multiple tables 244
viewing contents of 256
viewing list of 255
DBNULL= data set option 182
DBNULLKEYS= data set option 183
DBNULLKEYS= option, SAS/ACCESS LIB-
NAME statement 93
DBPROMPT= data set option 184
DBPROMPT= option, CONNECT state-
ment 231
DBPROMPT= option, LIBNAME statement 23
DBPROMPT= option, SAS/ACCESS LIBNAME
statement 94
DBSASTYPE= data set option 185
DBSLICE= data set option 186
DBSLICE= option 43
DBSLICE_CONTROL system option 95, 188
DBSLICEPARM= option 43
DBSRVTP system option 221
DBTYPE= data set option 190
debugging
TRACE= option 129
DEFER= option, CONNECT statement 231
DEFER= option, LIBNAME statement 26
DEFER= option, SAS/ACCESS LIBNAME state-
ment 97
DEGREE= option, SAS/ACCESS LIBNAME
statement 98
DELETE statement, DBLOAD procedure (rela-
tional databases) 317
DELETE statement, including in SQL EXE-
CUTE 235
DELETE_MULT_ROWS= option, SAS/ACCESS
LIBNAME statement 99
descriptors 309
Direct SQL Join feature 99
DIRECT_SQL= option 36
DIRECT_SQL= option, SAS/ACCESS LIB-
NAME statement 99
disconnect exits, customizing 26
DISCONNECT statement, SQL procedure 233
DISTINCT operations, passing to DBMS 37
DQUOTE= option, SQL procedure 10, 13, 15
DROP= option 30
DROP statement 30
including in SQL EXECUTE 235
DROP statement, ACCESS procedure (relational
databases) 301
DSN statement, CV2ODBC procedure 287
E
ENABLE_BULK= option, SAS/ACCESS LIB-
NAME statement 101
engine name, SAS/ACCESS LIBNAME state-
ment 65
engines, random access 122
environment variables
protecting connection information with 23
ERRLIMIT= data set option 191
ERRLIMIT= statement, DBLOAD procedure (re-
lational databases) 318
error return codes, Pass-Through Facility 228
EXECUTE statement, SQL procedure 234
extracting DBMS data 24
performance considerations 30
F
FILE option, REPLACE statement
(CV2VIEW) 279
FORMAT statement, ACCESS procedure (rela-
tional databases) 301
FREQ procedure 259
FROM VIEW statement, CV2ODBC proce-
dure 286
FROM_LIBREF= statement, CV2VIEW proce-
dure 279
FROM_VIEW= statement, CV2VIEW proce-
dure 279
functions, passing to DBMS 34
