When creating a new file to be merged with an existing file,
both files must have the identical format. For example, when creating
the file NEWHIRES to be merged with the existing file EMPLOYEE, the beginning position of each key data item
must be identical in both files. The file EMPLOYEE contains four key data items in each record (employee's
last name, first name, job title, and employee number). The format
for the first two lines of the file EMPLOYEE is shown in Figure 4-1 “File Format For Merging”
Since you want the file format for NEWHIRES to be identical to the file format of EMPLOYEE, you would allow 11 characters (columns) for last
names, beginning in position 1; 11 characters for first names, beginning
in position 12; 19 characters for job titles, beginning in position
23; and 4 characters for employee numbers beginning in position
42. Use the starting position location for each key data item as
tab settings when creating the file. A single line record can contain
up to 80 characters.
If any of the key data items in the file NEWHIRES is longer than the number of characters established
for the key data items in the file EMPLOYEE you may need to alter the format in both files.
All characters exceeding established character limits are truncated
and do not appear in the file COMPANY.
Printable version
