ADSM-L

Re: TSM on OS/390 and SQL Question.

2001-06-06 12:41:33
Subject: Re: TSM on OS/390 and SQL Question.
From: Alan Davenport <alan.davenport AT SELECTIVE DOT COM>
Date: Wed, 6 Jun 2001 12:40:09 -0400
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


<Prev in Thread] Current Thread [Next in Thread>