Hello everyone.

I was wondering if this is possible, it seems like it should be valid but I can't find the option anywhere in the DB2 Devlopement Center or Warehouse Center.

I have a flat file that contains DB2 DDL SQL.

I want to load this file into some program to create the tables in DB2.

the file looks like this:
CREATE DISTINCT TYPE functionType_32767 AS VARCHAR(32767);
CREATE TABLE "MSM".
"bridgeLink"
(
"ActivateCommandText" CharVar_32767
,
"AggregationParent" ObjectLinkList
,
"AggregationPriorityValue" Integer
....
....


I can load this DB2 .DDL into a model tool, such as Rational Software Architect, and it will show all the tables so its valid DB2 DDL but now I want to actually create the database from this script and I'm confused on how I can do this.


Thanks any help would be great!

Open Control Center.

Tools>>>Command Editor.

Thanks that worked great!