Re: ICETOOL - Question regarding a statement in the ICETOOL Guide

2017-10-27 Thread George, William@FTB
UA.EDU] On Behalf Of Sri h Kolusu Sent: Friday, October 27, 2017 9:09 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: ICETOOL - Question regarding a statement in the ICETOOL Guide Bill, Here is a DFSORT JOINKEYS job which will give you the desired results similar to splice //STEP0100 EXEC PGM=SORT

Re: ICETOOL - Question regarding a statement in the ICETOOL Guide

2017-10-27 Thread Sri h Kolusu
tion IBM Mainframe Discussion List wrote on 10/26/2017 11:41:15 PM: > From: "George, William@FTB" > To: IBM-MAIN@LISTSERV.UA.EDU > Date: 10/26/2017 11:41 PM > Subject: Re: ICETOOL - Question regarding a statement in the ICETOOL Guide > Sent by: IBM Mainframe Discussion L

Re: ICETOOL - Question regarding a statement in the ICETOOL Guide

2017-10-26 Thread George, William@FTB
t; Sent: Thursday, October 26, 2017 11:11 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: ICETOOL - Question regarding a statement in the ICETOOL > Guide > > Thanks Sri! > JOINKEYS... that's a new one on me. I guess I have an outdated DFSORT manual. > Here's the link

Re: ICETOOL - Question regarding a statement in the ICETOOL Guide

2017-10-26 Thread retired mainframer
t; To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: ICETOOL - Question regarding a statement in the ICETOOL Guide > > Thanks Sri! > JOINKEYS... that's a new one on me. I guess I have an outdated DFSORT manual. > Here's the link I have: http://publib

Re: ICETOOL - Question regarding a statement in the ICETOOL Guide

2017-10-26 Thread George, William@FTB
On Behalf Of Sri h Kolusu Sent: Thursday, October 26, 2017 10:56 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: ICETOOL - Question regarding a statement in the ICETOOL Guide George, It was a typo in our publications, it should be 1-10 instead of 1-3. The sorting of 1-10 bytes is done with ON st

Re: ICETOOL - Question regarding a statement in the ICETOOL Guide

2017-10-26 Thread Sri h Kolusu
George, It was a typo in our publications, it should be 1-10 instead of 1-3. The sorting of 1-10 bytes is done with ON statement on SPLICE. Please look at the DFSMSG dataset and you will see the SPLICE control cards generates the SORT statement with 1,10,CH,A We will update our pubs. Thanks f

Re: ICETOOL - Question regarding a statement in the ICETOOL Guide

2017-10-26 Thread George, William@FTB
teve Smith Sent: Thursday, October 26, 2017 5:29 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: ICETOOL - Question regarding a statement in the ICETOOL Guide Nothing in the "JCL code". It appears to me the example has a mistake: either they meant they sort on "positions 1-10", or the SPLI

Re: ICETOOL - Question regarding a statement in the ICETOOL Guide

2017-10-26 Thread Lizette Koehler
If you were not aware, there is a dfsort hotline where you can email any DFSORT question to IBM. This is a no charge service To do so - userdfs...@us.ibm.com Lizette > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of George,

Re: ICETOOL - Question regarding a statement in the ICETOOL Guide

2017-10-26 Thread Steve Smith
Nothing in the "JCL code". It appears to me the example has a mistake: either they meant they sort on "positions 1-10", or the SPLICE statement should have "ON(1,3,CH)". This example is so trivial, it's hard to know for sure what they meant. But probably it's the former. There's a really helpful

Re: ICETOOL Question

2016-10-14 Thread Lizette Koehler
Mark, Did you check out the material on ibm website for ICETOOL? It is pretty much a 4GL type language. Here is the URL and a brief Blurb for those that do not know ICETOOL ftp://ftp.software.ibm.com/storage/dfsort/mvs/sorttool.pdf This paper is a mini-user guide for DFSORT's versatile ICETOOL

Re: ICETOOL Question

2016-10-14 Thread Bill Woodger
Why ICETOOL? It is a DFSORT COPY operation, with a BUILD on INREC. OPTION COPY INREC BUILD=(starta,lengtha,startb,lengthb,startc,lengthc,startd,lengthd) -- For IBM-MAIN subscribe / signoff / archive access instructions, send em

Re: ICETOOL question

2013-05-16 Thread Sri h Kolusu
(1,4,25,5,X,35,15)) //* Kolusu DFSORT Development IBM Mainframe Discussion List wrote on 05/16/2013 11:01:00 AM: > From: retired mainframer > To: IBM-MAIN@listserv.ua.edu, > Date: 05/16/2013 11:05 AM > Subject: Re: ICETOOL question > Sent by: IBM Mainframe Discussion List >

Re: ICETOOL question

2013-05-16 Thread retired mainframer
Of Sri h Kolusu :>: Sent: Friday, May 10, 2013 9:00 AM :>: To: IBM-MAIN@LISTSERV.UA.EDU :>: Subject: Re: ICETOOL question :>: :>: K, :>: :>: The following DFSORT JCL will give you the desired results. The trick :>: here :>: is to use the same input file twice with Joinke

Re: ICETOOL question

2013-05-13 Thread k Zaf
Dear All I could never thought that DFSORT should help to produce percentages of the records... Thank you for your (more or less tricky) help Kind regards Kostas On 10 May 2013 20:10, Norbert Friemel wrote: > On Fri, 10 May 2013 08:53:40 -0500, K wrote: > > Two steps: > > //* > //S1 EXE

Re: ICETOOL question

2013-05-10 Thread Norbert Friemel
On Fri, 10 May 2013 08:53:40 -0500, K wrote: Two steps: //* //S1 EXEC PGM=ICETOOL //* //TOOLMSG DD SYSOUT=*

Re: ICETOOL question

2013-05-10 Thread Sri h Kolusu
K, The following DFSORT JCL will give you the desired results. The trick here is to use the same input file twice with Joinkeys. Looking at the your expected results, I also rounded the decimal. //STEP0100 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //IN1 DD * AAA BBB AAA CCC AAA BBB //I

Re: ICETOOL question

2013-05-10 Thread Elardus Engelbrecht
Kzafirop wrote: >I would like to produce a statistic report using ICETOOL. This report should >shown the percentage of records in the file according to their values e.g. >Is there any ICETOOL operator (like OCCUR) to find out the above percentage? >Do I have to use various INCLUDE COND and then