Valid for
Extract, Replicat
Description
Use FILLSHORTRECS
to tell the Extract to fill the end of data records to fit their maximum configured length with spaces, zeros or SQL default column values. Use this to generate records in the trails, that are a constant length or contain the same number of columns.
FILLSHORTRECS
can also be used for Replicat MAP
statements that have a COLMAP
statement to trigger mapping.
This functionality can be toggled on and off around FILE
or MAP
statements by using NOFILLSHORTRECS
.
Default
NOFILLSHORTRECS
Syntax
FILLSHORTRECS | NOFILLSHORTRECS