|
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 "Many things in life will capture the eye: But the wise will pursue only the things that capture the heart"
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.