Page 1 of 1

How to Create frequency report in SYNCSORT/

PostPosted: Sun Jul 17, 2011 10:10 am
by pjagathis
Hi,

How to create frequncy report in Syncsort?

Re: How to Create frequency report in SYNCSORT/

PostPosted: Sun Jul 17, 2011 10:49 am
by dick scherrer
Hello,

Do you honestly hope for an answer. . . . :(

What is a frequency report - to you?

What do you intend to use as input (show sample input data)? What do you want as output (again, show the output you want from the sample input).

Mention the recfm and lrecl of all files.

There may be more info you need to provide but until you post what you are talking about, we won't know. . .

Re: How to Create frequency report in SYNCSORT/

PostPosted: Wed Aug 03, 2011 3:04 pm
by pjagathis
Hi dick,

My input file will have more fields say 5...

I want to calculate the number of records present in the file based on each fields with header information

Input file:

LRECL=20 byte

No. of fields=5

Each field size=4 byte

2222 1111 7777 UUUU KKKK
AAAA OOOO FFFF JJJJ BBBB
VVVV CCCC EEEE RRRF 5555
AAAA OOOO EEEE JJJJ KKKK
2222 2222 2222 2222 2222


My output should be as follows..

Field1 should be calculated on based on first 2 bytes of total 4 bytes..

Field1:
22   2
AA   2
VV    1


Field2 should be calculated based on 4 bytes of total 4 bytes
Field2
1111  1
OOOO 2
CCCC   1
2222  1


and so on for all fields

No of records in each fields should be calculated based on given length..

Please help me..

Thanx in advance...