[dtp-dev] Expanded Generic DDL Generator Support

[rcernich@xxxxxxxxxx]

Hey all,

I've expanded the generic DDL generator to support the following object
types:
   schema
   stored procedure
   user defined function
   user defined type
      structured
      distinct
      domain
   assertion

These changes are designed to generate ANSI/ISO DDL statements for the
above objects, utilizing corresponding information in the SQL model.  If
your DB supports ANSI/ISO DDL statements, you just need to make sure the
SQL model is populated correctly (e.g. the generic catalog loader is not
capable of populating a routine's source, therefore, SP and UDF DDL will be
lacking that information).

I've attached a patch with the changes to the BZ entry:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=175007

Please give it a look to ensure it is compatible with any specialized DDL
generators you may have written.  Also, give a quick check of the syntax to
help ensure it jibes with the specification.  (I have done some limited
testing.)

Best regards,
Rob Cernich
DTP Connectivity Project Lead