Adabas SQL Gateway Import Types

CONNX for Adabas has three types of imports:

  1. Adabas DYNAMIC DDL Import

  2. Adabas FDT Import

  3. Adabas SYSOBJH Import

Adabas Dynamic DDL Import offers the ability to use Create Table Description and Create Cluster Description syntax to enable users to import metadata from Adabas scripts.

Each of those imports are responsible for accessing the Adabas metadata and storing this in the CONNX Data Dictionary. Although Adabas has arrays (MUs), groups (PEs), and arrays within groups (MUPE), CONNX represents these as logical relational tables after the import is performed.