DDS for physical and logical files

Specifying record formats in a logical file in DDS

If there is more than one record format specified in a logical file, you must specify the PFILE keyword for each record format.

There are three ways to specify the fields in a record format:

Figure 1 illustrates the three ways to specify fields.

For each of the three ways to specify fields in a record format, you can have one of the following access path specifications:

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. See Table 1 for rules on determining the total length of the record format.


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