If the IMS system you are connected to supports DDL, you can create new DBDs and PSBs in
IMS by generating DDL from an existing DBD or PSB, editing the generated DDL, and submitting the new
statements to IMS™ on your host system.
Before you begin
IMS Explorer for Development must be connected to an IMS
database. See Connecting to an IMS database
The IMS system you are connecting to must support DDL. DDL is supported by IMS 14 and later
systems that are configured to manage ACBs in the IMS catalog. For more information about enabling
IMS support for DDL and the IMS management of ACBs, see IMS management of ACBs.
Procedure
To generate DDL:
- In the Data Source Explorer view, right-click a connection node, schema
(DBPCB), or table (segment) and click Generate DDL.
Note: If you select a connection node, DDL is generated for the child catalog (PSB). If
you select a table, DDL is generated for the parent schema.
The Generate DDL wizard opens.
- In the Options page, select the model elements that you want to include
in the DDL script.
- CREATE statements
- Generates create structures.
- DROP statements
- Generates drop statements for each create statement.
- Comments
- Generates comments for DBD, PSB, PCB, maps, fields, and cases.
- In the Objects page, select the model objects that you want to include in
the DDL script.
- Program view
- Generates program view (PSB) DDL for the selected schemas.
Important: This option
will create a default PROGRAMVIEW name. In the Save and Run DDL page, select
Open DDL file for editing and specify a valid PROGRAMVIEW name before you run
the DDL on the server.
- Tables
- Generates DDL for the database definitions (DBD) referenced by the selected schemas.
- In the Save and Run DDL page, select Open DDL file for
editing and click . The DDL opens in an SQL editor, where you can modify and run the DDL script.
Results
When you run the DDL script, statements are submitted to IMS and results are shown in the
SQL
Results view.
What to do next
If you are creating a new database, additional steps might be required in IMS before you
can activate the database. For more information, see
Creating databases best practices.