This appendix contains the following topics:
This section contains the following topics:
Manipulation of the Extract File
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. |
Note: For more information about these parameters, see the CA IDMS installation guides.
This section contains information about message severity.
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.
This facility allows the CA IDMS Dictionary Migrator user to generate a table of specific messages along with their required severity levels.
The following are Message Severity Level Table Generation Steps:
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
Any level of IBM assembler and linkage editor can be used to create the Message Severity Level table.
Note: No default Message Severity Level table is provided. If you wish to generate this table see the SRCLIB member USMSGVT.
The following instructions explain how to make use of the entity exclusion facility and detail what entity types may be excluded.
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.
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.
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
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.
#EXCLTAB #EXCLEND END
The extract file is a set of extract records that can be manipulated.
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).
|
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' |
|
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 |
|
Copyright © 2014 CA.
All rights reserved.
|
|