Obtaining Character Count in a dataset



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

Obtaining Character Count in a dataset

Postby RajeshT » Tue Dec 06, 2011 9:58 pm

Hi Everyone !!

I've searched through the forum and syncsort manual before putting forward this question. I'm trying to obtain the CHARACTER COUNT from a dataset. I'm able to retrieve the RECORD COUNT using the COUNT, SUBCOUNT (COUNT15, SUBCOUNT15) functions but not exactly the character count. I also did a math manually by multiplying the no.of records with the REC SIZE and then by eliminating the no.of SPACES in the file. But i want this function be implemented automatically without manual intervention. Can you help me finding a way obtaining the no.of characters in a dataset (No.of character - total no.of SPACES).

Thank you.
Rajesh.
RajeshT
 
Posts: 22
Joined: Tue May 04, 2010 10:19 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Obtaining Character Count in a dataset

 

Re: Obtaining Character Count in a dataset

Postby dick scherrer » Wed Dec 07, 2011 11:34 am

Hello,

Why should embedded spaces be removed fro mthe count?

Once you have this "byte count", how might it be used? I.E. to support what business requirement.

If we understood why this might be useful, we might be able think of a suggestion.
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: Obtaining Character Count in a dataset

Postby RajeshT » Wed Jan 04, 2012 10:57 pm

Hi Dick,

We transmit data to internal and external interfaces of our customer. And also sends the statistics to a VAN and our customer has to pay the amount based on no.of characters to the VAN provider. Off late we've made a change to not to use the VAN facility for a couple of high volume vendors. So customer wanted to cross-verify the statistics of being the high volume vendors converted to a Non-VAN network, to see if that is a reliable option.

Thank you.
Rajesh.
RajeshT
 
Posts: 22
Joined: Tue May 04, 2010 10:19 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Obtaining Character Count in a dataset

Postby Akatsukami » Wed Jan 04, 2012 11:18 pm

If your data set is small ("small" being a fuzzy term, but somewhere between a thousand and a lakh records), you can use Rexx; for larger data sets, I'd recommend a compiled language.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1054
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: Obtaining Character Count in a dataset

Postby enrico-sorichetti » Wed Jan 04, 2012 11:34 pm

just curious, what makes You think that <blanks> should not behave/considered like the other characters ?

from whatever point of view the IT char count of "ABC" and "A C" is the same,
the blank in the second string is crucial to the information as much as the B in the first string
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2648
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 132 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post