Creating DDMs

#### Search Results

Search

# Creating DDMs

This section describes how to create a DDM by either copying DDMs or creating DDMs directly from the field definitions in a database. In addition, it provides information on how to generate multiple DDMs from an SQL database.

This section covers the following topics:

- Copying DDMs

- Creating DDMs from Adabas

- Creating DDMs from SQL

- Creating Multiple DDMs from SQL

- Creating DDMs from Tamino

- Creating DDMs for VSAM

## Copying DDMs

This section describes how to create a new DDM from an existing one.

To copy a DDM

1. From a DDMs node or subnode, choose a DDM and open the object.

   The DDM editor is invoked with the DDM source displayed in the editing area.

2. From the Object menu, choose Save As.

   The Save As dialog box appears.

3. In the Name text box, enter a new DDM name and, in the Libraries combo box, select a library if required.

   The new DDM is saved as a source object and is added to the corresponding DDMs node or subnode.

4. From the Object menu, choose Stow to save the new DDM as a cataloged object. See also Saving and Cataloging a DDM.

You can also copy single or multiple objects by using the copy-and-paste or drag-and-drop feature of Natural Studio as described in Copying Objects in Natural Studio documentation.

If you want to copy DDMs between different libraries, database files, and/or hardware platforms, see also Maintaining DDMs in Different Environments.

## Creating DDMs from Adabas

To create a DDM from an Adabas database

1. Select the DDMs node or subnode or log on to the library where you want to create the DDM.

2. From the Object menu, choose New > DDM.

   Or:
   Choose the New DDM toolbar button.

   The New DDM - Select Database dialog box appears as shown in the example below:

3. Select an Adabas database. The DBID (database ID) and database type are then shown in the corresponding DBID and Type boxes.

   Or:
   In the DBID text box, enter a numeric value in the range from `0` to `65535` (except `255`).

   If you enter a `0` (zero), the database ID specified with the Natural profile parameter `UDB` (see the Parameter Reference documentation) of the NATPARM parameter file is used.

   If you enter a DBID that is not yet contained in the list box, from the Type combo box, select Adabas if required.

4. Choose OK.

   If the specified DBID identifies an Adabas database, the New Adabas DDM dialog box appears as shown in the example below:

5. In the File number text box, enter a numeric value in the range from `1` to `65535` and choose OK.

   If the specified database and the file are available, the DDM editor is invoked and the fields contained in that database file are read into the editing area.

   If the specified database is not active, cannot be accessed, or if the file does not exist, a corresponding error message is issued. Nevertheless, if you press ENTER, you can still open an empty DDM editor screen, enter new field attribute definitions, and save the DDM source. However, in this case, you cannot check any definitions against the database file description.

6. If required, edit the DDM source: see the section Using the DDM Editor.

7. After editing, from the Object menu, choose Stow and, in the Stow As dialog box, enter the name of the new DDM.

   The syntax of the DDM source is checked and the DDM is saved as a source and a cataloged object. See also Saving and Cataloging a DDM.

## Creating DDMs from SQL

To create a DDM from an SQL database

1. Select the DDMs node or subnode or log on to the library where you want to create the DDM.

2. From the Object menu, choose New > DDM.

   Or:
   Choose the New DDM toolbar button.

   The New DDM - Select Database dialog box similar to the example below appears:

3. Select an SQL database. The DBID (database ID) and database type are then shown in the corresponding DBID and Type boxes.

   Or:
   In the DBID text box, enter a numeric value in the range from `0` to `65535` (except `255`).

   If you enter a `0` (zero), the database ID specified with the Natural profile parameter `UDB` (see the Parameter Reference documentation) of the NATPARM parameter file is used.

   If you enter a DBID that is not yet contained in the list box, from the Type combo box, select `SQL` if required.

4. Choose OK.

   If the specified DBID identifies an SQL database, the New SQL DDM dialog box appears as shown in the example below:

   Select the SQL table for which a DDM is to be created:

   - To list all SQL tables for selection, use the asterisks (*) in the text boxes Table owner and Table name. The asterisks (*) are entered by default.

   - To list a particular range of SQL tables, use asterisk (*) notation, for example, `AB*` selects all SQL tables with names that start with AB.

   Note
   A table catalog is not provided for an SQL database that is accessed through an ODBC interface. In this case, you can only specify a table name but not a table owner.

5. Choose OK.

   The Select SQL Table list box appears with the selection list of SQL tables specified in Step 4 as shown in the example below:

6. From the list box, select the required SQL table and choose OK.

   Depending on your SQL database settings, the Database Logon window appears if you access this SQL database for the first time in this session. Enter the user ID and the password specified for the database and choose OK.

   If the specified database and the file are available, the DDM editor is invoked and the SQL table selected is read into the editing area. A name is generated automatically for the DDM. It is a combination of the table owner and the table name and cannot be changed. For example, if the table owner's name is `SAG` and the table name is `TEST`, the DDM name is `SAG-TEST`.

   If the specified database is not active, cannot be accessed, or if the file does not exist, a corresponding error message is issued. Nevertheless, if you press ENTER, you can still open an empty DDM editor screen, enter new field attribute definitions, and save the DDM source. However, in this case, you cannot check any definitions against the database file description.

7. If required, edit the DDM source: see the section Using the DDM Editor.

8. After editing, from the Object menu, choose Stow and, in the Stow As dialog box, enter the name of the new DDM.

   The syntax of the DDM source is checked and the DDM is saved as a source and a cataloged object. See also Saving and Cataloging a DDM.

## Creating Multiple DDMs from SQL

The following section only applies to a local environment.

The Natural program DDMGEN (supplied in the Natural system library SYSTEM) provides the option to generate multiple DDMs simultaneously from SQL tables without using the DDM editor.

Note
Before you start the creation process, log on to the SQL database.

To execute DDMGEN

1. In the command line of Natural Studio, enter the following:

       DDMGEN

   The SQL DDM Generation screen appears where you can fill the fields required to generate a DDM from an SQL table as demonstrated in the example below:

        SQL DDM Generation
        ==================

        DDM Library  : DDMTEST
        DDM DBID     : 210
        Table Owner  : QA*
        Table Name   : *
        Replace (Y/N): N

   Enter the name of the library where you want to create the DDMs and enter the name of a table and/or specify a range as described in the previous section.

2. Press ENTER to execute the program.

   Status messages appear at the bottom of the screen that indicate which DDM is generated from which SQL table. The DDMs generated are saved as source and cataloged objects in the specified library.

## Creating DDMs from Tamino

#### Only applies to a local Windows environment, or a remote environment on a Windows or a Linux platform.

To create a new DDM from a Tamino database

1. Select the DDMs node or subnode or log on to the library where you want to create the DDM.

2. From the Object menu, choose New > DDM.

   Or:
   Choose the New DDM toolbar button.

   The New DDM - Select Database dialog box appears as shown in the example below:

3. Select an XML database. The DBID (database ID) and database type are then shown in the corresponding DBID and Type boxes.

   The file number (FNR) of the DDM is always `1`. The file number cannot be modified.

   Or:
   In the DBID text box, enter a numeric value in the range from 0 to 65535 (except 255).

   If you enter a `0` (zero), the database ID specified with the Natural profile parameter `UDB` (see the Parameter Reference documentation) of the NATPARM parameter file is used.

   If you enter a DBID that is not yet contained in the list box, from the Type combo box, select `XML` if required.

4. Choose OK.

   If the specified DBID identifies a Tamino database, the Select Doctype window appears with a list of available doctypes as shown in the example below:

5. From the list, select a doctype and choose OK.

   If you are accessing this Tamino database for the first time in this session, the Database Logon window appears. Enter the user ID and password for the database and choose OK.

   The DDM editor is invoked and the DDM generated from the selected doctype is read into the editing area.

6. If required, edit the DDM source: see the section Using the DDM Editor.

7. After editing, from the Object menu, choose Stow and, in the Stow As dialog box, enter the name of the new DDM.

   The syntax of the DDM source is checked and the DDM is saved as a source and a cataloged object. See also Saving and Cataloging a DDM.

## Creating DDMs for VSAM

#### Only applies to a remote environment on a z/OS platform.

DDMs for VSAM files are not generated by Natural. Therefore, instead of selecting VSAM file definitions from a list, you enter DDM field attribute definitions directly in the editing area by using the New option of the Object menu.

### On this page

- Copying DDMs
- Creating DDMs from Adabas
- Creating DDMs from SQL
- Creating Multiple DDMs from SQL
- Creating DDMs from Tamino
- Creating DDMs for VSAM