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

amazon.com ads help fund midrange.com operations

This thread ...


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