Create a fixed format that uses carriage returns

A fixed-format data file often includes a carriage return (new line) at the end of each record, such as the data file in the following example file.
20 chars          20 chars          15 chars2        chars

John Brown        100 Main St.      Citadel          LA
Mary Smith        3141Temple        WayChesapeake    AZ
Larry Little      44 Elm Rd. #6     Boston           MA
When you prepare the format for this data file, you must include a dummy field for the carriage return. When you create the load map for this format, do not link the dummy field to a database column. The following figure shows the format for the data file illustrated previously.
Figure 1. Fixed format with dummy entry for carriage return
begin figure description - This figure is described in the surrounding text. - end figure description

Copyright© 2019 HCL Technologies Limited