Importing Existing Table Definitions

The following lists table definitions that 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. The data in the tables can then be accessed and manipulated. Depending on the front-end application chosen 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.