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