WebSphere logo Classic Federation Server for z/OS, Version 9.1
WebSphere logo Classic Replication Server for z/OS, Version 9.1
WebSphere logo Classic Data Event Publisher for z/OS, Version 9.1
WebSphere logo Data Integration Classic Connector for z/OS, Version 9.1


Generate DDL wizard

Use the Generate DDL wizard to generate DDL for any of the objects within a schema in a data design project. You can run the DDL on a data server to populate a metadata catalog with tables, indexes, views, and stored procedures. You can also choose just to save the DDL to a file.

Options page

Use this page to specify the types of SQL DDL statements that you want to generate. Also, specify whether to use fully qualified names and quoted identifiers.

Fully qualified names
Select to qualify the names of all of the objects with the schema for the object.
Quoted identifiers
Select to generate double quoted identifiers for all statements.
DROP statements
Select to generate DROP statements for all of the objects for which you choose to generate DDL statements.
CREATE statements
Select to generate CREATE statements for all of the objects for which you choose to generate DDL statements.
COMMENT ON statments
Select to generate COMMENT ON statements for all of the objects for which you choose to generate DDL statements.
GRANT statements
Select to generate GRANT statements for all of the objects for which you choose to generate DDL statements.

Objects page

Use this page to select the types of objects for which you want to generate SQL DDL statements. The selection on this page depends on which object you right-clicked to open the wizard.

Tables
Select to generate DDL for tables, if the object that you right-clicked to open the wizard is a schema with one or more tables in it or a table.
Indexes
Select to generate DDL for indexes, if the object that you right-clicked to open the wizard is a table with one or more indexes on it.
Primary key constraint
Select to generate DDL for primary key constraints, if the object that you right-clicked to open the wizard is a table with a primary key constraint defined on it.
Views
Select to generate DDL for views, if the object that you right-clicked to open the wizard is a schema with one or more views in it or a view.
Stored procedures
Select to generate DDL for stored procedures, if the object that you right-clicked to open the wizard is a schema with one or more stored procedures in it or a stored procedure.

Save and Run DDL page

Use this page to review the generated DDL. You can run the DDL on a data server to populate its metadata catalog with the objects that are defined by the DDL. You can also choose to edit the DDL. The DDL is saved in a .sql file in the SQL Scripts folder in the project.

Folder
Displays the folder for the project in which the objects that are defined by the DDL are located. By default, the .sql file that contains the DDL is saved in the SQL Scripts folder in this project. You can select a different project in which to save the DDL.
File name
Type a name for the .sql file that will contain the DDL.
Preview DDL
Displays the DDL so that you can review it.
Statement terminator
The only supported terminator is the semicolon.
Run DDL on server
Select to run the DDL on a data server when you click Finish. A connection to the data server must exit.
Open DDL file for editing
Select to open the DDL in a text editor within Classic Data Architect when you click Finish.

Summary page

Use this page to review the settings that you chose for the DDL. Click Finish to run the DDL, edit the DDL, or both.



Feedback

Update icon Last updated: 2007-07-11