3.4.5 Dynamic Select

Mandatory.

Specify whether or not any select/omit tests specified on the lower portion of the screen are to be done at execution time.

Default=NO

Rules

• NO (unchecked/not selected), indicates that the dynamic select feature should not be used. In this case the access path associated with the index will contain only records that match the select/omit criteria specified.

• YES (checked/selected) , indicates that the dynamic select feature should be used. In this case the access path associated with the index will contain all records in the table. The select/omit testing should be done when the program reads the records from the table.

Tips & Techniques

• If you specify YES (checked/selected), then do not specify any select/omit tests or else the value will be automatically changed back to NO.

Platform Considerations

• IBM i: The dynamic select facility is a feature of the operating system. Using it can have significant overall performance benefits in some situations. For more information about this facility refer to the appropriate IBM supplied manual.