RE: Query Variables

["Weatherly, Howard (Contractor) (DLIS)" <Howard.Weatherly@xxxxxxxxxxxx>]

Hi Carel, actually I choose a different route since I had the code I needed
elsewhere in a COBOL program, I just pass the lib/file and an empty variable
to populated by COBOL then get it back into the CL and send it on to the
Query that updates the row with the values. So I guess the contents of the
Query are now a dynamic procedure.

-----Original Message-----
From: Carel Teijgeler [mailto:coteijgeler@chello.nl]
Sent: Wednesday, January 08, 2003 1:49 PM
To: midrange-l@midrange.com
Subject: Re: Query Variables


Howard,

the only solution is to place the output in a file and use that.

Regards,
Carel Teijgeler.

*********** REPLY SEPARATOR  ***********

On 8-1-03 at 11:12 Weatherly, Howard (Contractor) (DLIS) 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? 


_______________________________________________
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.