314 About DBLOAD Procedure Statements Appendix 2
DBMS-specific SQL statements to create and load, or append, to a DBMS table by using
one of the following:
a SAS data file
a PROC SQL view or DATA step view
a view descriptor that was created with the SAS/ACCESS interface to your DBMS
or with another SAS/ACCESS interface product
another DBMS table referenced by a SAS libref that was created with the
SAS/ACCESS LIBNAME statement.
The DBLOAD procedure associates each SAS variable with a DBMS column and
assigns a default name and data type to each column. It also specifies whether each
column accepts null values. You can use the default information or change it as
necessary. When you are finished customizing the columns, the procedure creates the
DBMS table and loads or appends the input data.
About DBLOAD Procedure Statements
There are several types of DBLOAD statements:
Database connection statements are used to connect to your DBMS. See the
SAS/ACCESS documentation for your DBMS for details.
Creating and loading statements are LOAD and RUN.
Table and editing statements are used to specify how a table is populated.
The following table summarizes the PROC DBLOAD options and statements
required to accomplish common tasks.
Table A2.1 Statement Sequence for Accomplishing Common Tasks with the DBLOAD Procedure
To do this... Use these options and statements
Create and load a DBMS table
PROC DBLOAD
statement-options;
database-connection-options;
TABLE= <’>table-name<’>;
LOAD;
RUN;
Submit a dynamic, non-query DBMS-SQL
statement to DBMS (without creating a
table)
PROC DBLOAD
statement-options;
database-connection-options;
SQL DBMS-specific-SQL-statements;
RUN;
Note: LOAD must appear before RUN to create and load a table or append data to a
table.
Procedure Syntax
The general syntax for the DBLOAD procedure is presented here; see the
SAS/ACCESS documentation for your DBMS for DBMS-specific details.
