A variable-format data set is viewed by SQL as several tables. A separate table appears for each variable-format part. Each of these tables contains the columns of the fixed part and the columns of the appropriate variable-format part. In addition, another table is mapped: the table that represents the records having no variable-format part specified (record type equals 0).
| Note: | This task applies only to an Enterprise Database Server database that is mapped to SQL. |
Perform the following steps to modify the schema for a variable-format item:
-
From the tree view, expand the server containing the database you want to modify.
-
Expand the database you want to modify, and expand the Tables node representing each data set in the database.
-
Expand the Variable Format Items node to display each variable-format part and its properties.
-
Select the node representing the desired variable-format item. The properties or semantics associated with the variable-format item appears in the properties view.
The following schema properties associated with the variable-format item appear in the properties view.
-
Double-click the value for the Alias Table Name property, and type the name used for the SQL table represented by the variable-format part. The alias name can be up to 30 characters long.
-
Select the Ignore check box to make the variable-format item inaccessible to SQL queries. Otherwise, leave the check box cleared.
