2.84 FILLSHORTRECS | NOFILLSHORTRECS

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