RE: Query Variables

Thanks Vern, I was hoping there would be a simpler way .. oh well, whatever
gets the job done!

-----Original Message-----
From: Vern Hamberg [mailto:vhamberg@centerfieldtechnology.com]
Sent: Wednesday, January 08, 2003 12:46 PM
To: Midrange Systems Technical Discussion
Subject: Re: Query Variables


Howard, I've often thought this should be possible, but I think there's no 
way to do this in a CL program. But one way might be to DCLF an output file 
for the STRQMQRY, then RCVF after the STRQMQRY OUTPUT(*OUTFILE) is done.

At 11:12 AM 1/8/2003 -0500, you wrote:
>Folks, how can I return the answer from a QMQRY to a CL program? For
>instance: in the CL  I do
>
>STRQMQRY   QMQRY(HGR0093/CARDINALITY) SETVAR((VAR1 &VAR1) +
>              (VAR2 &VAR2) (VAR3 &VAR3))
>
>VAR1 contains the collection name VAR2 contains the table name
>
>the Query is to be Select COUNT(*) from &VAR1.&VAR2 into :&VAR3
>
>so is this possible? or do I need to use the SET GLOBAL &VAR3 = (equal to
>what?)
>
>and, if it can be set, is the value of VAR3 available to the CL program?
>_________________________________________
>     Howard   Weatherly
>       Systems Advisor
>Computer Task Group, Inc.
>
>howard.weatherly@dlis.dla.mil
>howard_weatherly@ameritch.net
>Howard.Weatherly@ctg.com


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.