The functions provided in the SYSDDM utility menu are used to create, display, edit, rename or delete a DDM.
This section describes the fields and functions available in the SYSDDM utility menu and provides information on maintaining DDMs in different environments.
This section provides instructions for obtaining information on the fields and functions provided in the SYSDDM utility menu.
To display SYSDDM help information
On the SYSDDM utility screen, press PF1.
Or:
In the Command line, or in any input field, enter a question mark
(?).
The Help Main Menu of the SYSDDM utility appears.
Position the cursor next to the greater than (>) sign of the help topic required and press PF1.
The SYSDDM help screen appears for the topic selected.
To scroll forward, press ENTER.
To return to the Help Main Menu, press PF3.
To terminate the help function and return to the SYSDDM utility menu, press PF12.
To exit the Help Main Menu, enter a period (.) or press PF3.
The SYSDDM utility menu appears.
This section provides instructions for performing a function from the SYSDDM utility menu.
To perform a function
In the SYSDDM utility menu:
From the section DDM Maintenance, List/Copy Services or Other Services choose the one-digit code listed next to the function required and enter it in the Code field.
For example: to edit a DDM, enter the function code
E.
The functions are explained in Description of Functions.
In the input fields next to Code, enter a valid value to specify the DDM(s) to be processed as described in DDM Specification.
This section describes the functions available on the SYSDDM utility menu and lists their corresponding function codes:
| Function Code | Field | Function | ||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| E | Edit DDM | Invokes the DDM editor and reads a DDM source from the FDIC system file into the source area. | ||||||||||||||||||||||||||||||||||||||
| R | Read DDM | Reads a DDM source from the FDIC system file into the source area but does not invoke the DDM editor. | ||||||||||||||||||||||||||||||||||||||
| C | Catalog DDM | Saves the DDM source currently contained in the source area as
a cataloged object in the current FDIC system file.
For the naming conventions that apply when cataloging a DDM, refer to Object Naming Conventions in the Using Natural documentation. If the source area is empty, use the function Generate DDM from Adabas FDT or Edit DDM to load a source into the source area. For a DDM from VSAM (DDM Type set to
For details, see Natural File Access in the Natural for VSAM documentation. |
||||||||||||||||||||||||||||||||||||||
| U | Delete DDM | Deletes one or more cataloged DDM from the FDIC system file.
The contents of the source area are not affected by the deletion. When you delete a DDM with SYSDDM, the corresponding Natural Security file profile is deleted too. |
||||||||||||||||||||||||||||||||||||||
| L | List DDMs | Displays a single DDM source (DDM editor not invoked)
or a list of DDMs stored in the specified FDIC system file similar to the
Natural system command LIST
DDM described in the System
Commands documentation. However, unlike the system command
LIST DDM, the List DDMs
function additionally displays all DDMs for which no read or update access
right is defined in Natural Security (if installed). For details, see
Protecting DDMs On
Mainframes in the Natural Security
documentation.
From the list of DDMs displayed on the LIST DDMs screen, you can select a DDM for further processing by entering the line command that corresponds to the action required in the Cmd column. For information on possible commands, enter a question mark (?) in the Cmd column. |
||||||||||||||||||||||||||||||||||||||
| X | List DDMs with Additional Information |
|
||||||||||||||||||||||||||||||||||||||
| S | Show Defined DBIDs and Used FNRs | See Show Defined DBIDs and Used FNRs. | ||||||||||||||||||||||||||||||||||||||
| M | Copy DDM to Another FDIC File | Copies one or more DDMs from one FDIC system file to another.
This can be required, for example, when a Natural application is transferred
from test to production status.
This function invokes the Copy DDMs window of the Natural utility SYSMAIN where you can specify source and target environment of the DDM(s) to be copied; see also the section Processing DDMs in the SYSMAIN Utility documentation. |
||||||||||||||||||||||||||||||||||||||
| G | Generate DDM from Adabas FDT | Generates a DDM from an Adabas field definition table (FDT) and
places it in the source area for further processing.
If The generated DDM is placed in the source area for further processing. |
||||||||||||||||||||||||||||||||||||||
| B | SQL Services (NDB/NSQ) | Only available if Natural for DB2 (NDB) or Natural for SQL/DS
(NSQ) is installed.
SQL Services (NDB/NSQ) are used to generate DDMs from DB2 or SQL/DS tables as described in SQL Services (Natural for DB2 documentation) and SQL Services (Natural for SQL/DS documentation). |
||||||||||||||||||||||||||||||||||||||
| D | DL/I Services | Only available if Natural for DL/I is installed.
DL/I Services are used to maintain a Natural for DL/I environment. They provide functions for inquiry into and modification of structures such as DL/I Database Descriptions (DBDs), Program Specification Blocks (PSBs), Program Communication Blocks (PCBs), DDMs and segment layouts. DL/I Services are described in the Natural for DL/I documentation. |
||||||||||||||||||||||||||||||||||||||
| Z | SQL Services (NSB) | Only available if Natural SQL Gateway (NSB) is
installed.
SQL Services (NSB) are used to generate DDMs from SQL tables as described in SQL Services (NSB) in the Natural SQL Gateway documentation. |
||||||||||||||||||||||||||||||||||||||
This function shows you which database IDs (DBIDs) are defined, as well as all file numbers (FNRs) of a given DBID for which DDMs have been defined.
When you invoke this function, a menu appears from which you can select the subordinate functions described in the following section.
This function lists all DBIDs and appropriate database types specified
with the Natural profile parameter DB (see also
DB - Database Types and
Options in the Parameter Reference
documentation). The list does not contain the DBIDs of the default database
type, which is shown at the top of the screen.
This function lists for a given DBID all file numbers for which DDMs have been defined.
To invoke this function, choose either of the following
methods:
In the menu , in
the Code field, enter an F and, if required,
modify the DBID entered by default.
Or:
On the screen Database IDs Defined in Natural,
in the Command line, enter a DBID (valid values are 1 -
65535) and press PF5.
For each function provided in the SYSDDM utility menu, you can specify one or more parameters that determine which DDM(s) are processed for which database. The section below describes the fields where you enter these parameters.
| Field | Explanation | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DDM Name | The name of the DDM to be processed.
You can also specify a range of names: use asterisk (*) to process all DDMs or use asterisk (*) notation to process particular DDMs. For example: Specifying ranges with the function Delete DDMs or Copy DDM to Another FDIC File invokes the SYSMAIN utility where you can further process the DDMs; see also the section Processing DDMs in the SYSMAIN Utility documentation. |
||||||||||||||||||||||||
| FNR | The file number (FNR) of the database file for which the DDM is
(to be) defined.
The file number corresponds to the type of database. For example, if an Adabas file is used, the Adabas file number must be entered. If a DL/I segment type is used, the file number specified is used internally by Natural for DL/I. For VSAM files, see the Natural for VSAM documentation. Valid values are |
||||||||||||||||||||||||
| DBID | The database ID (DBID) which contains the database file
referenced by the DDM.
Valid values are If If no DBID is entered, it is generated dynamically at execution time based on the DBID of the system file FUSER. |
||||||||||||||||||||||||
| Replace |
|
||||||||||||||||||||||||
| FDIC Type | The database type of the system file.
Possible types are the same as for DDM Type (see below). This is an output field only. |
||||||||||||||||||||||||
| DDM Type |
|
||||||||||||||||||||||||
| Adabas Password | The password required by Adabas if installed. | ||||||||||||||||||||||||
| DBID Type | The database type of the database specified in the
DBID field.
Possible types are the same as for DDM Type (see above). Exception: for an Adabas database, the Adabas version (for
example, This is an output field only. |
||||||||||||||||||||||||
