313
APPENDIX
2
The DBLOAD Procedure for
Relational Databases
Overview of the DBLOAD Procedure for Relational Databases
313
About DBLOAD Procedure Statements
314
Procedure Syntax
314
PROC DBLOAD Statement
315
Database Connection Statements
316
ACCDESC= Statement 316
COMMIT= Statement 317
DELETE Statement
317
ERRLIMIT Statement
318
LABEL Statement
318
LIMIT Statement
319
LIST Statement 319
LOAD Statement 320
NULLS Statement 320
QUIT Statement 321
RENAME Statement 321
RESET Statement 322
SQL Statement 323
TABLE= Statement 324
TYPE Statement 324
WHERE Statement 325
Example of Using the DBLOAD Procedure 325
Appending a Data Set to a DBMS Table 325
Overview of the DBLOAD Procedure for Relational Databases
Although it is still supported for the database systems and environments on which it
was available in Version 6, the DBLOAD procedure is no longer the recommended
method for sending data from SAS to a DBMS. It is recommended that you access your
DBMS data more directly, using the LIBNAME statement or the Pass-Through Facility.
Note: Not all SAS/ACCESS interfaces support this feature. See the chapter on
features by host to determine whether this feature is available in your environment.
This section provides general reference information for the DBLOAD procedure; see
the SAS/ACCESS documentation for your DBMS for DBMS-specific details.
The DBLOAD procedure, along with the ACCESS procedure and an interface view
engine, creates an interface between SAS and data in other vendors’ databases.
The DBLOAD procedure enables you to create and load a DBMS table, append rows
to an existing table, and submit non-query DBMS-specific SQL statements to the DBMS
for processing, all without leaving your SAS session. The procedure constructs
