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
NKEYS Thanks, Sri Hari Kolusu DFSORT Development IBM Corporation IBM Mainframe Discussion List wrote on 10/26/2017 03:09:04 AM: > From: "George, William@FTB" > To: IBM-MAIN@LISTSERV.UA.EDU > Date: 10/26/2017 03:09 AM > Subject: ICETOOL - Question regarding a statement in the I

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
Of George, William@FTB > Sent: Wednesday, October 25, 2017 2:39 PM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: ICETOOL - Question regarding a statement in the ICETOOL Guide > > I am confused about a statement I'm seeing in the DFSORT - ICETOOL Chapter > and its example:

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

ICETOOL - Question regarding a statement in the ICETOOL Guide

2017-10-25 Thread George, William@FTB
I am confused about a statement I'm seeing in the DFSORT - ICETOOL Chapter and its example: Example 3 - Create files with matching and non-matching records I've copied the example below and my question is regarding the last line below and it statement on sorting: We sort the records of T1 on posi

Re: ICETOOL Question

2016-10-14 Thread Lizette Koehler
ginal Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Mark Jacobs - Listserv > Sent: Friday, October 14, 2016 1:10 PM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: ICETOOL Question > > Before I dig into the books, does anyone have a

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

ICETOOL Question

2016-10-14 Thread Mark Jacobs - Listserv
Before I dig into the books, does anyone have an ICETOOL example that does this; Copy all records in a file has these fields B CCC D to a different file in this field order -- Mark Jacobs Time Customer Service Global Tec

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
N@listserv.ua.edu, > Date: 05/10/2013 07:01 AM > Subject: ICETOOL question > Sent by: IBM Mainframe Discussion List > > Hi dear all, > > I would like to produce a statistic report using ICETOOL. This > report should shown the percentage of records in the file according

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

ICETOOL question

2013-05-10 Thread K
Hi dear all, 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. Input: AAA BBB AAA CCC AAA BBB Output Percentages: AAA 50,0 BBB 33,0 CCC 16,7 Is there any ICETOOL operator (like OCCUR) to fin