Examples in this section show how to use the
SQL pass-through
facility to access and update DBMS
data. You can use the SQL pass-through facility to read and write
data between SAS and a DBMS. However, it is recommended that you use
the
LIBNAME
statement to access your DBMS data
more easily and directly.
To run these examples,
follow these steps.
-
Modify and submit the
ACCAUTO.SAS file, which creates the appropriate LIBNAME statements
for each database.
-
Submit the ACCDATA.sas
program to create the DBMS tables and SAS data sets that the sample
code uses.
-
Submit the ACCRUN.sas
program to run the samples.
These programs are available
in the SAS Sample Library. If you need assistance locating the sample
library, contact your SAS support consultant. See
Descriptions of the Sample Data for information about the tables that are used in the sample
code.
Note: Before you rerun an example
that
updates DBMS data, resubmit
the ACCDATA.sas program to re-create the DBMS tables.