16.4.4 Specification rules for the optimization information parameter file
- Begin the name of each item in byte 1and complete each item on one line.
- Separate an item name and its value with a blank (two-byte blank) or a tab.
- No more than one item can be specified on each line. One line consists of 80 bytes (not including linefeed code).
- Anything between the # character and the linefeed code is regarded as a comment.
- The same item cannot be specified more than once in the table, index, or column optimization information.
- If a specified value contains a blank or has a length of zero, it (the value) must be enclosed in double quotation marks ("). If a specified value contains a backslash (\), the data immediately following \ is used. To use \ as part of the data, two consecutive backslashes in succession must be specified.
- Items can be specified in any order within a range of index or column optimization information. A range of index or column optimization information begins with an index name or column name and ends when another index name or column name appears.
- If the same index name or column name is specified more than once, the last one specified is effective.