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

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Good point - QMFORMs are marvelous creatures! STRQM is about the only 
way I want to work with them. Just try RTVQMFORM over an existing 
*QRYDFN and see the results - source file needs to be 162 long, BTW. The 
source for QMFORMs is at least nasty!

There are some really nice capablities with QMFORMs - some formatting 
options (word wrap in a column, e.g.), more flexibility than Query/400 
queries. And if the report is wider than your printer file, it doesn't 
just truncate, as Query/400 does, it creates multiple sets, so all data 
is available - a bit ugly, but there, nonetheless.
On 7/3/2013 6:22 AM, rob@xxxxxxxxx wrote:
> I never played around with customizing forms in qmqry (aka Query
> Management).  Which may be a decision maker in qmqry vs QSH DB2 for
> displaying results.
>
>
> Rob Berendt
> -- IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 
> 1600 Mail to: 2505 Dekko Drive Garrett, IN 46738 Ship to: Dock 108 
> 6928N 400E Kendallville, IN 46755 http://www.dekko.com From: Vernon 
> Hamberg <vhamberg@xxxxxxxxxxxxxxx> To: Midrange Systems Technical 
> Discussion <midrange-l@xxxxxxxxxxxx>, Date: 07/03/2013 07:16 AM 
> Subject: Re: AW: how to use sql distinct in CL? Sent by: 
> midrange-l-bounces@xxxxxxxxxxxx Yes, as I said in my post, if one 
> wants a table, use RUNSQL or RUNSQLSTM (before 7.1, if you don't have 
> RUNSQL). If the goal is to _display_ the results, QMQRY is the easiest 
> way, or maybe the QShell db2 function. I don't know if the db2 
> function allows SELECT. Vern