With the Data Conversion Tool you convert data from any iSeries physical file to any other iSeries physical files. The tool can, for example, be used to convert data from DC1 6.00 to DC1 7.0.
You have to define at least one specification for each file you want to convert to, but a conversion set, could contain many conversion specifications.
If there are many files to convert, you could proceed as follows: Define the files in conversion specifications in this program. You can collect all the specifications in the same conversion set. In this program you can also run a test conversion. When all files are defined, normally the data conversion is run in the Work with conversion sets program.
This panel displays the conversion specifications and corresponding descriptions that have been set up in your system. In every specification a source file and a target file is defined, together with other information required to convert data in one file to another. You can create, edit, copy, delete, display, print, rename, run, promote, preload or run a test on specifications.
Options
| Run test | Select this option if you want to run a test. No files are updated. This option is only displayed if you press F23. |
Function keys
| F1 | Switch between displaying Identity, PTF, Modification number and Target file clear YES/NO, Run specification YES/NO, Attempt copy file YES/NO, Bespoke program. |
| F8 | Select subset. |
Selection fields
Work with specifications (CVTD3004)
In the upper part of the panel you define the name of the conversion set to which the specifications should be copied. In the bottom part of the panel you defined the names of the new specifications.
- From conversion set
- Displays the conversion set to which the specification you are copying belong.
- To conversion set
- Enter the name of the conversion set to which the specifications should be copied.
- Spec name
- Displays specification you are copying.
- Subset
- Displays the subset to which the specification you are copying belongs.
- New name
- Enter the name of the specification to which you are copying.
- New subset
- Enter a valid subset from the Subset table to which the specification should be copied.
- Identity
- PTF
- Mod
Work with specifications (CVTD3007)
This panel is displayed if the specification to which you are copying already exists. You have the option to delete the existing specification, or cancel the copying.
- Specification that exists
- Displays the name of the specification which already exists.
- Subset
- Displays the subset to which the existing specification belongs.
- Conversion set
- Displays the conversion set to which the existing specification belongs.
- Specification to copy
- Displays the specification which you are trying to copy from.
- Subset
- Displays the subset to which the specification you are copying from belongs.
- Conversion set
- Displays the conversion set to which the specification you copying from belongs.
- Delete existing specification
- Indicate if the existing specification should be deleted and the new one created.
Work with specifications (CVTD3008)
Work with specifications (CVTD300B)
Work with specifications (CVTD300E)
- Conversion set
- Displays the conversion set to which the specification you are renaming belong.
- Spec name
- Displays specification you are renaming.
- Subset
- Displays the subset to which the specification you are renaming belongs.
- New name
- Enter the name of the new specification.
Work with specifications (CVTD300H)
Work with specifications (CVTD300K)
- Conversion set
- Displays the conversion set to which the specifications you are promoting belong.
- Spec name
- Displays specification you are promoting.
- Subset
- Displays the subset to which the specification you are promoting belongs.
- New subset
- Enter a valid subset from the Subset table to which the specification should be promoted.
- Identity
- PTF
- Mod
Work with specifications (CVTD300N)
This is the starting panel for preloading conversion specifications. When you preload, the file formats in the source file and target file are preloaded to make a connection between the fields and to find their from-to positions.
If the Preload at execution field on the Edit specification (CVTD3021) panel is set to YES, the file format is always preloaded before conversion.
- Conversion set
- Displays the conversion set to which the specifications you are preloading belong.
- Reset default field functions
- Indicate if you want to reset the default field functions. Default field functions are defined on the Work with default field functions (CVTD2001) panel. Note: This option is useful when a large number of specifications have already been created and a new default field function has been added for the displayed conversion set. Resetting default field functions does not alter manually maintained field specifications on the Maintain field specifications (CVTD4041) panel.
- Reset field to field connections
- Indicate if you want to reset the field to field connections. If you set this field to YES, the from-to positions for the existing field specifications are reset. Note: Resetting field to field connections does not alter manually maintained field specifications on the Maintain field specifications(CVTD4041) panel.
- Spec name
- Displays specification you are preloading.
- Subset
- Displays the subset to which the specification you are preloading belongs.
- Description
- Displays the description of the specification you are preloading.
Work with specifications (CVTD300Q)
This panel displays all the records you selected to run a test. Press Enter to run. Press F12 to regret.