Re: TSM on OS/390 and SQL Question.

[John Naylor]

Gene,
You can specify a DD statement in your jcl for an output file
eg
//DSMOUTDD DSN=JNAYL0R..ADSM.BACKUP.D010606,
//  DISP=(NEW,KEEP),UNIT=3390,SPACE=(CYL,(1,1)),
//  DCB=(RECFM=VB,LRECL=250,BLKSIZE=25000)

//INPUTDD  *
 RUN CHECK_TOTAL_BACKUP   DD:DSMOUT






Gene Walters [EMAIL PROTECTED] on 06/06/2001 03:46:10 PM

Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED]

To:   [EMAIL PROTECTED]
cc:(bcc: John Naylor/HAV/SSEG)
Subject:  TSM on OS/390 and SQL Question.



I'm running TSM on OS/390 2.9.  When i do an SQL in a batch job, I want to use 
and  signs.  however, TSM thinks that I am wanting to redirect output to a
file.  Is there a way to get around this?

Thanks






**
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric and Southern Electric are trading names of
Scottish and Southern Energy Group.
**

Re: TSM on OS/390 and SQL Question.

[Alan Davenport]

It's as simple as NOT putting spaces next to the  and  signs. I use
this script to count the amount of tapes eligible for reclamation:

select count(volume_name) as carts from volumes where pct_reclaim60 and
stgpool_name='TAPEPOOL'

If I were to have a space next to the  it will not work but by running it
together it does!

  Al


-=-Original Message-
-=From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
-=Sent: Wednesday, June 06, 2001 10:46 AM
-=To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
-=Subject: TSM on OS/390 and SQL Question.
-=
-=
-=From: [EMAIL PROTECTED]
-=To: [EMAIL PROTECTED]
-=Date: Wed, 6 Jun 2001 10:46:10 -0400
-=Subject: TSM on OS/390 and SQL Question.
-=
-=I'm running TSM on OS/390 2.9.  When i do an SQL in a batch job,
-=I want to use  and  signs.  however, TSM thinks that I am
-=wanting to redirect output to a file.  Is there a way to get around this?
-=
-=Thanks
-=