MVSFORUMS.com

Nancy · Beginner Joined: 23 May 2003 Posts: 77 Topics: 26

I am trying to print the sectioned reports by using ICETOOL. There I am using BREAK to have different sections for different Authors. But my output is not as per the expectation.

My JCL is here -

kolusu · Posted: Thu Dec 18, 2003 6:56 am Post subject:

Nancy,

You are also having book title as one of your criteria in your JCL. Even though the Author is the same , the title is different.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Nancy · Beginner Joined: 23 May 2003 Posts: 77 Topics: 26

Kolusu,

I think Book title is just for the printing purpose, it has nothing to do with the BREAK. Please let me know the changes which I need to make in my JCL code, in order to print all the Books (having different titles) of the same Author on a single Page and then ICETOOL inserts the BREAK so that each PAGE displays the books of a single Author.

Just for example -

BOOKS FOR INDIVIDUAL AUTHORS - 3 -
AUTHOR : KATARIA

BOOK TITLE PRICE
--------------- ----------------
AMER ENG1 1790
AMER ENG2 2790
AMER ENG3 3790

AVERAGE FOR THIS AUTHOR 2790

TOTAL FOR THIS AUTHOR 8370

Hope it makes sense.

Regards

kolusu · Posted: Thu Dec 18, 2003 8:51 am Post subject:

Nancy,

I was refering to the ON statement which has for the book title .ie. ON(1,15,CH).

Change your toolin cards to the following so that you get the desired results

Nancy · Beginner Joined: 23 May 2003 Posts: 77 Topics: 26

Kolusu,

I tried with your code and getting the below output.

BOOKS FOR INDIVIDUAL AUTHORS - 3 -

AUTHOR : KATARIA

BOOK TITLE PRICE
---------- ----------------
KATARIA 1790
KATARIA 2790
KATARIA 3790

AVERAGE FOR THIS AUTHOR
2790

TOTAL FOR THIS AUTHOR 8370

Reason behind this is we have changed the Title location to Author and so Author is getting printed instead of Title but all other things are looking just fine. What next to do to have Book titles and not The Authors ?

Regards

kolusu · Posted: Thu Dec 18, 2003 9:52 am Post subject:

Nancy,

I forgot to change the title. Change your toolin cards to the following to get the desired results.

Nancy · Beginner Joined: 23 May 2003 Posts: 77 Topics: 26

Thanks Kolusu.
Your code is creating the desired report for me.
Just one more doubt here.

Suppose I don't want the Author Name to be repeated every time in the report amd only want to have BOOK TITLE and PRICE since the AUTHOR has already been printed at the top. My report will look like below.

kolusu · Posted: Fri Dec 19, 2003 6:25 am Post subject:

Nancy,

I think you need a sort statement for the break to work. Try adding a sort statement to your job before the display

i.e

Nancy · Beginner Joined: 23 May 2003 Posts: 77 Topics: 26

Kolusu,

It doesn't create the desired report. You are just sorting the Input datastream before displaying by adding the SORT step but please note that my INPUT data is already sorted in that way.

One Observation here.
When I code the SORT condition as below

kolusu · Posted: Fri Dec 19, 2003 10:08 am Post subject:

Nancy,

I don't have ICETOOL at my shop. So I really cannot test all features of ICETOOL. Any way the following JCL will give you the desired results. I have used the regular report features.

Frank Yaeger · Posted: Fri Dec 19, 2003 11:25 am Post subject:

Nancy and Kolusu,

You're making this more complicated than it needs to be. You don't need a SORT operator since the input file is already sorted by Author. If you don't want the Author printed in the detail records, then just remove the HEADER and ON field for the Author from Kolusu's original job.

BREAK indicates the key you want to section the report by - the BREAK field will be printed in the break title line along with the BTITLE string. ON indicates a field you wanted printed in the detail lines.

So you need:

kolusu · Posted: Fri Dec 19, 2003 11:35 am Post subject:

Frank,

I ran your Job with Syncsort and it did not provide me the results shown by you. I get the following results

Frank Yaeger · Posted: Fri Dec 19, 2003 1:33 pm Post subject:

Kolusu and Nancy,

As you know, DFSORT's ICETOOL is fully documented. With DFSORT's ICETOOL, the DISPLAY statement I show works exactly as it's documented and supposed to work, and gives the output I showed which is the output it's documented and supposed to give.

The output produced by the other product for this DISPLAY statement doesn't make any sense. The point of BREAK is to group duplicate records and it's not doing that.

kolusu · Posted: Fri Dec 19, 2003 1:43 pm Post subject:

Frank,

Thanks for the clarification.I fully agree with you about the unpredicted results of using SYNCTOOL. On top of it is unsupported and there is no documentation at all. Now I can add DISPLAY feature in my non-working features. My non-working sort feature list is growing with every new ptf of DFSORT. I wish I had the capability to migrate to DFSORT.

I guess Nancy is also using SYNCSORT as her first post had similar report as mine. The latest release of syncsort had an alias for ICETOOL which makes the programmer believe that he is actually running DFSORT but in reality he is running syncsort.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Alain Benveniste · Posted: Fri Dec 19, 2003 2:13 pm Post subject:

Starting 6 Months ago, I had to upgrade our VM240 to Z/VM430.
Naturally all the products was impacted... and specifically Syncsort.
I phoned to the support to ask them to send me the new version and the documentation. Because i am curious I also asked the MVS documentation. With the nice package I received, it was a wonderfull paper which explained that Syncsort is the best in its category with nice graphics... not expensive... Editing the MVS doc, the last modification date was ... something around 1996.
For my part on VM, what I applied was only ptfs toleration.
No comment
Alain