Re: how to use the Select Distinct

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