SAS/ACCESS Software for Relational Databases: Reference

Introduction

In most of the interfaces that are provided in Version 6 of SAS/ACCESS software, the DBLOAD procedure enabled you to create and load (that is, transfer data to) a database management system table from a SAS data set. It also enabled you to submit non-query, DBMS-specific SQL statements to the DBMS without leaving your SAS session. The DBLOAD procedure continues to be supported in Version 7 and later. However, there are some changes in the support, as described in Version 8 Compatibility for Version 6 Procedures.

This chapter provides general reference information for the DBLOAD procedure, including its options and statements. See your DBMS chapter to determine whether the DBLOAD procedure is supported for your DBMS, and for DBMS-specific information that pertains to the DBLOAD procedure.

Refer to SAS Language Reference: Dictionary and to the SAS Companion for your operating environment for information on SAS data sets, SAS data libraries, and their naming conventions. If you are using this documentation from a book, remember that help is available from the Help menu.

Note: It is recommended that you use the SQL Procedure Pass-Through Facility with its new options to take full advantage of Version 7 and later enhancements. For more information, see SQL Procedure Pass-Through Facility Statements. [cautionend]

Chapter Contents
Previous
Next
Top of Page