RE: QUERY

[Jim Suiter <jsuiter@xxxxxxxxxxxxxx>]

>  Hello  all,
>                          Could any one please help on this problem.
>
>Its a  simple  query  report .   By  joining  two  files and  selecting
>specific  fields from  both  file
>
>FILE  1
>FILE  2     both   Joined by   OBJECT NAME.
>
>We generate   a   report    with   OBJECT NAME             OBJECT  TYPE
>OBJ  LIB        TEXT  DESC         FLAG
>
>
>PROBLEM :    We are getting  two  detail lines  whenever   there are two
>records for the same  object on the FILE1.
>
>
>What we want  to do?.     We want  to  elliminate  the second record
>with
>same informatiion.
>
>
>I can able to handle this by  outputing into a datafile, and  write an
>RPG
>program to make the report perfect.
>
>
>But is there any way   in  Query/400   or  SQL/400  or  SEQUEL, I can
>handle this problem.?
>
>Any help is greatly appreciated.
>
>
>Thanks
>
>Raj

you could use query to create a file based on File 1 that has only one
record per object name.  Sort on object name.  If all the other fields are
identical for both records then put a 1 beside all the fields in the Report
Breaks section.  Then in the output specifications, specify that you want
the output to be a database file and that you want summary only output.  The
file created by this query would be used in the file specs of your original
in place of File 1.

Jim


>
>
>
>
>
>
>
>+---
>| This is the Midrange System Mailing List!
>| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
>| To unsubscribe from this list send email to
>MIDRANGE-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator:
>david@midrange.com
>+---
>+---
>| This is the Midrange System Mailing List!
>| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
>| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator: david@midrange.com
>+---
>

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---