IBM Mainframe Forum

Hello

I am a newcomer in the Mainframe world. I have a dataset with name SPORT.TRDATA2. The field locations and the column spaces of the data re fixed. This is the data of a company who has shops in different locations and sells footballs. The first column is the shop location and has range 1,15 , the second field is the year 17.4 the third is the month 23,2 and the last column is the sales 26,7

I want to sort for each month the sales. I have written some JCL statements but my problem is that when i go to SDSF i cannot see the output of the job so i am not sure if the JCL that I wrote is correct.



Is the above correct?? Also how can use icetool to sort this data

You need at least one space before each DFSORT control statement, e.g. replace each b with a space:



These control statements sort by the shop and sum the sales for each shop. That does NOT match your description of what you want to do.

how can use icetool to sort this data

You can use an ICETOOL SORT operator to sort the data. But you don't need to as the PGM=ICEMAN (DFSORT) job will sort it.

Please show an example of the records in your input file and what you expect for the output records. Give the RECFM and LRECL of the input file. Use code tags around the example data.

when i go to SDSF i cannot see the output of the job

I suspect you need to use MSGCLASS=x where x is the class for held output. Ask somebody at your shop about that. We use e MSGCLASS=H here, but it may be different at your shop.

If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

http://www.ibm.com/servers/storage/supp ... tmpub.html

The dataset is fixed block with LRECL of 41 characters and BLKSIZE 24600
an example of the dataset is


What is RFCM ?? Tha data is fixed block
Thank you very much for your help

What is RFCM ?? Tha data is fixed block

RECFM is record format. If it's fixed blocked then its RECFM=FB.

You showed the input records. Now you need to show the expected output records (as previously requested).

Also MSGCLASS=H and Class = A

I need to create three datasets reading from the dataset SPORT.TRDATA2 in order to get the following outcomes

Batch job from first dataset


The first column above are the months and the second column are the total sales

I just need help with that dataset and I soon as I see how this works i will try and to the rest ones. I have read the manuals for DFsort but I couldn't understand much. Thanks for the help

Here's a DFSORT job that does what I think you're asking for:



SORTOUT would have:

Thanks but because I have to read the data from a file, instead of having



can i have ??

Yes, of course (you could have confirmed this by trying it yourself).

I just used DD * to show what the input data looked like. You can use:

//SORTIN DD DSN=SPORTS.TRDATA2,DISP=SHR

You can also use a data set for //SORTOUT instead of SYSOUT=*.

Hello
I used the code you've written but i am getting the following error

09.39.46 JOB05347 $HASP165 SUR00161 ENDED AT TSTMVS01 - JCL ERROR CN(INTERNAL)
***

09.39.46 JOB05347 $HASP165 SUR00161 ENDED AT TSTMVS01 - JCL ERROR CN(INTERNAL)

This a JES message, not a DFSORT message. You need to look at the JES messages to see what's wrong. If you can't figure it out, post your JCL and all of the messages you received here.