Re(2): Call Query

["Mike Naughton" <mnaughton@xxxxxxxxxxxx>]

I believe to make this work you need the SQL SDK licensed product (not
sure of the exact name), which costs $$ (not huge, but not free).

If that's not an option, perhaps this will work:

1) convert your standard query to a qmquery (you can do this without the
SDK)
2) use the result to help you design an OPNQRYF statement that does the
same thing
3) write a CLP or RPG program to construct this statement and run it (you
can pass information into this program that will then be included in the
statement)
4a) write a simple report program over the result.
-OR-
4b) ?? run a query (RUNQRY) over the result (no need for passed parms) ??

4b is obviously easier, but I'm not sure it would work -- it depends on if
the query would run over the product of the OPNQRYF statement or whether
it would go back to the original file. OTOH, I think you can use OPNQRYF
to produce a "real" output file, so then you could just run a query over
that. . . .

hth

RPG400-L@midrange.com writes:
>Check the midrange-l archives for qmquery.
>Convert your standard query to a qmquery and you can pass parameters.


Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444
mnaughton@juddwire.com


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