Checking Conversion Using the Provided Sample Data

The following describes the procedure for using the samples provide with this product.  Use these samples to check the operation of Data Converter after installation, etc.  Samples include data values not matching item attributes to trigger the conversion error display function.

1. Activating Data Converter
  From the Start menu (or Program manager), click the Data Converter icon to start Data Converter.
2. Activating the Conversion Information Wizard
  Select New Setup from the File menu or from the toolbar to activate the Conversion Wizard.
3. Conversion Information Wizard(1/5)
  Specify the file conversion mode and the default folder.

Select Data File Conversion as the file conversion mode and specify the folder that stores sample data (DATA1.DAT) as the default folder.

4. Conversion Information Wizard(2/5)
  Specify a layout definition file.  To create a new layout definition file, select Update to activate the Layout Definition Program.
5. Layout Definition Function (Create from COBOL library)
  Click on the Update button to create a new Layout Definition File. Select Create from COBOL library from the File menu to create it from COBOL library(DATA1.CBL)
6. Layout Definition Function (Specifying a Data Format)
  When the analysis of COBOL library is complete, the Data Format dialog is displayed.

Specify the input and output data formats in this dialog.

Select Data file as the Input Data Format and CSV file as the Output Data Format and click OK .

7. Layout Definition Function (Checking, Saving, and Terminating a Layout Definition)
  The result of the analysis is displayed in the list.

Select Save from the File Menu or toolbar, or Save As and enter a new name.  (The extension is ".LAY").

The sample layout definition file (DATA1.LAY) is analyzed and saved in this manner.

After saving the data, terminate the layout definition function and return to the Data Converter's Conversion Information Wizard (Step 2 of 5).

8. Conversion Information Wizard(2/5 After making the layout definition file)
  Specify the file name saved by the layout definition function for the layout definition file name.
9. Conversion Information Wizard(3/5)
  Specify input information.

Specify ASCII as the code system, the sample data (DATA1.DAT) as the file name, and Binary or Text File as the file format.

Specify Fixed Length as the record attribute and 116 as the record length.

10. Conversion Information Wizard(4/5)
  Specify output information.

Specify ASCII as the code system, any file name as the file name (DATA1.CSV by default), Variable length as the record attribute, and New line code (CR+LF) as the delimiter of records.

Additionally, click on Details setup to bring up the CSV Information Setup dialog and set up the CSV format for output.

11. Specifying CSV Information
  Specify CSV information settings.

From the reference settings, select Oracle.  The general loader format of Oracle will be selected.

Click OK and go to Conversion Information Wizard Step 5 of 5.

12. Conversion Information Wizard(5/5)
  Specify other information on conversion.

This information can be changed as required.  It is recommended that the default settings be used for a sample.

Click Finish to complete the Conversion Information Wizard.

13. Preview
  Click the Preview button to bring up the preview screen.

Check that the data is in CSV format. 

Select Exit from the File menu to close the Preview screen.

 

14. Executing Conversion
  Click the Convert button to start the actual conversion processing.

When the conversion processing is complete, a dialog will display the input and output record counts and the error occurrence count.

The results displayed for the sample data are as follows :

Number of input records: 16
Number of output records: 16 
Number of errors:  0

15. Saving a Conversion Information File
  Select Save As from the toolbar to save the conversion file (with the extension of "CIF").
16. Terminating Data Converter
  Select Exit from the File menu to terminate Data Converter.