20 pts.
 DYNSLT (Dynamic Select Concept)
Hello All,

This question is regarding the dynamic selection concept in DB2/400. As we know we can create a LF with our without the DYNSLT keyword.

The question is what is the difference in using LF with and without DYNSLT?

What should I prefer if my PF handles millions of records?

Thanks in advance



Software/Hardware used:
ASKED: November 16, 2011  9:53 AM
UPDATED: November 16, 2011  2:29 PM

Answer Wiki:
When your program does input operations to a logical file with the DYNSLT keyword specified, all the records in the associated physical file are tested by the system to see if they satisfy the select/omit values. Only those records that satisfy the values are supplied to your program. The testing of each record can result in slower I/O performance, but can be more efficient than maintaining an access path for the file. This is particularly likely for files read only occasionally, especially when the physical files they are based on are updated frequently. Using dynamic select/omit is probably also more efficient for files with a high percentage of selected records.
Last Wiki Answer Submitted:  November 16, 2011  2:29 pm  by  CharlieBrowne   32,855 pts.
All Answer Wiki Contributors:  CharlieBrowne   32,855 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _