Databases Reference
In-Depth Information
2
Enter a name for the library and click
Next
.
3
Enter a SAS LIBNAME for the library, then click
Advanced Options
. The
Advanced Options window displays.
4
In the Advanced Options window, click the
Output
tab.
5
To preserve DBMS column names, select
Yes
in the
Preserve column names as
in the DBMS
field.
6
Click the
Input/Output
tab.
7
To preserve DBMS table names, select
Yes
in the
Preserve DBMS table names
field.
8
Click
OK
and enter the metadata as prompted by the wizard.
Enabling DBMS Name Options for an Existing Database Library
The following steps describe one way to update the existing metadata for a database
library in order to specify name options. 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 out the library,
update the metadata as described in the following steps, then check in the metadata for
the library as a last step.
1
Start SAS Data Integration Studio as described in “Starting SAS Data Integration
Studio” on page 93.
2
Open the metadata profile that specifies the repository where metadata for the
library is stored. The steps for opening a metadata profile are described in
“Opening a Metadata Profile” on page 95.
3
In SAS Data Integration Studio, click the
Inventory
tab to display the Inventory
tree.
4
In the Inventory tree, expand the folders until the Libraries folder is displayed.
5
Select the
Libraries
folder, then select the library whose metadata must be
updated.
6
Select
File
Properties
from the menu bar. The properties window for the
library displays.
7
In the properties window, click the
Options
tab.
8
On the
Options
tab, click
Advanced Options
. The Advanced Options window
displays.
9
In the Advanced Options window, click the
Output
tab.
10
To preserve DBMS column names, select
Yes
in the
Preserve column names as
in the DBMS
field.
11
Click the
Input/Output
tab.
12
To preserve DBMS table names, select
Yes
in the
Preserve DBMS table names
field.
13
Click
OK
twice to save your changes.
Setting Default Name Options for Tables and Columns
You can set default name options for all table metadata that is entered with a source
designer wizard or a target designer wizard in SAS Data Integration Studio. These
defaults apply to tables in SAS format or in DBMS format.
Note:
For details about these defaults as they relate to SAS tables, see “Case and
Special Characters in SAS Table and Column Names” on page 73.
Search WWH ::
Custom Search