MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

EDCOUNT Formatting in ICETOOL

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities
View previous topic :: View next topic  
Author Message
misi01
Advanced


Joined: 02 Dec 2002
Posts: 629
Topics: 176
Location: Stockholm, Sweden

PostPosted: Tue Nov 04, 2014 4:30 am    Post subject: EDCOUNT Formatting in ICETOOL Reply with quote

I found the following example online (the first COUNT is my attempt at changing the formatting of the results)
Code:

//TOOLIN DD *                                                     
   COUNT FROM(IN1) WRITE(OUT) TEXT('Count of file Q591301 is ') -
          EDCOUNT(E'III III III') WIDTH(80)                       
   COUNT FROM(IN2) WRITE(OUT) TEXT('Count of file Q599802 is ') -
          EDCOUNT(A1,U10) WIDTH(80)                               
/*                                                               


What I'm trying to do is specify the mask such that I can define "too many" characters but any leading zeroes will be blank instead. My results looked like this
Quote:

COUNT OF FILE Q591301 IS 029 675 267
COUNT OF FILE Q599802 IS 29,675,274

I would like to present the results as in the first line, but without the leading zero. I get the impression it can be done, but not how.
_________________
Michael
Back to top
View user's profile Send private message Send e-mail
William Collins
Supermod


Joined: 03 Jun 2012
Posts: 437
Topics: 0

PostPosted: Tue Nov 04, 2014 7:30 am    Post subject: Reply with quote

Did you try A3 in place of A1?
Back to top
View user's profile Send private message
misi01
Advanced


Joined: 02 Dec 2002
Posts: 629
Topics: 176
Location: Stockholm, Sweden

PostPosted: Tue Nov 04, 2014 7:43 am    Post subject: Reply with quote

Thanks William, that was what I was after.

I googled EDCOUNT A1 (hoping to find examples of other formatting options, such as A3) but can't seem to find anything.

Where can I find the various An formatting options?
_________________
Michael
Back to top
View user's profile Send private message Send e-mail
William Collins
Supermod


Joined: 03 Jun 2012
Posts: 437
Topics: 0

PostPosted: Tue Nov 04, 2014 8:04 am    Post subject: Reply with quote

In the ICETOOL chapter in the Application Programming Guide, they are listed in a table under the DISPLAY operator, with a reference to that in the documentation of the COUNT operator where it discusses EDCOUNT. There are more options than An as well, but they are not to be confused with the edit masks available for SORT (a separate table, with separate values).
Back to top
View user's profile Send private message
misi01
Advanced


Joined: 02 Dec 2002
Posts: 629
Topics: 176
Location: Stockholm, Sweden

PostPosted: Tue Nov 04, 2014 8:48 am    Post subject: Reply with quote

Thanks William, found it
_________________
Michael
Back to top
View user's profile Send private message Send e-mail
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12382
Topics: 75
Location: San Jose

PostPosted: Tue Nov 04, 2014 11:14 am    Post subject: Reply with quote

misi01 wrote:
I googled EDCOUNT A1 (hoping to find examples of other formatting options, such as A3) but can't seem to find anything.

Where can I find the various An formatting options?


Misi01,

I am not sure as to why you always chose the long route to get the desired results. You know the keyword you are looking for and if you picked the "DFSORT Application Programming Guide" and searched for "EDCOUNT", you would have found detailed explanation along with examples.

Something like this EDCOUNT(formatting)

For any DFSORT related questions I suggest that you start with "DFSORT Application Programming Guide" and if you have an error then check out "DFSORT Messages, Codes and Diagnosis Guide".
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
misi01
Advanced


Joined: 02 Dec 2002
Posts: 629
Topics: 176
Location: Stockholm, Sweden

PostPosted: Tue Nov 04, 2014 12:35 pm    Post subject: Reply with quote

Kolusu
Quote:
choosing the long route


I did indeed find and read that reference.I suggest you try and remember back when you first started driving a car, how uncertain you were, how easily you got rattled. Now fast forward to today. If you see a learner driver who hesitates, makes a mistake or similar, do you immediately hang on the horn, or do you remember what it was like for you and show a little patience instead? Same with the multitude of sort parameters. They can be combined in LOADS of combinations.

As I've mentioned before, I use NEW variations, maybe once a month. It's shouldn't be surprising that I have difficulties in getting the JCL/parms correct.

My appends are intended to try and show that I DO try to do some homework rather than expecting to be force fed the answer.

Going back to the reference you linked to. To my (inexperienced) eye, it doesn't exactly shout out that the A1, A3 masks would do what I wanted, but maybe that's just me.

Lastly, reading the link, I tried the following (which seemed logical to me based on what I read)
Code:

edcount(E'99 999 999')


Since all I got was rc 16 with nothing obvious as to what was wrong, then I decided to try and spend.

Summa summarum, try and cut us inexperienced newbies some slack please (or, if you prefer, refrain from replying to our queries)
_________________
Michael
Back to top
View user's profile Send private message Send e-mail
William Collins
Supermod


Joined: 03 Jun 2012
Posts: 437
Topics: 0

PostPosted: Tue Nov 04, 2014 1:34 pm    Post subject: Reply with quote

We'd like you to look in the manual first. And when you're there, read more than one paragraph.

The tables of information can't be repeated at every point they are used. The manual is 956 pages (or whatever) already, and it would grow a lot if all the references were expanded.

Work out how the manual "works". There are specific examples, and more usage of most things if you use the search.

It's difficult to know how to answer sometimes, like this one. I couldn't work out how you'd found A1 but not found A3, so I was very unsure it was the answer you wanted, without having a clue as to why it wouldn't be. So I spent some time looking, getting nothing, and decided the only way to get further is to ask. I still don't know how you found A1 and didn't find A3 Smile

See things from the other side of the table as well.
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12382
Topics: 75
Location: San Jose

PostPosted: Tue Nov 04, 2014 1:51 pm    Post subject: Reply with quote

misi01 wrote:
Summa summarum, try and cut us inexperienced newbies some slack please (or, if you prefer, refrain from replying to our queries)


Misi01,

Wow. Refrain from replying. !! I am not sure as to what made you feel that, but either way thank you for your kind words. I will keep that in mind the next time you post a question.
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
misi01
Advanced


Joined: 02 Dec 2002
Posts: 629
Topics: 176
Location: Stockholm, Sweden

PostPosted: Tue Nov 04, 2014 2:31 pm    Post subject: Reply with quote

Kolusu, my append wasn't meant as a personal attack. I used to work for IBM as a software developer, visiting customers.
I remember some of the questions causing me to think "don't you know that, I thought everyone did"
My comment was an attempt to remind you that you work with dfsort every day and know it backward, we others don't.
We don't necessarily have the luxury of taking hours/days to solve a problem compared to appending in a forum.
If I have a solution (like some you have answered) that takes 3 steps, and solves my problem, I'm happy. YOU might point out (or ask) why you don't do it in one step? Simply because I don't know that it CAN be done in one. You do, but I might not.
_________________
Michael
Back to top
View user's profile Send private message Send e-mail
misi01
Advanced


Joined: 02 Dec 2002
Posts: 629
Topics: 176
Location: Stockholm, Sweden

PostPosted: Tue Nov 04, 2014 2:40 pm    Post subject: Reply with quote

William/Kolusu. Than you both for your answers to my appends/questions.

All I can do is reiterate my comments. I'm a cobol developer. I use dfsort every so often, NOT often enough to become an "expert" and for that reason as soon as I do anything "unusual" (for me), I'll Google and try and find an answer. But sometimes, all your attempts/variations fail. That's when you need help.

I'm guessing you guys want to see dfsort spread as much as possible. You do that by helping us newbies.

Thanks again
_________________
Michael
Back to top
View user's profile Send private message Send e-mail
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12382
Topics: 75
Location: San Jose

PostPosted: Tue Nov 04, 2014 2:47 pm    Post subject: Reply with quote

misi01 wrote:
My comment was an attempt to remind you that you work with dfsort every day and know it backward, we others don't.
We don't necessarily have the luxury of taking hours/days to solve a problem compared to appending in a forum.


Misi01,

It is true that I work with DFSORT everyday, but as you can see I also answer questions on COBOL, DB2, IMS, CICS REXX, Easytrieve....

Just so you know I don't have access to many of the products I answer. When in question, I first refer the manuals and read them over and over again until I understand it fully.

My earlier posting was merely to point you in the right direction to use DFSORT manuals as Frank has put in a lot of effort in writing them. You chose to Google when you know the keyword you are looking for.
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12382
Topics: 75
Location: San Jose

PostPosted: Tue Nov 04, 2014 3:05 pm    Post subject: Reply with quote

misi01 wrote:
William/Kolusu. Than you both for your answers to my appends/questions.

All I can do is reiterate my comments. I'm a cobol developer. I use dfsort every so often, NOT often enough to become an "expert" and for that reason as soon as I do anything "unusual" (for me), I'll Google and try and find an answer. But sometimes, all your attempts/variations fail. That's when you need help.


misi01,

I started this board long before(Dec 2002) I joined IBM as a DFSORT developer(Nov 2007). I have been answering questions ever since. I host this site out of my personal interest and with my own money without running a single ad or commercialize this site by selling my answers. Now I have to refrain from answering questions on my own board because you did not like me referring to the manuals? I guess I deserve that for all the effort I put in to this.

misi01 wrote:

I'm guessing you guys want to see dfsort spread as much as possible. You do that by helping us newbies.


I would love to show how Powerful and handy DFSORT is. That's about it.
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
misi01
Advanced


Joined: 02 Dec 2002
Posts: 629
Topics: 176
Location: Stockholm, Sweden

PostPosted: Tue Nov 04, 2014 3:39 pm    Post subject: Reply with quote

Kolusu - my apologies for what, in retrospect was an "angry" reply.

One thing I've realised reading the various appends is that, sometimes, the only limitation to dfsort is your imagination.

Again, in reality, many of us don't necessarily have the time to dig deeply into the many possibilities dfsort has.

You have to remember that someone might be able to put together a really complicated sort combination, but who's going to maintain it?
Don't laugh, but it's getting to the stage where I'm becoming one of the sort experts here at the bank

Very Happy
_________________
Michael
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group