MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » June 2014

Re: how to use the Select Distinct



fixed

Chuck, another question for me is, does this person want to read the results in CL? I do know this guy is a 400 person, so I can * will make some assumptions.

Others who ask this kind fo thing in the past want to use OPNQRYF to do the same as select distinct fields from file

SOme have suggested using OPNQRYF is possible, I think, thoug, that it would require that all the fields be the key - you know OQF better than I.

Otherwise, one would have to get Bruce'Vinings product to make this work - I don't about anything to allow direct reads of query output in CL.

Vern

On 6/1/2014 7:06 PM, CRPence wrote:
On 01-Jun-2014 18:02 -0500, Hoteltravelfundotcom wrote:
Can u show me how to use Selecting distinct records in a CL?

I suppose u could do that, whoever u is; maybe you could ask u in a direct email instead of a public forum of IBM i professionals ;-)

Otherwise, probably best to tell the reader what is the definition of each of 'selecting', 'distinct', and 'in a CL', instead of depending on them to intuit your intentions. As a "Control Language", probably the easiest would be to invoke a program to perform exactly whatever is desired; for example, if the data /records/ are in a database file, then perhaps invoking one of STRQMQRY, RUNSQL, QSH CMD('DB2 ...'), RUNQRY, RCVF, OPNQRYF, or etc..







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact