The DBLOAD Procedure for Relational Databases

Syntax: DBLOAD Procedure

Here is the general syntax for the DBLOAD procedure. See the DBMS-specific reference in this document for details about your DBMS.

TABLE= <'>table-name<'>;

ACCDESC= <libref.>access-descriptor;

COMMIT= commit-frequency;

DELETE variable-identifier-1
<...variable-identifier-n>;

ERRLIMIT= error-limit;

LIMIT= load-limit;

LIST <ALL | COLUMN | variable-identifier>;

NULLS variable-identifier-1 = Y | N
<...variable-identifier-n = Y | N>;

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;

RUN;