Re: Select distinct

[pedro.reis@xxxxxxxxx]

It´s like i´m doing right now , but there is no other way to perform that?




Best regards,
-------------------------------------------------------------------
Pedro Reis
e-mail: pedro.reis@valeo.com
Phone: 351-258 350 725
--------------------------------------------------------------------
VALEO - Electronics & Connective Systems
Viana do Castelo - Portugal
--------------------------------------------------------------------



                    MWalter@hanoverwi
                    re.com                   Para:   rpg400-l@midrange.com
                    Enviada por:             cc:
                    rpg400-l-admin@mi        Assunto:     Re: Select distinct
                    drange.com


                     07/02/2002 18:33
                          Solicita-se
                           resposta a
                             rpg400-l







You could select only the fields you wish to view, then break on that field
and select the Form of Output as 2 (summary only)




Mark


Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@hanoverwire.com
http://www.hanoverwire.com
717.637.3795 Ext.3040



                    pedro.reis@valeo.
                    com                      To:     rpg400-l@midrange.com
                    Sent by:                 cc:
                    rpg400-l-admin@mi        Subject:     Select distinct
                    drange.com


                    02/07/02 12:17 PM
                    Please respond to
                    rpg400-l






Hello to all,

It is possible to execute a select distinct operation on the wrkqry
aplication, like we do on SQL  (select distinct * from.....)´

Thanks



Best regards,
-------------------------------------------------------------------
Pedro Reis
e-mail: pedro.reis@valeo.com
Phone: 351-258 350 725
--------------------------------------------------------------------
VALEO - Electronics & Connective Systems
Viana do Castelo - Portugal
--------------------------------------------------------------------
"This e-mail message is intended only for the use of the named
recipient(s).
The information contained therein may be confidential or privileged, and
its
disclosure or reproduction is strictly prohibited. If you are not the named
recipient, please return it immediately to its sender at the above address
and destroy it."

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.





_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.




"This e-mail message is intended only for the use of the named
recipient(s).
The information contained therein may be confidential or privileged, and
its
disclosure or reproduction is strictly prohibited. If you are not the named
recipient, please return it immediately to its sender at the above address
and destroy it."