Defining Fixed-Width File Formats with a Single Format

Access the Select Input form or the Select Outputs form.

  1. Select User Defined Format. and then click Define Format(s).

  2. On the User Defined Format - Type form, select the Fixed Width - Columns are aligned at specific positions with specific widths option.

  3. Select the Single Format - All rows have the same format option, and click Next.

  4. On the User Defined Format - Column Layout form, click Add to define the column layout.

  5. On the New Column Properties form, modify these fields as required, and click OK:

    • Name

    • Start

    • Length

    • Type

  6. To edit an existing column, select the column, click Edit, and change the properties on the Column Properties form.

  7. To model the columns after an existing table, business view, or foreign table, click Model, select the appropriate tab, and then select the table or business view that you want to use as a model for the user-defined format.

    Note: You cannot model the columns after an existing object unless the layout of the two objects match.
  8. Click OK, and then click Next.

    The system copies the format from the model that you selected, and places it into the column layout grid.

  9. On the User Defined Format - Finish form, click Finish.