Specify the record format in either of the following two ways:

The record level entries can be FORMAT, TEXT. For a PF the record format name is specified along with an optional text description. Record format level entriesĪ “record format” is a named structure that is used for device file I/O. You can specify the REF keyword only once. To refer to more than one file, use the REFFLD keyword. Specify the file name once in the REF keyword instead of on several REFFLD keywords if each field description refers to the same file. REF supplies the field attributes from a previously defined record format.

REF: File level keyword to specify the name of the file from which field descriptions are retrieved. This is in a first-changed first-out (FCFO) order.Īt least one key field must be specified in the file containing the FCFO keyword. LIFO: File level keyword used to specify that records with duplicate key values from the same physical file member are retrieved in a last-in first-out (LIFO) order.Īt least one key field must be specified in a file containing the LIFO keyword.įCFO: File level keyword used to specify that if records with duplicate key values are retrieved from the same physical or logical file member, the record with the key value that was changed first is the first record retrieved. A copy file command that copies records with duplicate keys in this file is not completed.įIFO: File level keyword used to specify that if records with duplicate key values are retrieved from the same physical or logical file member, they are to be retrieved in a first-in first-out (FIFO) order.Īt least one key field must be specified in a file containing the FIFO keyword. When a workstation user is using data file utility (DFU), a message is displayed at the workstation. The application program issuing the write, or the update operation receives an error message. Any insertions or additions of new records, or updates to existing records, which might result in a duplicate key, are rejected. You can specify whether null key values are to be considered as duplicates using the parameter. UNIQUE: File level keyword used to specify that records with duplicate key values are not allowed within a member of this physical or logical file.

Flat files