Hi,
I have to read a sequential file with some fields and the output should contain the frequency of occurence of values in one of the fields.
For eg. lets assume file has 3 fields A,B and C.
the sample data is
A B C
e t g
e w p
r u g
s t p
Now the output file should have :
C Count
g 2
p 2
How this can be achieved in PX without any sql (since the input is a sequential file)
Thanx,
Chits
Frequency of a record in a sequential file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 12
- Joined: Mon Jul 18, 2005 4:07 am
-
- Participant
- Posts: 12
- Joined: Mon Jul 18, 2005 4:07 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Currently there are no manuals available for download.
This may change now that IBM has acquired the products, as their model includes publishing manuals on a web site.
But not yet.
This may change now that IBM has acquired the products, as their model includes publishing manuals on a web site.
But not yet.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.