MVSFORUMS.com

ldushkin · Beginner Joined: 05 Apr 2006 Posts: 56 Topics: 20

Need help in the sort.

We have input flat file and we need count all records and eliminate duplicate.

input:

kolusu · Posted: Sat Apr 08, 2006 8:02 am Post subject:

ldushkin,

Counting records and eliminating duplicates is very easy however in your output you showed the detailed records arranged horizontally instead of vertically

ldushkin · Beginner Joined: 05 Apr 2006 Posts: 56 Topics: 20

Thanks a lot for your quick response. Yes I need 3 or 4 horizontal records.

It should be like this

AAAAAAHEADER 052006

H0540 H0564 H5419
H5422 R9943 S5960

TOTAL RECORDS: 959

Also I need, if it possible, name of input DSN. Because this report will be copy to Exel

file-name count-records number
input file 959 H0540, H0564, H5419,
H5422, R9943, S5960

I appreciate all your help
Lenny

kolusu · Posted: Mon Apr 10, 2006 7:49 am Post subject:

ldushkin,

Sort products do not have the ability to print the filename. you will need atleast 3 passes to acheive the desired results.

To get 1 header and count of the records you can use the following sysin cards.