Re: OPNQRYF Education

Pat asked...

>Does anybody know of a decent book that goes into a lot of detail
>about opnqryf ??? I have used it for years to do simple sorts, and
>"VERY" simple record selections but I would now like to expand my
>knowledge of this very powerful command, but figuring out how many
>""""""""""" is a little too much when you get in a hurry and want to
>do somthing as simple as select records from a file that are stored
>with date values mmddyy and you wish to do a range selection..... 
>just too many *cat,*bcat,',"""",,etc,etc.... throw in some passed
>variables and you end up somthing that looks like Fortran done in a
>drunken rage.........

While the books mentioned are no doubt very good...

This is a good reason to take up SQL! ;) 

SQL syntax is just about as regular and understandable as OPNQRYF's is 
murky, and the skills transfer to many other products, which is a big 
deal. Embedded SQL delivers the same results with clearer syntax, no? 

ASC's SEQUEL (which is missing at my current client :( has a really nice 
OPNSQLF command that allows a path to be created in a CL, sort of like 
OPNQRYF without the "drunken rage". 

JMHO, 

Jerome
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---