Viewing and Customizing the System Catalog

Once you’ve generated a system catalog and created a connect file, you can view and customize elements of the system catalog. The xfODBC Database Administrator (DBA) program enables you to view and customize users and groups; view tables, columns, indexes, and segments; and delete tables and columns. A conversion setup file enables you to change the access level of a table or add a table back into the system catalog. Additionally, if you use DBA to delete a table from the system catalog, you can use a conversion setup file to preserve that change when you regenerate the system catalog.

DBA basics

Opening a system catalog in DBA

Customizing users and groups

Customizing tables and table elements

Generating and editing a conversion setup file

Verifying the system catalog

DBA error messages