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


Generating DDL

When you finish designing your objects, you generate the DDL that you use to promote those objects to a metadata catalog on a data server.

Before you begin

If you choose to run the DDL after it is generated, you must first do the following tasks:
  • Open a connection to a data server.
  • Create a set of metadata catalogs on the data server.
  • Set up connectivity from the data server to your data sources.

About this task

When the DDL is generated, you can choose to run it on a data server. You can also choose to open the DDL in an editor.

If you do not choose to run the DDL immediately after it is generated, you can run it later by opening the SQL Scripts folder, right-clicking the file with the DDL, and selecting Run SQL.

Procedure

To generate DDL for objects in your project:

  1. Open the Generate DDL wizard in either of these two ways:
    • Right-click the schema in which the objects are located and select Generate DDL. You can choose which objects in the schema you want to generate DDL for.
    • Right-click the object that you want to generate DDL for and select Generate DDL.
  2. Follow the pages of the wizard to make these selections:
    Which DDL statements to generate
    You can generate ALTER, COMMENT ON, CREATE, DROP, and GRANT statements. You can also choose whether to use fully qualified names and quoted identifiers.
    Which objects to generate DDL for
    The available objects depend on which object you right-clicked to open the Generate DDL wizard.
    Where to create the file, which statement terminator to use, whether to run the DDL on a data server, and whether to open the DDL file for editing
    The page on which you make these choices displays the DDL that will be generated.
  3. After reviewing your settings, click Finish.
Related concepts
Populating metadata catalogs
Creating views on existing tables
Related tasks
Exporting SQL to remote z/OS hosts


Feedback

Update icon Last updated: 2007-10-09