Report Writer > Conversion Utility > RW Sequential to Index Converter

RW Sequential to Index Converter

You use this program create a user-defined index file from a sequential file.

By converting a sequential file to an indexed file, you can then link the indexed file to the other tables for reporting and/or updating purposes.

Sequential to Index Converter

Field Description
Sequential file name This indicates the name of the sequential file you want to convert.
Import to user defined table This indicates the name of the table you want to create from the sequential file.
Option if user defined file exists Indicate the action to take if the user-defined index file already exists.
Append to existing user file Select this to add the data from the sequential file to the existing table.
Overwrite existing user file

Select this to overwrite the data in the existing table with the data from the sequential file.

The original data in the table will be lost.
Start Conversion

Select this to create the user defined table according to your selections.

Two files are created. The first is the data portion, containing the actual records of information (.dat). The second is the index portion, containing an alphabetical list of all the keys in the data portion (.idx).
Cancel Select this to exit the program without performing the conversion.

Convert a sequential file

  1. From the Sequential to ISAM Converter program, define the Name and Path for the sequential file, in order for the file to be found.

  2. Define the name of the table you want to create.

  3. If the table already exists, you have the choice of appending to the existing file or overwriting the existing file.

  4. Select the Start Conversion function to convert the file.

    [Note]

    Two new files are created.

    The first is the data portion, containing the actual records of information (.dat).

    The second is the index portion, containing an alphabetical list of all the keys in the data portion (.idx).