Binyamin Dissen on IBM Mainframe Discussion List
wrote on 07/07/2010 10:51:12 AM:
> I have an application which produces multiple SMF records. I have created
an
> ICETOOL job to format the detail records, but I would like to include the
> header record. The header record is a different subtype wit
I have an application which produces multiple SMF records. I have created an
ICETOOL job to format the detail records, but I would like to include the
header record. The header record is a different subtype with different data. I
would like the report to indicate there was a started record (perhaps
-MAIN@bama.ua.edu
Subject: Re: DFSORT - ICETOOL Question
Page 9 of
http://www-947.ibm.com/systems/support/storage/software/sort/mvs/tricks/
pdf/sorttrck.pdf has a sample of how to do this.
__
CONFIDENTIALITY NOTICE: This email fro
: IBM-MAIN@bama.ua.edu
Subject: DFSORT - ICETOOL Question
Group
It's Friday and my brain is NOT working. I'm having a heck of a time
putting together an ICETOOL step.
The output is every record in dataset 1 that has a matching key in
dataset 2.
The 2 datasets have different LRECLs a
William George wrote on 05/21/2010 10:47:54 AM:
> It's Friday and my brain is NOT working. I'm having a heck of a time
> putting together an ICETOOL step.
>
> The output is every record in dataset 1 that has a matching key in
> dataset 2.
>
> The 2 datasets have different LRECLs and the key is in
Group
It's Friday and my brain is NOT working. I'm having a heck of a time
putting together an ICETOOL step.
The output is every record in dataset 1 that has a matching key in
dataset 2.
The 2 datasets have different LRECLs and the key is in different
positions.
DS1: LRECL=400 KE
Tim Hare wrote on 06/04/2008 01:59:39 PM:
> I know the offset and format of the count, and I certainly can
> compare it to a
> literal. The problem is not knowing the maximum value the count could
have in
> any group of records (and each record can have a different value for the
> count). I could
I know the offset and format of the count, and I certainly can compare it to a
literal. The problem is not knowing the maximum value the count could have in
any group of records (and each record can have a different value for the
count). I could for example, code the IFTHEN statement to handle
Tim Hare wrote on 06/04/2008 10:59:55 AM:
> Really two questions I guess.
>
> 1. We have variable length records with the data similar to COBOL 'OCCURS
> DEPENDING ON' clauses - a count of the number of segments to follow,
> followed by those segments. Is there a way to handle these in
> INREC/OU
I probably already know the answer but does the number of segments/offsets
change with each record type or would/do they remain the same? If the later,
then there is a DFSORT solution.
On Wed Jun 4 12:59 , Tim Hare <[EMAIL PROTECTED]> sent:
>Really two questions I guess.
>
>1. We have varia
Really two questions I guess.
1. We have variable length records with the data similar to COBOL 'OCCURS
DEPENDING ON' clauses - a count of the number of segments to follow,
followed by those segments. Is there a way to handle these in
INREC/OUTREC/OUTFILE ? I already thought of using IFTHEN
-
Indeed, in some ways it's approaching DWIM. Just needs "a little more
coding" :-)
How about "DEBE" (Does Everything But Eat, for the "newbies") ??
--
> -Original Message-
> From: IBM Mainframe Discussion List On Behalf Of ITURIEL DO NASCIMENTO
NETO
>
> DFSORT should provide an USERMOD creating an ALIAS called ICECOOL
Indeed, in some ways it's approaching DWIM. Just needs "a little more
coding" :-)
-jc-
-
|-Mensagem original-
|De: IBM Mainframe Discussion List
|[mailto:[EMAIL PROTECTED] Em nome de tony babonas
|Enviada em: quarta-feira, 30 de janeiro de 2008 13:05
|Para: IBM-MAIN@BAMA.UA.EDU
|Assunto: Re: Icetool question
|
|From personal experience I can state that ICETOOL is cool. :-)
|
|
AVISO
On 30 Jan 2008 07:44:39 -0800, [EMAIL PROTECTED] (Frank Yaeger) wrote:
>It OCCURS to me that several people on the list have SELECTed me for
>some kind words. I've PARSEd them and I appreciate it! I hope they're
>JUSTIFIED, but we probably shouldn't SQUEEZE any more mileage out of
>this since it
Howard Brazee wrote on 01/30/2008 07:16:56 AM:
> Looking at this code, it appears that the variable that I need to know
> is in:
>
> SELECT FROM(T1) TO(OUT) ON(1,1,CH) NODUPS USING(CTL3)
>
> This compares only column 1? So if I want to compare a whole record
> (columns 1-80) I would change it to:
Elardus Engelbrecht wrote on 01/30/2008 06:49:53 AM:
> Don Leahy wrote:
>
> >On Jan 30, 2008 4:18 AM, Thomas Berg <[EMAIL PROTECTED]> wrote:
> >> Frank "Sure it can" Yaeger
> >>
> >Yeah, if you use the words "can't" and "DFSORT" in the same sentence,
> >Frank can usually straighten you out. :-)
>
: Wednesday, January 30, 2008 9:17 AM
To: IBM-MAIN@BAMA.UA.EDU
Subject: Re: Icetool question
Looking at this code, it appears that the variable that I need to know
is in:
SELECT FROM(T1) TO(OUT) ON(1,1,CH) NODUPS USING(CTL3)
This compares only column 1? So if I want to compare a whole record
Looking at this code, it appears that the variable that I need to know
is in:
SELECT FROM(T1) TO(OUT) ON(1,1,CH) NODUPS USING(CTL3)
This compares only column 1? So if I want to compare a whole record
(columns 1-80) I would change it to:
SELECT FROM(T1) TO(OUT) ON(1,80,CH) NODUPS USING(CTL3)
>From personal experience I can state that ICETOOL is cool. :-)
-Original Message-
From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf
Of Elardus Engelbrecht
Sent: Wednesday, January 30, 2008 8:50 AM
To: IBM-MAIN@BAMA.UA.EDU
Subject: Re: Icetool question
Don Leahy wrote:
>On Jan 30, 2008 4:18 AM, Thomas Berg <[EMAIL PROTECTED]> wrote:
>> Frank "Sure it can" Yaeger
>>
>Yeah, if you use the words "can't" and "DFSORT" in the same sentence,
>Frank can usually straighten you out. :-)
Actually, Frank "Sure it can" Yaeger can SORT you out! ;-D
He can
On Jan 30, 2008 4:18 AM, Thomas Berg <[EMAIL PROTECTED]> wrote:
> Frank "Sure it can" Yaeger
>
Yeah, if you use the words "can't" and "DFSORT" in the same sentence,
Frank can usually straighten you out. :-)
--
For IBM-MAIN subscr
Frank "Sure it can" Yaeger
:)
> -Ursprungligt meddelande-
> Från: IBM Mainframe Discussion List
> [mailto:[EMAIL PROTECTED] För Frank Yaeger
> Skickat: den 30 januari 2008 00:21
> Till: IBM-MAIN@BAMA.UA.EDU
> Ämne: Re: Icetool question
>
> Neal Eck
Howard Brazee wrote on 01/29/2008 01:31:18 PM:
> Frank Yaeger just answered that for me:
>
> There are several ways to do this with DFSORT/ICETOOL. If you just
> want a list of the duplicate SSNs, the easiest way is to use an OCCURS
> job something like this:
>
> //S1 EXEC PGM=ICETOOL
> //TOOLMSG D
Neal Eckhardt wrote on ibm-main:
>A user has asked if ICETOOL can compare two datasets and provide the
>records that exist in file 2 that are not in file 1.
>
>SO, if file1 is
>
>1
>2
>3
>4
>5
>
>and file2 is
>
>1
>2
>3
>4
>6
>
>the resulting file would contain
>
>6
>
>I don't think it can, but I t
Frank Yaeger just answered that for me:
There are several ways to do this with DFSORT/ICETOOL. If you just
want a list of the duplicate SSNs, the easiest way is to use an OCCURS
job something like this:
//S1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD *
2
1
On Jun 15, 6:19 am, oktg wrote:
> I wonder if anybody could help me out with following question:
>
> i want to use DFSORT/ICETOOL to convert a flat file (eg FB,80) having
> the following layout:
>
> +1+2+3
> **
> FL641 10JAN1993 VOL JFK
> FL642 11
On Fri, 9 Jun 2006 15:01:52 -0700, Frank Yaeger <[EMAIL PROTECTED]> wrote:
>If so, then you can use the following DFSORT/ICETOOL job. I'm assuming
all
>of your input files have RECFM=FB and the same LRECL.
>
>//S1EXEC PGM=ICETOOL
>//TOOLMSG DD SYSOUT=*
>//DFSMSGDD SYSOUT=*
>//IN3 DD DSN
Andy Robertson wrote on 06/09/2006 12:04:14 PM:
> If I have a set of files containing records as follows:
>
> File 1
> 10012345FIRST
> 10112345FIRST
> 10212345FIRST
> 10312345FIRST
>
> File 2
> 10012345 SECOND
> 10312345 SECOND
> 10512345 SECOND
> 10612345 S
What you want is SPLICE - from the manual
SPLICE - splices together fields from records that
have the same numeric or character field values
(that is, duplicate values), but different information.
Fields from two or more records can be combined to
create an output record. The fields to be spliced
If I have a set of files containing records as follows:
File 1
10012345FIRST
10112345FIRST
10212345FIRST
10312345FIRST
File 2
10012345 SECOND
10312345 SECOND
10512345 SECOND
10612345 SECOND
File 3
10012345THIRD
10112345
31 matches
Mail list logo
