Main Tasks for Administrators - SAS Data Integration Studio 3.3 User's Guide - page 73

Supporting Case and Special Characters in Table and Column Names
Overview of Case and Special Characters
SAS Data Integration Studio cannot access tables or columns with case-sensitive
names or with special characters in the names unless the appropriate options have been
specified. For the example data warehouse, assume that all tables are in SAS format,
and that all names for tables and columns follow the standard rules for SAS names.
Case and Special Characters in SAS Table and Column Names
By default, the names for SAS tables and columns must follow the standard rules for
SAS names. However, SAS Data Integration Studio will support case-sensitive names
for tables and columns, as well as special characters in column names, if the
appropriate options are specified in the metadata for the SAS table.
SAS Data Integration Studio users can set name options in the metadata for
individual tables. For a description of this task, see “Setting Name Options for
Individual Tables” on page 109.
As an alternative to setting name options in the metadata for individual tables, you
can set default name options for all table metadata that is entered with a source
designer or a target designer in SAS Data Integration Studio. For details, see “Setting
Default Name Options for Tables and Columns” on page 74.
Case and Special Characters in DBMS Table and Column Names
SAS Data Integration Studio cannot access a DBMS table with case-sensitive names
or with special characters in names unless the appropriate name options are specified
in the metadata for the database library that is used to access the table, and in the
metadata for the table itself.
One approach would be for administrators to specify name options in the metadata
for the database library, as described in this section. Administrators could then let SAS
Data Integration Studio users know which DBMS name options to specify in the
metadata for tables in that library. SAS Data Integration Studio users can set name
options in the metadata for DBMS tables. For a description of this task, see “Setting
Name Options for Individual Tables” on page 109.
As an alternative to setting name options in the metadata for individual tables, you
can set default name options for all table metadata that is entered with a source
designer or a target designer in SAS Data Integration Studio. For details, see “Setting
Default Name Options for Tables and Columns” on page 74.
Enabling DBMS Name Options for a New Database Library
The following steps describe how to enable name options when you enter the
metadata for a new database library. These steps are appropriate for an administrator
who does not have to use the change-management facility. The steps for a user would
be similar, except that the user would have to check in the metadata for the new library
as a last step.
1 Follow the steps in “Enter Metadata for a Library” on page 59. In the New Library
wizard, select the appropriate kind of database library and click Next .