CONNX Data Integration Suite 14.8.0 | Operations Guide | Working with the Online CONNX Suite | Managing CDDs with the Online CONNX Data Dictionary Manager | Working with Tables in a CDD | Editing Column Properties in a Table
 
Editing Column Properties in a Table
You can edit the following column properties in a table with the online CDD Manager:
*Set the Column name
*Change the native data type of a column.
*Set the offset, length, precision, and scale of a column.
*The size of a column array.
*Set the code page for a column. See Code Pages for more information.
*Add a custom comment to a column.
*To edit column properties:
1. Go to the main online CONNX Data Dictionary Manager page.
You can select CONNX Data Dictionary from the home page or the tile menu on the top right.
2. Open a CDD for editing.
3. Expand the database that contains the table you want to edit.
4. Select the table you want to edit.
5. Select the Table Columns tab.
6. Click the Edit button.
7. Apply the changes you want.
You can click the funnel icon to filter the list of columns by name, native data type, or custom comment.
8. Click the Save button.