Re: Passing parameters to a query

[mcrump@xxxxxxxxxxxxxx]

Pretty simple really.  Here is a simple example of what I use:

1.) CL statement
 RUNQRY     QRY(LIBR/File) QRYFILE((*SAME)) +
              RCDSLT(*YES)
The only key being the RCDSLT(*YES)....

2.) In the query I will usually dummy-up the record selection in a manner
like this:

                                 Select Records



 Type comparisons, press Enter.  Specify OR to start each new group.

   Tests:  EQ, NE, LE, GE, LT, GT, RANGE, LIST, LIKE, IS, ISNOT...



 AND/OR  Field             Test   Value (Field, Number, 'Characters', or
...)
                EASSNO            EQ     'xxxxxxxxx'

  AND    EAPPYR            LE     'xx'

  AND    EAPPYR            GE     'xx'

HTH

Michael Crump
Technical Project Leader
Ball-Foster Glass Container Corp.



Can someone show me or direct me on how to run a query through a CL that
will prompt the user to enter values(selection) and use the entered values
to complete the query.
Thanks








+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@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
+---