DBLOAD Procedure

TABLE Statement

specifies the name of the DBMS table to be created and loaded into a DBMS database

Restriction: do not use this statement when you are submitting dynamic DBMS-specific SQL statements to the DBMS without creating and loading a table.
Requirements: This statement is required when you create and load or append to a DBMS table. It must follow other database connection statements such as DATABASE= or USER=.
You must specify a table name that does not already exist. If a table by that name exists, an error message is written to the SAS log, and the table specified in this statement is not loaded.

Syntax

Required Argument

DBMS-specific-syntax

specifies a valid table name for the DBMS. (See the DBMS-specific reference in this document for the syntax for your DBMS.)

If your table name contains lowercase characters, special characters, or national characters, it must be enclosed in quotation marks.

Last updated: February 3, 2026