|
Data Sources
Creating a Column Data Source
A column data source is a column in an existing SAS table that is accessible to
users through client applications. You must create a data source definition for the column's table
before you create the column definition.
The SAS Integration Technologies Administrator provides a graphical user interface that allows you
to create an LDAP object definition for a column. Client applications can then use the LDAP definition to access the column.
To add a new column data source using IT Administrator:
Open IT Administrator.
Select the SAS Data Sources button in the
Manager Bar.
Select the Tables folder in the tree view.
Select the definition for the table that contains the
column you want to use as a data source.
Select File New Column. The
New Column window
appears and requests that you enter property information for the new column.
Enter a name and description for the column. The name identifies
the column in the tree view, and the description is visible when the
object properties are viewed.
In the Column fields, you
must enter the following information:
- Name
- Enter the name of the column as it is identified in the SAS table. The
column must already exist and must use the same name as the one that is specified in
this field.
- Type
- Enter the column type - either N (numeric) or C (character).
- Maximum Length
- Enter the maximum specified length for values in the column.
Enter values for any of the other Column fields as needed.
You can find information about the values that are
required in each field by selecting the Help button in
the New Column window.
When you are finished entering information in the fields, select OK. The new column definition appears
in the tree view.
|