TRDQ - Conversion of DBD Blocks into SQL Blocks
The TRDQ utility transforms DB2 Database Blocks (DB type) into SQL DBD Blocks (Q2 type).
First step.
From the command lines, input lines of RMEN are formatted with the RENAME option (RN).
Second step.
RMEN renames the DB-type Block codes into new Block codes that are specified in the command line.
RMEN creates a sequential file that contains the following transactions:
- Creation and modification transactions with the
new Block code, sorted by:
- Ascending library hierarchical level,
- Library,
- Record type (definitions, descriptions, uses).
- Deletion transactions with the old Block code,
sorted by:
- Descending library hierarchical level,
- Library,
- Record type (uses, descriptions, definitions).
Third step.
Transformation of DB-type Blocks into Q2-type Blocks.
From the output file of RMEN and the command lines, transformation of records:
- Definition of new Blocks: the DB-type is transformed into Q2-type. The external name and the label can be modified.
- Description of Codasyl-DB2 Database Blocks (-DC): it is transformed into the description of relational Blocks (-DR).
- Documentation of Codasyl-DB2 Database Blocks description (-DC...GG; -DC...GC): it is transformed into the documentation of relational Blocks description (-DR...GG; -DR...GC).
The other records produced by RMEN are copied without transformation in the output transactions file.
There is no execution condition because the database is not directly updated. However, the use of the RMEN procedure is subject to a separate purchase agreement.
This procedure prints, in the PACX (RMEN) step, a selection report with the errors, if any.