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_reclaim>60 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
-=>
