Previous Topic: Extract PathsNext Topic: Glossary


Customization

This appendix contains the following topics:

This section contains the following topics:

Introduction

Installation Parameters

Message Severity

Entity Exclusion Table

Manipulation of the Extract File

Introduction

CA IDMS Dictionary Migrator can be customized in the following general areas:

Area

Customization

Installation Parameters

A set of options that are made to non-standard processing to meet special situations described in the CA IDMS installation guides.

Message Severity

The severity of some messages can be changed to correspond to an installation's standards. Messages can be omitted from reports or to stop processing.

Entity Exclusion Table

The exclusion table can define any entity occurrences that you do not want migrated.

Manipulation of the Extract File

The format of the extract file is described to help you when you want to use the extract file for any further processing.

Installation Parameters

Note: For more information about these parameters, see the CA IDMS installation guides.

Message Severity

This section contains information about message severity.

Customization Instructions

Dictionary Migrator provides a facility where the severity level of messages can be changed.

Note: You do not need to use this facility for the proper execution of CA IDMS Dictionary Migrator. The facility is provided for users whose shop standards mandate some deviation from the basic migration strategy. This option is not used in default execution mode of CA IDMS Dictionary Migrator. Therefore, no load module is provided as part of the standard installation process.

General

This facility allows the CA IDMS Dictionary Migrator user to generate a table of specific messages along with their required severity levels.

Message Severity Level Table Generation Steps

The following are Message Severity Level Table Generation Steps:

  1. Customize the source member USMSGSVT from the SRCLIB library.
  2. Assemble and link edit this member into your CA IDMS Dictionary Migrator Loadlib.

Message Severity Level Table Customization

Edit the source member USMSGSVT as follows:

First Line:

#EXCLTAB TBLNAME=USMSGSVT

For each Message that has a severity level that needs to be changed, add a line that invokes the #MSGSEV macro with the required parameters.

#MSGSEV MSG=messageid,SEV=severitylevel

where:

messageid - is a 7 Character Message ID whose first four characters correspond to one of the following:

The messages with the first four characters that do not correspond to one of the above may not have their severity levels altered.

severitylevel - is a single character either:

These characters may be interpreted as:

Last Lines:

#EXCLEND
END

Sample Table:

#EXCLTAB TBLNAME=USMSGSVT
#MSGSEV  MSG=ES00515,SEV=X
#MSGSEV  MSG=VALD219,SEV=C
#EXCLEND

Assembly and Linkage

Any level of IBM assembler and linkage editor can be used to create the Message Severity Level table.

  1. MACLIB of the assembler step: Add the SRCLIB from installation to the files named in MACLIB.
  2. SYSLMOD of the link edit step: Use the same LOADLIB from which CA IDMS Dictionary Migrator is executed.

Note: No default Message Severity Level table is provided. If you wish to generate this table see the SRCLIB member USMSGVT.

Entity Exclusion Table

The following instructions explain how to make use of the entity exclusion facility and detail what entity types may be excluded.

Customization Instructions

CA IDMS Dictionary Migrator provides a facility where specific entity occurrences can be excluded from the migration process.

Note: You do not need to use this facility for the proper execution of CA IDMS Dictionary Migrator. The facility is provided for users whose shop standards mandate some deviation from the basic migration strategy. A default version of this module with no entities excluded is provided in load module form as part of the standard installation process.

General

This facility allows the CA IDMS Dictionary Migrator user to generate a table of specific entities that are to be excluded from the migration process.

Entity Exclusion Table Generation Steps

  1. Customize the source member USMEXCLD from the SRCLIB library.
  2. Assemble and link edit this member into your CA IDMS Dictionary Migrator Loadlib.
  3. At Execution time, define the Entity Exclusion Table to be used to CA IDMS Dictionary Migrator through the EXCLTAB parameter. This step is only necessary if a table name other than the default USMEXCLT is to be used.

Entity Exclusion Table Customization:

Edit the source member USMEXCLD as follows :

First Line:

#EXCLTAB TBLNAME=yourname.
Use any name up to 8 characters following standard naming rules.
Default name=USMEXCLT.

For each entity occurrence to be excluded, add a source line that invokes the #EXCLENT macro with the required parameters:

#EXCLENT TYPE=entitytype,
NAME=entityname,
VERS=version,  (if applicable)
QUAL=qualifier (if applicable)

where :

entitytype (Required)—One of the following entity types that must be specified in uppercase and can be abbreviated to the first two characters.

AT(TRIBUTE)
CL(ASS)
DI(ALOG)
EL(EMENT)
FI(LE)
MA(P)
MO(DULE)
PR(OGRAM)
RE(CORD)
SC(HEMA)
SU(BSCHEMA)
SY(STEM)
US(ER)

entityname (Required)—Entity Occurrence Name in uppercase.

version (Optional)—Defaults to version number 1. Version number or ALL (for all versions). Version numbers apply to all entity types except from Attribute, Class, and User.

qualifier—Applies to the following entity types (must be in uppercase):

Note: ADS process modules are stored in the Data Dictionary with a language name = PROCESS. If you want to exclude an ADS module from the migration, you should specify QUAL=PROCESS on the #EXCLENT line entry for the module to be excluded.

Last Lines:

#EXCLEND
END

Sample Table:

#EXCLTAB TBLNAME=EXCLTAB
#EXCLENT TYPE=RECORD,NAME=TESTREC,VERS=100
#EXCLENT TYPE=ATTRIBUTE,NAME=WORK,QUAL=STATUS
#EXCLEND
END

Assembly and Linkage

Any level of IBM assembler and linkage editor can be used to create the Entity Exclusion Table. As indicated above, the default Entity Exclusion Table name is USMEXCLT. If you want to utilize a table with a different name, remember to indicate the named table on the EXCLTAB CA IDMS Dictionary Migrator parameter. For example, EXCLTAB=mytable.

  1. MACLIB of the assembler step: Add the product installation MACLIB to the files named in MACLIB.
  2. SYSLMOD of the link edit step: Use the same LOADLIB from which CA IDMS Dictionary Migrator is executed.

Default Entity Exclusion Table (table name USMEXCLT)

#EXCLTAB
#EXCLEND




END

Manipulation of the Extract File

The extract file is a set of extract records that can be manipulated.

Extract Record

The following is a COBOL definition of the extract record. A description of the various fields follows the definition.

 01     MIGRATOR-EXTRACT
        05     EXTR-CO-LOC.
               10      EXTR-CHANGEONLY              PIC    X(01).
               10      EXTR-EXTRACT-LEVEL           PIC    X(01).
        05     EXTR-VSAMEXT-KEY.
               10      EXTR-ENTITY-TYPE             PIC    S(4) USAGE IS COMP.
               10      EXTR-ENTITY-NAME             PIC    X(40).
               10      EXTR-SELECT-VERSION          PIC    S9(4) USAGE IS COMP.
               10      EXTR-ALT-ENTITY-NAME         PIC    X(40).
        05     EXTR-ENTITY-LEVEL                    PIC    X(2).
        05     EXTR-ENTITY-UTILITY                  PIC    X(2).
        05     EXTR-SELECT-DICTIONARY               PIC    X(8).
        05     EXTR-SELECT-NODE                     PIC    X(8).
        05     EXTR-SOURCE-USER                     PIC    X(32).
        05     EXTR-SOURCE-PASSWORD                 PIC    X(8).
        05     EXTR-COBOL-FORMAT                    PIC    X(01).
        05     EXTR-MOVESTAMP                       PIC    X(01).
        05     EXTR-SELECT-COMMENT-SOURCE           PIC    X(01).
        05     EXTR-SELECT-DEFINITION-SOURCE        PIC    X(01).
        05     EXTR-GENERATE                        PIC    X(01).
        05     EXTR-RESERVED-1                      PIC    X(14).
        05     EXTR-LOAD-TYPE                       PIC    S9(4) USAGE IS COMP.
        05     EXTR-RESP-OVERRIDE                   PIC    X(01).
        05     EXTR-COMPARE-DATE.
               10      EXTR-COMPARE-MN              PIC    X(02).
               10      FILLER                       PIC    X(01).
               10      EXTR-COMPARE-DD              PIC    X(02).
               10      FILLER                       PIC    X(01).
               10      EXTR-COMPARE-YY              PIC    X(02).
        05     EXTR-COMPARE-TIME.
               10      EXTR-COMPARE-TIME-6.
                       15     EXTR-COMPARE-HH       PIC    X(02).
                       15     EXTR-COMPARE-MN       PIC    X(02).
                       15     EXTR-COMPARE-SS       PIC    X(02).
               10      EXTR-COMPARE-HN              PIC    X(02).
05     EXTR-RESERVED-2                      PIC    X(44).

Field Definitions and Values

Values for Utility Types

Item

Value

Special Record

value '01'

IDMSQDDL

value '06'

Idmsdddl

value '10'

Tablddl

value '12' IDMSDDDL for tables only

Loadddl

value '15' IDMSDDDL for load modules only

reserved

value '20'

Idmschem

value '25'

Objdchem

value '26' IDMSCHEM from object dictionary

reserved

value '28'

Idmsubsc

value '30'

Objdubc

value '31' IDMSUBSC from object dictionary

Rhdcmput

value '40'

Objdmput

value '41' RHDCMPUT from object dictionary

Progdddl

value '50' IDMSDDDL for programs only; also creates ADSOBCOM statements for dialogs

Objpdddl

value '51' ADSOBCOM statement from object dictionary.

reserved

value '90'

reserved

value '95'

Value for Entity Type Codes

Item

Value

Special weight (used for CA IDMS Dictionary Migrator control)

value +01

Message delete

value +03

Load delete

value +05

Dialog delete

value +10

Program delete

value +11

Subschema delete

value +20

Reserved

value +23

Schema delete

value +25

Map delete

value +28

Table delete

value +29

Process delete

value +30

Qfile delete

value +31

Reserved

value +33

Module delete

value +35

File delete

value +36

Panel delete

value +37

Record delete

value +39

Report delete

value +41

Transaction delete

value +43

Element delete

value +45

System delete

value +46

Attribute delete

value +47

User delete

value +48

Class delete

value +49

Class

value +50

Module

value +51

User (pre)

value +52

Attribute

value +54

System

value +56

Application

value +57

Element

value +60

Reserved

value +62

Qfile

value +63

Process

value +64

Table

value +66

File

value +68

Record

value +70

Report

value +71

Transaction

value +72

Panel

value +73

Schema

value +75

Reserved

value +85

User (post)

value +88

Map

value +78

Subschema

value +79

Program

value +80

Dialog

value +82

Reserved

value +86

Reserved

value +87

Load Module

value +90

SQL SCHEMA

value +91

Reserved

value +92

SQL TABLE

value +93

SQL VIEW

value +94

Message

value +95

Reserved

value +96

CONSTRAINT

value +97

TABLE PROCEDURE

value +98

SQL KEY

value +99