Table properties
Table properties are shown in the Properties view within Classic Data Architect. You can use the Properties view to modify the properties of a table.
If the table already exists in a metadata catalog on a data server and you want any changes that you make to the table to be reflected in the metadata catalog, you must follow these steps:
- Drop the table from the metadata catalog. You can generate the DDL to drop the table by right-clicking the table and selecting Generate DDL. In the Generate DDL wizard, select the DROP statements check box.
- Run the generated DDL on the data server.
- Make your changes to the table.
- Generate the DDL to create the table. You can generate this DDL by opening the Generate DDL wizard and selecting the CREATE statements check box.
- Run the DDL on the data server.
The Properties view for a table contains the following information:
- General page
- Columns page
- Source information page
- Source columns page
- Path information page
- Source elements page
- Source fields page
- Segments page
- PCB selection page
- Privileges page
- Documentation page
- General page
-
Property Description Name Type the name of the table. Schema Displays the schema in the two-part name for the table. Source DBMS Displays the type of DBMS in which the source data is located. Change capture - Changes
- Select this value for change data capture.
- Columns page
- Lists the columns of the table.
- Source information page
- The Source information page contains source information for:
Table 1. Source information for IMS Property Description DBD name Displays the name of the IMS DBD (database definition) that the table references. DBD type Displays the name of the IMS DBD (database definition) that the table references. Leaf segment Displays the name of the leaf segment. Index root Not applicable for change data capture. IMS subsystem Not applicable for change data capture. PSB name Optional: Type the name of the PSB that is scheduled to access the IMS database that is identified by the DBD. This name is used if you are using a DRA or ODBA interface to access IMS data. The standard PSB corresponds to a PSB definition that is defined to the IMS online system that is being accessed. The PSB also corresponds to a PDS member under the same name in the active ACB library of the source IMS subsystem. The standard PSB name follows z/OS® load module naming conventions. Join PSB name Not applicable for change data capture. - Source columns page
- Lists the columns in the table.
- Path information page
- Not applicable for IMS change data capture.
- Source elements page
- Not applicable for IMS change data capture.
- Source fields page
- Lists the fields that are mapped to columns in the table.
- Segments page
- Lists the segments that contain fields that are mapped to columns in the table.
- PCB selection page
- Displays the method that Classic federation will use to select PCBs for accessing the table.
- Privileges page
- Lists that privileges that are granted on the table. Click the
add button (
)
to add privileges. Click the delete button (
) to remove
privileges. - Documentation page
- Lets you add comments to the table.