From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Booth
Sent: Thursday, September 03, 2015 3:15 PM
To: Midrange Systems Technical Discussion
Subject: SQL sort
I am fairly new with SQL so please excuse what are most likely very
I am looking to understand the pros and cons with SQL.
On large files with data that will be used in various applications and
in various sort-by schemes, are logical files a help?
If so, does one reference the physical file and then SQL finds the best
logical, or does it help to specify a specific logical file?
What is the right way to collect a set of records equal to SFLPAGE?
So far, I believe my biggest problem is that I haven't yet figured out
how to ask the right questions.