When Importing Existing Table Definitions
The following table definitions can be imported into the CONNX Data Dictionary:
COBOL FD (File Definition)
Codasyl DBMS database
DataFlex
POWERFlex
DIBOL
Formatted DDL (Data Definition Language)
Powerhouse PDL (Powerhouse Definition Language)
Rdb database
SCT COBOL FD
Specification text file (RMS)
VAX, ALPHA, or Itanium (RMS only) CDD
OLE DB- and ODBC-compliant data sources
DB2 data sources
Oracle data sources
VSAM data sources
IMS data sources
Sybase data sources
Informix data sources
Adabas data sources
Once you import the metadata and define the table properties, you must save the CDD and create an ODBC data source name. This enables access t9 and manipulation of the data in the imported tables. Depending on the front-end application and the types of databases that exist in your system, you can use the imported metadata to create new database objects, or to update or incorporate data quickly and efficiently.
Once table definitions are imported, column, field, and row names can be changed independently of their source data. Note that any changes made in the table metadata imported into the CDD do not affect the source data in any way.