FillRecord option
Specifies whether to allow an input line with fewer columns than that of the table definition. If you do not specify the option, an input line with fewer columns than that of the table definition is not allowed.
By default, the system expects one input field for every column in the schema of a target table and rejects a row with fewer fields. If you specify the FillRecord option, the system allows the omission of one or more trailing (rightmost) fields if all corresponding columns can be null.
This option is not supported for the fixed-length format.