IBM Mainframe Forum

by **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.

Select all

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 ?

by **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.

by **pacha** » Fri Aug 06, 2010 10:33 am

That was a typo.

. I meant DTLCTL.
Thank you dick scherrer.

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

Hello,

I see no reference to duplicates in the material about DTLCTL. . .

by **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.

IBM Mainframe Forum

Removing duplicates in Easytrive Report

Removing duplicates in Easytrive Report

Re: Removing duplicates in Easytrive Report

Re: Removing duplicates in Easytrive Report

Re: Removing duplicates in Easytrive Report

Re: Removing duplicates in Easytrive Report