How to Create frequency report in SYNCSORT/



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

How to Create frequency report in SYNCSORT/

Postby pjagathis » Sun Jul 17, 2011 10:10 am

Hi,

How to create frequncy report in Syncsort?
Thanks and Regards,
Jagathis P
pjagathis
 
Posts: 67
Joined: Wed May 04, 2011 5:04 pm
Location: Chennai
Has thanked: 0 time
Been thanked: 0 time

Re: How to Create frequency report in SYNCSORT/

 

Re: How to Create frequency report in SYNCSORT/

Postby dick scherrer » Sun Jul 17, 2011 10:49 am

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. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: How to Create frequency report in SYNCSORT/

Postby pjagathis » Wed Aug 03, 2011 3:04 pm

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...
Thanks and Regards,
Jagathis P
pjagathis
 
Posts: 67
Joined: Wed May 04, 2011 5:04 pm
Location: Chennai
Has thanked: 0 time
Been thanked: 0 time


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post