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.
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
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:
|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 Database Management System Interfaces 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
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
|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.
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 (NDB/NSQ) (Natural for DB2) and SQL Services (Natural for SQL/DS) in the Database Management System Interfaces 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 Database Management System Interfaces documentation.
|Z||SQL Services (NSB)||Only available if Natural SQL Gateway (NSB) is
SQL Services (NSB) are used to generate DDMs from SQL tables as described in SQL Services (NSB) in the Database Management System Interfaces 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 Code field, enter an
F and, if required,
modify the DBID entered by default.
On the screen Database IDs Defined in Natural, in the command line, enter a DBID (valid values are
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.
|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.
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 Natural for VSAM in the Database Management System Interfaces documentation.
Valid values are
|DBID|| The database ID (DBID) which contains the database file
referenced by the DDM.
Valid values are
If no DBID is entered, it is generated dynamically at execution time based on the DBID of the system file FUSER.
|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.
|Adabas Password||The password required by Adabas if installed.|
|DBID Type|| The database type of the database specified in the
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.