Passing values to Query/400 queries -Reply

[John Cirocco <JCirocco@xxxxxxxxxx>]

This is a forward of a similar response from Vernon, which is more like
what (I think) you are asking for.

>>> Vernon Hamberg <hambergv@goldengate.net> 04/28/98 07:19pm
>>>
Do I remember someone asking about sending variable data to Query/400
queries? I just read something in Query Management Programming that
offers
a way to do this.

What you do is use a special syntax in the record selection part. This
syntax is like the following:

    :t01.varname

You cannot run these so-called dependent queries (they're designed for
merging in OfficeVision) with RUNQRY, but you *can* with STRQMQRY
ALWQRYDFN(*ONLY). With this command you can send variable data to
the
query, using the VAR parameter of STRQMQRY. The variable name to
use that
corresponds to the above is

    t01_varname

You may need an ampersand (&) in front of the name. The VAR
parameter is a
list of name-value pairs.

Details are in the manual, chapter 11.

Query Management is way cool, and it's native. It's the basis for all these
command line SQL processors out there (Midrange Computing has one).
It has
form-definition capability that has features not available in Query/400
(the reverse is also true). E.g., up to 999 lines in page & break
headings/footings, 9 lines in column headings. The syntax for these
forms
is ugly at best, so if you can swing it, get the SQL licensed product,
which includes Query Manager, a Query/400 look-alike front end for QM.

Cheers

Vernon Hamberg
Systems Software Programmer
Old Republic National Title Insurance Company
400 Second Avenue South
Minneapolis, MN  55401-2499
(612) 371-1111 x480


+---
| 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
+---
+---
| 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
+---