DFT (Default) Keyword--Physical Files Only for Physical and Logical Files

Use this field-level keyword to specify a default value for a field.

The format of the keyword is:

DFT('value' | numeric-value | X'hexadecimal-value' | *NULL)

Without this keyword, character and hexadecimal fields default to blanks and numeric fields default to zeros. However, if you specify the ALWNULL keyword for the field, then the character, hexadecimal, and numeric fields default to the null value.

The following rules apply to the specified value:

The value specified is assigned to the field in the following cases:

The specified value is supplied to the program when the program does an input operation to a join logical file and all of the following are true:

This keyword does not affect the physical file on input operations.