Page 1 of 1
Unable to create a report
Posted:
Sat Aug 17, 2019 3:16 amby 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:
//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
Re: Unable to create a report
Posted:
Sat Aug 17, 2019 9:45 amby 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.
Re: Unable to create a report
Posted:
Sat Aug 17, 2019 11:52 amby 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?
Re: Unable to create a report
Posted:
Sat Aug 17, 2019 4:04 pmby 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?
Re: Unable to create a report
Posted:
Sat Aug 17, 2019 6:25 pmby 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.
Re: Unable to create a report
Posted:
Sat Aug 17, 2019 6:53 pmby 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
Re: Unable to create a report
Posted:
Sun Aug 18, 2019 1:26 amby 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?
Re: Unable to create a report
Posted:
Mon Aug 19, 2019 8:36 pmby 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.