|
JOIN Join Records
The Join command is the inverse of the Split command.
The next n records from the second in the display are processed as follows: if the ISAM key of the record lies within the step size (see below), then it will be appended to the previous record.
n Number of records: 1 <= n <= 99999. Standard: n = 1. Only one record is processed.
The character '$' instead of a number n indicates the highest possible number 99999
J=m m sequential records will be joined to make a single record.
step 0 | 10 | 100 | 1000 | 10000
The step value that the original ISAM keys would have had must be specified. See also the IS command on page 8-.
A record is regarded as lying within the step size and will be appended to the previous record if it's ISAM key
is equal to the key of the predecessor record (step=0)
has a value > 0 and < 10 in the last position (step=10)
has a value > 0 and < 100 in the last 2 positions (step=100)
has a value > 0 and < 1000 in the last 3 positions (step=1000)
has a value > 0 and < 10000 in the last 4 positions (step=10000).
If a record lies within the step size, then it is certain that it is a succeeding record created by a previous SPLIT command. The relationship to the main record is clearly established.
Note:
When processing an ISAM file that has been SPLIT into multiple smaller records in EDT or CFS Editor, the following should be noted: the ISAM key must not be amended, no new records should be inserted, and no records should be deleted. A totally successful JOIN of the split records can only be guaranteed if these conditions have been fulfilled.