Removing duplicates in Easytrive Report



Unicenter CA-Easytrieve Plus Report Generator: CA's information retrieval and data management tool

Removing duplicates in Easytrive Report

Postby pacha » Thu Aug 05, 2010 5:35 pm

Hi,
I have created a report using easytrieve. The fields in my report are PRODUCT-ID, PRODUCT-NAME and VENDOR-ID. But duplicate records are coming in the report.
                                             PRODUCT REPORT
PRODUCT-ID        PRODUCT-NAME            VENDOR-ID     
10                        PEN                             ABC
10                        PEN                             ABC
20                        PENCIL                        DEF
30                        BOOK                          ABC
30                        BOOK                          ABC


Is it possible to remove the duplicates using any REPORT Keywords like DTCTL?
(I am able to remove the duplicates by using SORT statement in Easytrieve and comparing with previous record)

Could someone please help me out ?
pacha
 
Posts: 10
Joined: Sun Mar 21, 2010 10:27 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Removing duplicates in Easytrive Report

Postby dick scherrer » Thu Aug 05, 2010 11:54 pm

Hello,

What is the origin of DTCTL - it does not appear to be any part of Easytrieve. . .

The normal way to eliminate duplicates is to compare and discard duplicate entries.

You might also use CONTROL for accumulating totals if needed.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6269
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Removing duplicates in Easytrive Report

Postby pacha » Fri Aug 06, 2010 10:33 am

That was a typo. :) . I meant DTLCTL.
Thank you dick scherrer.
pacha
 
Posts: 10
Joined: Sun Mar 21, 2010 10:27 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Removing duplicates in Easytrive Report

Postby dick scherrer » Sat Aug 07, 2010 12:52 am

Hello,

I see no reference to duplicates in the material about DTLCTL. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6269
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Removing duplicates in Easytrive Report

Postby Scott Lippincott » Fri Oct 15, 2010 8:56 am

Code the report like this:
REPORT RPTNAME SUMMARY SUMCTL DTLCOPY
...
SEQUENCE PRODUCT-ID PRODUCT-NAME VENDOR-ID
CONTROL PRODUCT-ID PRODUCT-NAME VENDOR-ID
LINE PRODUCT-ID PRODUCT-NAME VENDOR-ID TALLY

I added the TALLY to the LINE to show the number of duplicates; it can be left off.
Scott Lippincott
 
Posts: 5
Joined: Wed Jul 28, 2010 7:30 am
Has thanked: 0 time
Been thanked: 0 time


Return to CA-Easytrieve

 


  • Related topics
    Replies
    Views
    Last post