MVSFORUMS.com

chandra_vssv · Posted: Thu Mar 09, 2006 8:52 am Post subject: How to count duplicate records

Hi,

I have inputfile of rec length of 80.I have to count the total number of records as well as number of duplicate records.Could anybody please provide a solution either in syncsort or cobol program.

Input file:

kolusu · Posted: Thu Mar 09, 2006 9:14 am Post subject:

chandra_vssv,

Try this job

ynb · Beginner Joined: 09 Mar 2006 Posts: 1 Topics: 0

Hi,

In additon to the below query posed. I have a necessity to sum up the amounts of all duplicate records along with its occurences.Can anyone please provide me a solution.

Input file:
======
CODE1 200.0
CODE1 100.0
CODE1 300.0
CODE2 200.0
CODE3 100.0
CODE3 400.0
CODE3 200.0

Outputfile:
=======
CODE1 3 600.0
CODE2 1 200.0
CODE3 3 700.0
TOTAL 7
_________________
Thanks,
Basha

kolusu · Posted: Thu Mar 09, 2006 10:29 am Post subject:

ynb,

Try this

hikernh · Posted: Tue Apr 04, 2006 10:24 am Post subject:

what does removecc and nodetail mean. im trying to understand how that sort works exactly to perform the task.

kolusu · Posted: Tue Apr 04, 2006 10:47 am Post subject:

Hikernh,

REMOVECC can be used to remove the ANSI control characters from a report.For ex: if you have 80 byte FB input dataset and when you use reporting features like header/trailer1, then sort automatically will create the output dataset with FBA and the LRECL would be 81. The extra 1 byte is for the ansi control character which is at the 1st byte.

Removecc suprress the creation of carriage control chararacter. So using it will make both the input and output have the same DCB parameters when you are using reporting features.

NODETAIL is used to Specify that data records are not to be written out for the reports produced for this OUTFIL group. With NODETAIL, the data records are completely processed with respect to input fields, statistics, counts, sections breaks, and so on, but are not written to the OUTFIL data set and are not included in line counts for determining the end of a page. You can use NODETAIL to summarize the data records without actually showing them

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

pzmohanty · Posted: Thu Apr 06, 2006 12:03 pm Post subject:

hi hikernh,

here is another way of achieving the same goal.

kolusu · Posted: Thu Apr 06, 2006 12:08 pm Post subject:

pzMohanty,

What happens if you have more than 10 duplicates per key? ex: run your job with this sample data

pzmohanty · Posted: Thu Apr 06, 2006 12:32 pm Post subject:

Hi Kolusu,

Yeah , I got your point .

Now , I clearly understood why it is preferable to use TRAILER option instead of SUM FIELDS.

Thanks a lot
_________________
Priya Ranjan Mohanty
Consultant
Kanbay Software (I) pvt. Ltd.
Hyderabad

surendar · Posted: Fri Apr 14, 2006 5:13 am Post subject: SUM of Duplicate fields

Hi,

TRAILER3=(1,5,2X,COUNT,TOT=(7,4,ZD,EDIT=(IIIIIIIT.T)))),
TRAILER1=(C'TOTAL :',COUNT,TOT=(7,4,ZD,EDIT=(IIIIIIIT.T)))

Can u guys please let me know How exactly this works ( An Overview)
Am bit confussed.
Whatz d difference in using SUMFILEDS and TRAILER option
Whatz iiiii.t??

Surendar Shocked

kolusu · Posted: Fri Apr 14, 2006 5:34 am Post subject:

surendar,

Check this link to "z/OS DFSORT Application Programming Guide" which explains in detail about the trailer parm on OUTFIL

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA10/3.13?DT=20050222160456

surendar · Posted: Sun Apr 16, 2006 1:45 am Post subject:

Thanks Kolusu... Laughing