|
Dynamic means that the join criteria is not applied until the query is actually run.
A keyed logical file with Select/Omit is not a dynamic selection because the selection (& omission) of records is done at the time that the logical file is created. The keyed select/omit logical file only contains entries for those rows meeting the select/omit criteria, so no additional selection is applied during the execution of the query or the open of the LF operation. ==================================
MORE INFORMATION ON THIS TOPIC
==================================
Check out this Search400.com Featured Topic: Database issues resolved
Search400.com's targeted search engine: Get relevant information on DB2/400.
The Best Web Links: Tips, tutorials and more.
|