OPNQRY reference book

[D.BALE@xxxxxxxxxxxxx]

Yes, I'm sure both of the major aS/400 trade rags have had comprehensive
articles on OPNQRYF, which, IMO, is one of OS/400's jewels.  An extremely
flexible and powerful command.  Check out AS400Network.com and
MidrangeComputing.com and search their article indexes for OPNQRYF.

Here's my take on the single quotes / double quotes issue you raised.  I
*ALWAYS* use double quotes to surround character data.  Which is easier to
read - #1 or #2?:

#1: QRYSLT(' OHSTS *EQ %VALUES( '''A''' '''I''' '''C''' ) ')
#2: QRYSLT(' OHSTS *EQ %VALUES( "A" "I" "C" ) ')

Another thing, if I'm dealing with CL varibles in the QRYSLT, I always use
QRYSLT( &QRYSLT ) and build the QRYSLT string in the variable beforehand.
Since its been at least 10 years I've been using this method, I forget exactly
the problem that it solves, but I seem to recall that numeric CL variables are
a real PITA to deal with in QRYSLT.

Dan Bale
IT - AS/400
Handleman Company
248-362-4400  Ext. 4952

-------------------------- Original Message --------------------------
Hi Folks,

Although I have been using OPNQRY command from last 7 years, and am very
 comfortable with
it. But still some times while selecting records face problem with single
 quote and
double quote. Does any body know how can I get complete information about
 OPNQRY command.
How to use it, with example and brief elaboration.


Thanks and Regards

Ahmed Hussain
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---