Re: AW: how to use sql distinct in CL?

[CRPence <CRPbottle@xxxxxxxxx>]

On 02 Jul 2013 23:58, Birgitta Hauser wrote:
> If you can execute RUNSQL, I'd neither use Query/400 nor QMQRY.

  RUNSQL has its place, but there is no report writer with that command.

> Even though SELECT is not supported, it is possible to create a
> (temporary) SQL VIEW representing the result of an SELECT statement.
> This view can be registered with the DCLF command and read with the
> RCVF command. The only downside is, the sequence of rows returned by
> the view cannot be predefined.

  Yet the OPNQRYF can effect ordering in an ODP that is shared with the 
RCVF.

> If the records must be returned in a specific sequence, creating a
> temporary table based on a SELECT statement with an ORDER BY clause
> and reading this temporary table may be an option.

  And using a shared query ODP means that no temporary table is required.