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

[Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>]

actually we are not yet on 7.1 Sorry I will mention this in the future.
BUt going to the QMQRY sounds like a good idea  !!!


On Wed, Jul 3, 2013 at 7:34 AM, Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>wrote:

> 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
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.