Mainframe, MVS and zOS Discussion

Along with that, SORT products can also work with VSAM: //STEP1 EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSG DD SYSOUT=* //IN DD DSN=... input-vsam-dataset //TOOLIN DD * COUNT FROM(IN) EMPTY RC4 /* This produces RC as 4, if the input VSAM dataset is empty. Another variation: /STEP1 EXEC PGM=ICET...

DFSORT only really likes sequential datasets, so using it do do this check on a VSAM file isn't doable (unless something has changed recently). What you need is an IDCAMS "PRINT" command: //STEP1 EXEC PGM=IDCAMS //SYSPRINT DD SYSOUT=* //DD1 DD DSN=your.vsam.dataset,DISP=SHR //SYSIN DD * P...

What I want exactly if the file is empty I want to run the second step like this

HI all,

I have a question HOW TO IDENTIFY WEATHER THE KSDS EMPTY OR NOT USING SORT UTILITY.

If your rational is that every UI/UX developers or any other open source technology developer is/are getting paid more, it's not straight forward correct, if someone is getting paid they have done their labor. For instance, just look for the salaries of just Java developers, they are not that good ...

Thanks zum13. This works.

I'll keep posted in case our requirements changes.

What does zum13 means?

Thanks Robert. But it becomes very tough to learn all this.

Probably you want to know which DISP can be used in two steps where at one step it works in OUTPUT mode and in other step as INPUT: It’s MOD but keep in mind when you will run job second time first step will append data at bottom instead of writing altogether new from first line What if I want to o...

Hi,

I have a step that passes data from input to output file my output file should created newly and next my job runs i dont want to change any of the disp parameters..So can please suggest what disp parameter i can use

Sharad Nikam wrote: ↑Sun Jul 16, 2023 2:19 pm Hi,

is it true that BLKSIZE is always multiple of Lrecl in recfm=fb?

If you mention the BLKSIZE as greater than 0, then it should be multiple of LRECL. Else 0 also works.

So that means, mainframes are actually expensive? Yes and no. The dollar cost can be high, but you need to consider that there can be 10,000 or more people using the machine simultaneously. So the per-user cost for a mainframe actually tends to be less than (or equivalent to) the per-user cost of w...

Thank you so much Robert and vasanthz. Will work from here.

Hi All , I need to send the data in a single excel but in different tabs using mainframe. As of now, I'm able to send data in different excel sheet but not in tabs of the same sheet. Is it possible to put data into same excel sheet but in different tabs using IEBGENER or any other utilities ? Thanks

I have a file having state code and some more records in it. I need to find that how many records are there for each state code.The 150-151 colums hold the US state code. Records in dataset are like this: |ST|AGENT:CODE|EFF DATE| ======================== IL |A |021 |20160128| MI |A |002 |20160110| C...