Question on BREAK in ICETOOL



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Question on BREAK in ICETOOL

Postby Gallium » Thu Nov 27, 2014 12:21 am

Looking at P153 of this again

http://publibz.boulder.ibm.com/epubs/pd ... &zoom=auto

It says ..BREAK(106,4,CH)-

It states that 106 means the field number of the member that it breaks, does this mean that record 106 is included at the end of the first list or beginning of the second? Also, does JCL know how many records are in each publisher i.e. in this example VALD has 10 records but WETH has 9 so JCL knew where to break?
Gallium
 
Posts: 33
Joined: Tue Nov 25, 2014 10:07 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Question on BREAK in ICETOOL

Postby NicC » Thu Nov 27, 2014 3:26 am

As said elsewhere, sort does not know about fields. 106 is the column within the record and the 4 is the length so the 'field' is the 4 bytes starting at position 106 i.e bytes 106, 107, 108 and 109.
JCL does not 'know' anything about the contents of a dataset. JCL tells the operating system what program(s) you want to execute and what resources are required by said program(s). Within the program the execution is specifed by the control cards which you supply as required. Not all programs require control cards but utility programs generally do although if they are not supplied some default action may be undertaken.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: Question on BREAK in ICETOOL

Postby Gallium » Thu Nov 27, 2014 4:17 am

I understand that fine. But what is confusing me is why in the example they broke it at 106?
Gallium
 
Posts: 33
Joined: Tue Nov 25, 2014 10:07 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Question on BREAK in ICETOOL

Postby BillyBoyo » Thu Nov 27, 2014 12:50 pm

Position 106 is where the field starts which contains "VALD" or "WETH". When the value of the field changes, the total ptorcessing for the previous value is done, and the heading set-up for the new value is done. Spacial cases are firstl record, no totalling, and last record, no heading set-up.

Again, records do not have fields. Records contain data. The meaning of that data, depending on the file, can change from record to record or be the same from record to record, but the only thing which tells a program that is the program itself.

They "broke it at 106" because 1) that's where one the record, of this single-record-type file, the data which indicates publoisher, in the case of this program, the break field, is and 2) 106 is the position of the field on the record not the record on the file.

Can you tell us how you have been using the document? You have some conceptual problems we need to deal with, otherwise we explain, you say "yes, I know that" then proceeed to show that you don't.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Question on BREAK in ICETOOL

Postby Gallium » Thu Nov 27, 2014 11:32 pm

I am doing an IBM Mainframe Course which I do not want to fail! We have been given an assignment to use JCL and ICETOOL to generate various reports.
Gallium
 
Posts: 33
Joined: Tue Nov 25, 2014 10:07 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post