TABLE=

TABLE=

Names the DBMS table to be created and loaded.

Table statement: varies with each DBMS

Required statement

Syntax
Details

Syntax

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

Details

The TABLE= statement specifies the name of the DBMS table to be created and loaded into a DBMS database. The table name must be a valid table name for the DBMS. (See the naming conventions for your DBMS listed in your DBMS chapter.) If it contains lowercase characters, special characters, or national characters, it must be enclosed in quotes.

In addition, 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.

When you create and load or append to a DBMS table, the TABLE= statement is required. It must follow other database connection statements such as DATABASE= or USER=.

When you are submitting dynamic DBMS-specific SQL statements to the DBMS without creating and loading a table, this statement is not used.

Chapter Contents
Previous
Next
Top of Page