Setting Name Options for Individual Tables

---

SAS ETL Studio cannot access tables or columns with case-sensitive names or with special characters in the names unless the appropriate options have been specified in the metadata for the table.

Prerequisites

For tables in DBMS format, it is assumed that the appropriate name options have already been set for the database library that is used to access the table, as described in "Supporting Case and Special Characters in Table and Column Names" on page 49. Name options do not need to be set on the library that is used to access a table in SAS format.

Task Summary

The following steps describe one way to enable name options for a table whose metadata has been saved to a metadata repository. It is assumed that the metadata repository is under change management.

1. Start SAS ETL Studio, open the appropriate metadata profile, and check out the table(s) whose metadata must be updated.

2. In the Project tree, select the metadata for the table, then select File Properties from the menu bar. The properties window for the table is displayed.

3. In the properties window, click the Physical Storage tab.

4. On the Physical Storage tab, select Enable case-sensitive DBMS object names to support case-sensitive table and column names. Select Enable special characters within DBMS object names to support special characters in table and column names. For details about these options as they relate to SAS tables, see "Case and Special Characters in SAS Names" on page 184.

5. Click to save your changes.

6. Check in the changed metadata.

---