MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » June 2014

Re: how to use the Select Distinct



fixed

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