DDS for physical and logical files


Defining a physical file using DDS

A physical file can contain only one record format. Specify the record format in either of two ways:

Specify the entries in the following order to define a physical file:

  1. File-level entries (optional)
  2. Record-level entries
  3. Field-level entries
  4. Key field-level entries (optional)
Note:
The file name is specified through the Create Physical File (CRTPF) command, not through DDS.

You can find an explanation of file-, record-, field-, and key field-level specifications in the Describing data attributes using DDS topic.

Refer to the DDS Reference: Concepts information for rules when specifying record or field names in DDS.

The maximum number of fields in a record format is 8000. If any of the fields in the record format are date, time, timestamp, variable length, or allows the null value, then the actual maximum number of fields can be less than 8000. The maximum number of fields can vary depending on the number of fields and combinations of fields that occur within the record format. The maximum number of bytes in a record format is 32 766 if variable length fields are not included and 32 740 if variable length fields are included. Table 1 describes rules for determining the total length of the record format.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]