Re: SQR and MVS - Communicating with Op. System

[Steve Schelske <skschelske@AAAMICHIGAN.COM>]

If you have access to FileAid, it gives a return code 8 if the input (DD01)
file is empty.

A subsequent job step could then run to delete the output dataset if the
FileAid job returns 8.

Just out of curiosity, is there a pressing reason that you need to delete
these datasets?

-----Original Message-----
From: Discussion of SQR, Brio Technology's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Dave Thorburn
Sent: Thursday, July 06, 2000 1:49 PM
To: SQR-USERS@list.iex.net
Subject: SQR and MVS - Communicating with Op. System


All,

I have a problem with SQR and MVS JCL.  The output dataset
from the SQR has been defined in the JCL and works perfectly.

The Problem is that when the SQR creates no output records
I am left with an empty dataset cataloged on MVS.

Is there a way to pass information from the SQR to MVS that
could be used to trigger a subsequent Job Step to delete the
dataset    -or-

Can someone suggest a way to resolve this situation without
writing a COBOL program to check for a null dataset?

How about MVS Utilities - Has any one used any of the 'IEB'
or 'IEH' utilities to determine if a dataset is empty?

Thanks,

Dave


----------------
Sent from a WebBox - http://www.webbox.com
FREE Web based Email, Files, Bookmarks, Calendar, People and
Great Ways to Share them with Others!