|
Type |
Length In Bytes |
# Of Records Written |
|
header |
256 |
One (1) |
|
trailer |
80 |
One (1) |
|
ssrec |
36 |
One (1) for each selected record type in the source subschema |
|
ssset |
36 |
One (1) for each selected set type in the source subschema |
|
dbrec |
28 + data length of selected database record |
One (1) for each selected: - Entry Record - owner and member record of each selected set occurrence |
|
index |
20 |
One (1) or more for each index to which a selected record is connected. These are written for records retrieved through an area sweep, index, or set walk. If a selected record is both an entry record (or indexed through an entry index) and a selected owner or member of a selected set occurrence, multiple index extracts are written. |
Review your Selection Criteria Specification to estimate the number of database records that will be extracted.
The Database Load Component creates a Workfile from the Extract File. You must allocate the same amount of space for the Workfile as the Extract File. The Workfile is also variable-blocked. The Database Load Component calculates the LRECL of the file for you with a BLKSIZE of 6144. You can override this block size.
Provide enough SORT SPACE capacity for the entire Workfile.
|
Copyright © 2013 CA.
All rights reserved.
|
|