] 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
//SYSOUT
List <IBM-MAIN@LISTSERV.UA.EDU> wrote on
10/26/2017 11:41:15 PM:
> From: "George, William@FTB" <bill.geo...@ftb.ca.gov>
> To: IBM-MAIN@LISTSERV.UA.EDU
> Date: 10/26/2017 11:41 PM
> Subject: Re: ICETOOL - Question regarding a statement in the ICETOOL
Guide
> S
nt: 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 I have:
http://
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://publibz.boulder.
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 statement
NKEYS
Thanks,
Sri Hari Kolusu
DFSORT Development
IBM Corporation
IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> wrote on
10/26/2017 03:09:04 AM:
> From: "George, William@FTB" <bill.geo...@ftb.ca.gov>
> To: IBM-MAIN@LISTSERV.UA.EDU
> Date: 10/26/2017 03
: 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 SPLICE statement sh
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:
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
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
age-
> 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 an I
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
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
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 Joinkeys. Looking at the your
:: expected results, I
Development
IBM Mainframe Discussion List IBM-MAIN@listserv.ua.edu wrote on
05/16/2013 11:01:00 AM:
From: retired mainframer retired-mainfra...@q.com
To: IBM-MAIN@listserv.ua.edu,
Date: 05/16/2013 11:05 AM
Subject: Re: ICETOOL question
Sent by: IBM Mainframe Discussion List IBM-MAIN
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 nf.ibmm...@web.de wrote:
On Fri, 10 May 2013 08:53:40 -0500, K wrote:
Two steps:
//*
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
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
To: IBM-MAIN@listserv.ua.edu,
Date: 05/10/2013 07:01 AM
Subject: ICETOOL question
Sent by: IBM Mainframe Discussion List IBM-MAIN@listserv.ua.edu
Hi dear all,
I would like to produce a statistic report using ICETOOL. This
report should shown the percentage of records in the file
19 matches
Mail list logo