Book a Demo

Author Topic: Import DDL and DB2 / DB2 DDL Generation  (Read 2616 times)

nmaynard

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
  • I love YaBB 1 Gold!
    • View Profile
Import DDL and DB2 / DB2 DDL Generation
« on: April 05, 2003, 08:14:42 pm »
When importing DDL from DB2 (v7.2 fp7) I run into a couple of issues:
 1) Not all the datatype information comes through. I.E. decimal instead of DECIMAL(15,2), character instead of CHAR(50), etc
 2) There is no option to import views

When exporting from the model I notice that even though some of the DB2 index specific options (pctfree for example) are noted in an index's "TaggedValues" in a way, they are not present in the generated DDL.

Also, how does one use the trigger or stored procedure generation options? (what needs to be done to make the generation process output a trigger for example, one that is not related to refferential integrity)