DBLOAD Procedure

See: DB2 under UNIX and PC Hosts, DB2 under z/OS, Microsoft SQL Server, ODBC, Oracle, SAP ASE
Syntax
Table of Procedure Tasks

Syntax

PROC DBLOAD <options>;
database connection statements;
TABLE=<'>table-name <'>;
ACCDESC=<libref.>access-descriptor;
COMMIT=commit-frequency;
DELETE variable-identifier-1
<…variable-identifier-n>;
ERRLIMIT=error-limit;
LABEL;
LIMIT=load-limit;
LIST <ALL | FIELD | <’>variable-identifier<’>;
NULLS variable-identifier-1 = Y | N
<…variable-identifier-n = Y | N>;
QUIT;
RENAME variable-identifier-1 = <'>column-name-1<'>
<…variable-identifier-n = <'>column-name-n<'>>;
RESET ALL | variable-identifier-1<…variable-identifier-n>;
SQL DBMS-specific SQL-statement;
TYPE variable-identifier-1 = 'column-type-1'
<…variable-identifier-n = 'column-type-n'>;
WHERE SAS-where-expression;
LOAD;
RUN;

Table of Procedure Tasks

Statement Task
PROC DBLOAD Send data from SAS to a DBMS
Database Connection Provide DBMS connection information
ACCDESC Create an access descriptor based on the new DBMS table
COMMIT Issue a commit or save rows after a specified number of inserts
DELETE Specify variables that should not be loaded into the new table
ERRLIMIT Stop the loading of data after a specified number of errors
LABEL Cause DBMS column names to default to SAS labels
LIMIT Limit the number of observations that are loaded
LIST List information about the variables to be loaded
LOAD Create and load the new DBMS table
NULLS Specify whether DBMS columns accept NULL values
QUIT Terminate the procedure
RENAME Rename DBMS columns
RESET Reset column names and data types to their default values
SQL Submit a DBMS-specific SQL statement to the DBMS
TABLE Name the DBMS table to be created and loaded
TYPE Change default DBMS data types in the new table
WHERE Load a subset of data into the new table
Last updated: February 3, 2026