Use SQL DDL to Populate Directory

Edit online

Some sites maintain primary and foreign key definitions in third party data dictionary products. Also, some application generators produce primary and foreign key definitions as part of the code generation process. Optim™ provides the Import facility to populate the Optim™ Directory with primary and foreign key definitions produced by such tools.

The key information is extracted from SQL DDL statements, which may be generated from a dictionary other than DB2® or may be manually created. The Import facility also generates a comprehensive summary of the Import Process upon completion.

The following steps are used to populate the Optim™ Directory with primary and foreign key definitions produced by an external data modeling tool.

  1. Generate the SQL DDL statements in SPUFI format in a partitioned or sequential dataset.
    Note: The Import facility processes only the PRIMARY KEY and FOREIGN KEY clauses of the CREATE TABLE or ALTER TABLE statements. It does not process any DROP clauses.
  2. Invoke the Import facility from the main menu by selecting Option 6 DEFINITIONS. Then select Option I IMPORT on the Choose a Definition Option menu.
  3. Supply the required information on the IMPORT Process menu, and execute the Import Process by pressing ENTER.
  4. An IMPORT Summary panel is displayed upon completion of the Import Process. The contents of the report file can be displayed using the REPORT command.