Re: SQR and MVS - Communicating with Op. System

[Jerry Coleman <colemanj@WASHPOST.COM>]

Pasted from the SQR Manual:

#return-status -

Value to be returned to the operating system when SQR exits. May be
set in your report. #return-status is initialized to the "success" return
value for the operating system.





                    Steve Schelske
                    <skschelske@AAAMIC        To:     SQR-USERS@list.iex.net
                    HIGAN.COM>                cc:
                    Sent by:                  Subject:     Re: SQR and MVS - 
Communicating with Op. System
                    "Discussion of
                    SQR, Brio
                    Technology's
                    database reporting
                    language"
                    <SQR-USERS@list.ie
                    x.net>


                    07/07/00 02:56 PM
                    Please respond to
                    sqr-users






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!