ZONED(GJASZB/100), 5) BETWEEN 10901 AND 10912
This is the result of the IBM conversion tool of *QRYDFN
in *QMQRY. The optimizer change the order of join files and the result data set
is always smaller than the original. There is a mean to force it to respect the
initial order like in ORACLE?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!