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.
The output file is a sequential file that contains the
transformed Q2 Block transactions. These transactions will
be used as input to the Database Update (UPDT) procedure.
Note: It is possible to keep the original Block code by
running RMEN to rename the new Q2-type code.