On this panel you define information concerning the conversion of data, such as source file, target file, if any program should be executed before/after the conversion etc.
You have to define one specification for each file you want to convert, but a conversion set, created in the Edit conversion set program, could contain several 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 put all the specifications in the same conversion set (the conversion set must have been created).
Function keys
| F9 | Maintain the additional source files. |
| F10 | Maintain the field specifications. |
- Conversion set
- Displays the conversion set to which the specification you are editing belongs.
- Specification name
- Enter the name of the conversion specification.
- Subset
- Enter a valid subset from the Subset table to which the specification belongs.
- Identity
- PTF/Mod number
- Conversion sequence
- Mandatory entry. Enter a sequence number. The sequence number determines the order in which the specifications within a conversion set will be executed.
- Change date
- Description
- Enter a description of the conversion specification.
- Target file
- Enter the name of the file to which you want to convert data.
- Source file
- Enter the name of the file from which you want to convert data. This file is considered as the main file. You can select additional files by pressing F9. A maximum of four additional files are allowed.
- Target file library
- Enter the name of the library containing the file to which you want to convert data. If you enter *LIBL the current library list is searched to find the target file. If you enter *CVTSETTGT the library defined in the Target library field on the Edit conversion set (CVTD1021) panel will be searched to find the target file.
- Source file library
- Enter the name of the library containing the file from which you want to convert data. If you enter *LIBL the current library list is searched to find the source file. If you enter *CVTSETSRC the libraries defined in the Src lib field on the Edit conversion set (CVTD1021) panel will be searched to find the source file.
- Target file member
- Enter the name of the member in the to file to which you want to convert data. The member must exist in the to file. If you enter *FIRST the first member in the to file will be used.
- Source file member
- Enter the name of the member in the from file from which you want to convert data. The member must exist in the from file. If you enter *FIRST the first member in the from file will be used.
- Source file ID
- Mandatory entry. Enter a two-character identity code by which the main file is identified.
- Target file clear
- Indicate if you want to clear the target physical file member before converting data.
- Source file dec sign
- Enter the sign used as decimal separator in the from file. This may be useful if you are converting PC-text files where numeric fields have the decimal sign included in the data.
- Run specification
- Indicate if you want to run the actual data conversion task for this specification. This may be useful if you only want to clear the target file.
- Pgm to run before
- If you want to execute a specific program before execution of this conversion specification (which means before the actually conversion of data), enter the program name here. No check is done to determine if the program exists.
On the Confirm conversion items to run (CVTD6051) panel, the item function of this program will be *RUNBEFCNV. Note: If you enter a program name, the library containing the program must exist in the library list when executing this conversion specification. Otherwise the entry *RUNBEFCNV will not be found.
- Attempt copy file
- Indicate if you want to attempt to convert the data from the source file into the target file using the CPYF (Copy file) command. If the command fails the data conversion tool will perform the conversion.
- Pgm to run after
- If you want to execute a specific program after execution of this conversion specification (which means after the actually conversion of data), enter the program name here. No check is done to determine if the program exists. On the Confirm conversion items to run (CVTD6051) panel, the item function of this program will be *RUNAFTCNV. Note: If you enter a program name, the library containing the program must exist in the library list when executing this conversion specification. Otherwise the entry *RUNAFTCNV will not be found.
- Preload at execution
- Set this field to YES if you want to preload the file format in this specification every time it is run. Otherwise set this field to NO. The preloading function tries to match the fields in the source file(s) with the fields in the target file, to find their from-to positions.
- Bespoke program
- If you have a data conversion task that can not be handled by the data conversion tool you can specify a program name that you want to perform the data conversion. You can create the skeleton for the bespoke program source member by entering CREATEBSPP in this field. Note: You must first complete the entry for the specification before creating the bespoke program source member.
- Field mask
- In this field you specify how to compare field names when the specification is preloaded. The preloading function tries to match the fields in the source file(s) with the fields in the target file, to find their from-to positions. A percent character indicates that any number of character can exist. An asterisk indicates that a certain position in the field name should be included in the comparison.
Example: Field mask = %****
The last four characters of the source and target field names must match.
- Text mask
- In this field you specify how to compare field text when the specification is preloaded. The preloading function tries to match the fields in the source file(s) with the fields in the target file, to find their from- positions. An asterisk indicates that a certain position in the field text should not be included in the comparison.
Example: Text mask = **********************************
The first 10 positions of the source and target field’s text must match.