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 

Using MINIMUM & MAXIMUM without HEADER

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


Joined: 01 Jun 2003
Posts: 372
Topics: 105
PostPosted: Tue Jan 20, 2009 9:56 am    Post subject: Using MINIMUM & MAXIMUM without HEADER Reply with quote
Hi, Is it possible to use MINIMUM & MAXIMUM without using HEADER in DISPLAY feature of ICETOOL?

Please suggest.

Thanks.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==
Back to top
View user's profile Send private message Send e-mail
dbzTHEdinosauer
Supermod


Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany
PostPosted: Tue Jan 20, 2009 10:30 am    Post subject: Reply with quote
Quote:
Please suggest


you have of course tried yourself; what were the results?
_________________
Dick Brenholtz
American living in Varel, Germany
Back to top
View user's profile Send private message
mf_user
Intermediate


Joined: 01 Jun 2003
Posts: 372
Topics: 105
PostPosted: Tue Jan 20, 2009 10:41 am    Post subject: Reply Reply with quote
Dick, I used NOHEADER BLANK but I am looking for the way to get MIN & MAX alone (without detail records).

Thanks.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==
Back to top
View user's profile Send private message Send e-mail
Frank Yaeger
Sort Forum Moderator
Sort Forum Moderator


Joined: 02 Dec 2002
Posts: 1618
Topics: 31
Location: San Jose
PostPosted: Tue Jan 20, 2009 10:53 am    Post subject: Reply with quote
Quote:
I am looking for the way to get MIN & MAX alone (without detail records).


There is certainly a way to do what you want, although it might not be with DISPLAY (e.g. you might need to use STATS or OUTFIL).

But how you would do what you want depends on the details of what you want to do which you haven't told us.

Please show an example of the records in your input file (relevant fields only) and what you expect for output. Give the RECFM and LRECL of your input file. Give the starting position, length and format of each relevant field.
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Back to top
View user's profile Send private message Send e-mail Visit poster's website
mf_user
Intermediate


Joined: 01 Jun 2003
Posts: 372
Topics: 105
PostPosted: Tue Jan 20, 2009 11:27 am    Post subject: Reply Reply with quote
Hi, Frank.

My input file: LRECL=398, RECFM=FB.

Code:

----+----1----+----2-
08ABC2214531    01895
08ABC2214537    10895
08ABC2214532    20895
08ABC2214534    02295
08ABC2214535    00815
08ABC2214539    00191


Output should contain only Min & Max values for the position starting in 17th column.

Code:

Min Value: 00191
Max Value: 20895


Thank you.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==
Back to top
View user's profile Send private message Send e-mail
Frank Yaeger
Sort Forum Moderator
Sort Forum Moderator


Joined: 02 Dec 2002
Posts: 1618
Topics: 31
Location: San Jose
PostPosted: Tue Jan 20, 2009 1:50 pm    Post subject: Reply with quote
Here's a DFSORT job that will do what you asked for:

Code:

//S1    EXEC  PGM=ICEMAN
//SYSOUT    DD  SYSOUT=*
//SORTIN DD DSN=...  input file
//SORTOUT DD DSN=...  output file
//SYSIN    DD    *
  OPTION COPY
  OUTFIL REMOVECC,NODETAIL,
    TRAILER1=('Min Value: ',MIN=(17,5,ZD,TO=ZD,LENGTH=5),/,
              'Max Value: ',MAX=(17,5,ZD,TO=ZD,LENGTH=5))
/*

_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Back to top
View user's profile Send private message Send e-mail Visit poster's website
mf_user
Intermediate


Joined: 01 Jun 2003
Posts: 372
Topics: 105
PostPosted: Wed Jan 21, 2009 5:43 am    Post subject: Thanks. Reply with quote
Frank, Thank you. Also, after your suggestion I tried it with STATS and got the MIN, MAX, TOTAL and AVG but in SYSOUT only and I thought a file should be assigned to TOOLMSG to see it and writable to file.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==
Back to top
View user's profile Send private message Send e-mail
Frank Yaeger
Sort Forum Moderator
Sort Forum Moderator


Joined: 02 Dec 2002
Posts: 1618
Topics: 31
Location: San Jose
PostPosted: Wed Jan 21, 2009 10:58 am    Post subject: Reply with quote
I'm not sure if you're asking me something or telling me something.

With STATS, the MIN, MAX, TOTAL and AVG values are displayed in messages in TOOLMSG. For example:

Code:

ICE607I 0 STATISTICS FOR (17,5,ZD)     :                           
ICE608I 0   MINIMUM:  +000000000000191, MAXIMUM:  +000000000020895
ICE609I 0   AVERAGE:  +000000000006164, TOTAL  :  +000000000036986


You can direct TOOLMSG to a file instead of to SYSOUT, e.g.

Code:

//TOOLMSG DD DSN=myfile,DISP=(NEW,CATLG,DELETE),
//  SPACE=(TRK,(5,5)),UNIT=SYSDA


You could then view the file. You could also, of course, use DFSORT to extract whatever information you want from that file.
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Back to top
View user's profile Send private message Send e-mail Visit poster's website
mf_user
Intermediate


Joined: 01 Jun 2003
Posts: 372
Topics: 105
PostPosted: Wed Jan 21, 2009 12:13 pm    Post subject: Reply with quote
Yes Frank. I was trying tell you the same thing. Smile

Thanks.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==
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