IBM Mainframe Forum

[sl00872]

Hi,
I am trying to make a report with display and sort, but it would not create the report at first place.
My code is:

Select all

//EXAMP JOB A402,PROGRAMMER
//TOOLRUN EXEC PGM=ICETOOL,REGION=1024K
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//REPORT DD SYSOUT=*
//TOOLIN DD *
  SORT FROM (IN) TO (SORTTEMP)
  INCLUDE COND=(31,1,CH,EQ,C,'P')
  SORT FIELDS=(23,8,CH,A,71,2,CH,A)
  SUM FIELDS=(60,11,ZD)
  DEFAULTS LIST(SHOWDEF)
  DISPLAY FROM(SORTTEMP) LIST(REPORT)-
  TITLE('PAYMENTS BY TELLER') PAGE -
  HEADER('TELLER') ON(23,8,CH)-
  HEADER('PAYMENTS') ON (60,11,ZD)-
  BTITLE('TRANSFER TYPE') BREAK(71,2,CH)-
  BTOTAL('SUBTOTAL')
/*
//IN DD DSN='SOME.INPUT.DATASET', DISP=SHR
//SORTTEMP DD DSN=&&SORTTEMP,DCB=SURCICS.ZEUSBANK.TXNOFFLD
//SHOWDEF DD SYSOUT=*
//SORTOUT DD DSN=&&SORTTEMP
 

I was expecting a report, but that didn't happen.
Edited to remove real data set name

[steve-myers]

Well, golly gee. It's nice to hear that. What error messages did you get? We have to know that to provide any assistance. You have to know this to diagnose the error yourself. We will not attempt to analyze your entire job ourselves. That is not what what we're here for. You want that type of consultant service you or your employer can go out and hire a consultant.

[sl00872]

Thanks for the reply, well since it is not a JCL error on the SDSF, I believe that ICETOOL reads the control statements of the TOOLIN sysin as empty so it cannot produce the report. Can you show me what could be the correct sysin names for DFSORT and ICETOOL to find JCL?

[NicC]

The manual has sample JCL for both DFSort and ICETOOL.
What return code did you get from ICETOOL?
What is in SDSF for TOOLMSG, DFSMSG, REPORT and SHOWDEF?
Have yu tried making the temporary SORTOUT dataset permanent whilst diagnosing so that you can check what is in it?

[sl00872]

Reutrn code is 0012
In the SDSF, it only makes a TOOLMSG, there is no DFSMSG, REPORT and SHOWDEF.
The JES2 JOB STATISTICS in the JESMSGLG shows that there are 22 cards read, 106 sysout print records, 0 susout prunch records, 9 sysout spool kbytes and 0.00 minutes execution time. I assumed that it could run the JCL but it could not create the report at first place, but I am not sure.
I tried making it a permanent dataset to show whats inside, but it ends up having the same problem.

[enrico-sorichetti]

we would like to see the 106 sysout print records

if You keep on in this way people will lose interest in helping You

even for a beginner some basic skills are still required ...
the most important is ..
being able to use SDSF to look at the output of a job
separate the different <sysout> datasets
post the content of relevant ones

without that very little we can do

[NicC]

We would also need to see sample input and and the expected report from that sample. Also, what are the data set characteristics of the input data set - recfm, lrecl?

[sergeyken]

The syntax of the original example is wrong - from top to bottom.

The result of this run is as expected - as if it was an attempt to run a randomly generated sequence of words.

1) There are multiple samples of reporting jobs available; use them as starting point.

2) Besides of "error code 12" the ICETOOL also issued a lot of error messages in plain English. Do you speak English?
2.1) If no - take training classes on English.
2.2) If yes - please, read the messages from ICETOOL utility, and try to understand their meaning.
2.2.1) If the problem is clear - fix it, and run again
2.2.2) If (only) something is not clear then ask for help from Forum.