Re: SQL break ?

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Assuming you are using STRSQL or iNav's "Run SQL Scripts"...you can't.
 They both return raw results sets.

Suppressing the column's value or otherwise prettying up the values is a
function of the consumer of an SQL result set.

If you use an actual SQL based reporting tool, the reporting side of it
will support what you are asking for.

For example, using Query Manager (STRQM).  When you build your QMFORM you
can specify BREAK1 for a usage and query manager will output something like
so:

DTNM                                 REPORT SET NAME  REPORT NAME
 ALEX KAPILF                          ALLITARB4      ALLITARB4
 ANDREW LAJR                          C34TIPPFZ2     C34TIPPFZ2
                                      X12CVMSF       X12CVMSF
 ANN MCKE                             P08RATRF       P08RATRF
                                      C36TIPPF       C36TIPPF
                                      D75LEINF       D75LEINF
                                      P88MAILF       P88MAILF
                                      QSYSPRTX       QSYSPRTX
                                      X24RCVMF       X24RCVMF
                                      P09DUPLF       P09DUPLF
 ANNE MULDEG                          C01CAXF        C01CAXF
                                      C01DETF        C01DETF
                                      C03EMPLF       C03EMPLF
                                      C12EMPLF       C12EMPLF
                                      C17LOSSF       C17LOSSF
                                      C23CLEXF       C23CLEXF
                                      C23CLSSF       C23CLSSF
                                      C25NODTF       C25NODTF
                                      C35TIPPF       C35TIPPF


Or you can get a little fancier...
  REPORT SET NAME  REPORT NAME
 ALEX KAPILF
   ALLITARB4      ALLITARB4
 ANDREW LAJR
   C34TIPPFZ2     C34TIPPFZ2
   X12CVMSF       X12CVMSF
 ANN MCKE
   P08RATRF       P08RATRF
   C36TIPPF       C36TIPPF
   D75LEINF       D75LEINF
   P88MAILF       P88MAILF
   QSYSPRTX       QSYSPRTX
   X24RCVMF       X24RCVMF
   P09DUPLF       P09DUPLF
 ANNE MULDEG
   C01CAXF        C01CAXF
   C01DETF        C01DETF
   C03EMPLF       C03EMPLF
   C12EMPLF       C12EMPLF
   C17LOSSF       C17LOSSF
   C23CLEXF       C23CLEXF
   C23CLSSF       C23CLSSF
   C25NODTF       C25NODTF
   C35TIPPF       C35TIPPF


On Fri, Mar 15, 2013 at 3:54 PM, Matt Olson <Matt.Olson@xxxxxxxx> wrote:

> Add a group by.
>
> SELECT RDDTNM, RDRSET, RDRPTN FROM REPRD
> GROUP BY RDDTNM,RDRSET,RDRPTN
> ORDER BY rddtnm
>
> -----Original Message-----
> From: fbocch2595@xxxxxxx [mailto:fbocch2595@xxxxxxx]
> Sent: Friday, March 15, 2013 2:40 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: SQL break ?
>
>
> Hi Folks, when I run this statement;
>
> SELECT RDDTNM, RDRSET, RDRPTN FROM REPRD ORDER BY rddtnm        I get the
> screen below but how can I remove the duplicate names and only show one
> name for every report set?  I know it's doable with wrkqry but I'd like to
> use SQL.
>
> Thanks, Frank
>
>  DTNM                                 REPORT SET NAME  REPORT NAME
>  ALEX KAPILF                          ALLITARB4      ALLITARB4
>  ANDREW LAJR                          C34TIPPFZ2     C34TIPPFZ2
>  ANDREW LAJR                          X12CVMSF       X12CVMSF
>  ANN MCKE                             P08RATRF       P08RATRF
>  ANN MCKE                             C36TIPPF       C36TIPPF
>  ANN MCKE                             D75LEINF       D75LEINF
>  ANN MCKE                             P88MAILF       P88MAILF
>  ANN MCKE                             QSYSPRTX       QSYSPRTX
>  ANN MCKE                             X24RCVMF       X24RCVMF
>  ANN MCKE                             P09DUPLF       P09DUPLF
>  ANNE MULDEG                          C01CAXF        C01CAXF
>  ANNE MULDEG                          C01DETF        C01DETF
>  ANNE MULDEG                          C03EMPLF       C03EMPLF
>  ANNE MULDEG                          C12EMPLF       C12EMPLF
>  ANNE MULDEG                          C17LOSSF       C17LOSSF
>  ANNE MULDEG                          C23CLEXF       C23CLEXF
>  ANNE MULDEG                          C23CLSSF       C23CLSSF
>  ANNE MULDEG                          C25NODTF       C25NODTF
>  ANNE MULDEG                          C35TIPPF       C35TIPPF
>
>
>
> --
> 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.
>
> --
> 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.