A sequential file contains States and districts from that

sxv8193 · New User Joined: 25 Jun 2007 Posts: 5 Location: pune

how to find out only the number distrcits.

Thanks
sunny

sandeep1dimri · New User Joined: 30 Oct 2006 Posts: 76

Hi

As i understood from ur requirement u need to find out the number of distinct districts from a sequestional file. U can use sort to eliminate the duplicates and then feed this(out put of sort utility) file into cobol program to do further processing.

Please put more details if i went wrong on the your requirement

Sandeep

sxv8193 · New User Joined: 25 Jun 2007 Posts: 5 Location: pune

Hi,

By doing sort we can arrange the districts in sorted way only but i want number of districts are there in the sequential file.i hope you understand my requirement

Thanks
sunny

sandeep1dimri · New User Joined: 30 Oct 2006 Posts: 76

Hi

We can also eliminate the duplicates using sort by using

//SORTIN dd dsn=input file
SORTOUT DD DSN=
SORTXSUM dd dsn=

insysin
please provide below
SORT FIELDS=(ur district filed length) like (1,10,CH,A)
(i considered it from 1 of length 10)
SUM FIELDS=NONE,XSUM

so the file SORTXSUM will have distinct districts

if u just need the number u can also use file-aid with TALLY option

for more queries u can put search in JCL or SORT forum

thanks

sxv8193 · New User Joined: 25 Jun 2007 Posts: 5 Location: pune

Hi

i hope the answer u provided would work properly.
Thanks for your answer.

Thanks
Suneel