The use of upper/lower functions in SQL statements can save a lot of
grief!
>>> [EMAIL PROTECTED] 11/30/2004 8:47:29 AM >>>
On Nov 30, 2004, at 8:40 AM, James Choate wrote:
> The scratch column is case sensitive. Looks like the yes & no are
> capitalized.
>
> The status column is YES|NO|NULL
Su
On Nov 30, 2004, at 8:40 AM, James Choate wrote:
The scratch column is case sensitive. Looks like the yes & no are
capitalized.
The status column is YES|NO|NULL
Such things are prone to change over time: in some releases only
the initial character is capitalized. We often have to find out
the par
> Matt Chan
>
>
> "Stapleton, Mark" <[EMAIL PROTECTED]>
> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
> 23/11/2004 07:23 AM
> Please respond to
> "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
>
>
> To
> [EMA
: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
23/11/2004 07:23 AM
Please respond to
"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To
[EMAIL PROTECTED]
cc
Subject
Re: Select Statement Help for Volume Breakdown
There are no scratch tapes in storage pools. A tape volume
/2004 07:23 AM
Please respond to
"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To
[EMAIL PROTECTED]
cc
Subject
Re: Select Statement Help for Volume Breakdown
There are no scratch tapes in storage pools. A tape volume only exists
in a storage pool when it contains client
[mailto:[EMAIL PROTECTED] On
> >Behalf Of Nancy L Backhaus
> >Sent: Monday, November 22, 2004 12:59 PM
> >To: [EMAIL PROTECTED]
> >Subject: Select Statement Help for Volume Breakdown
> >
> >How do I combine these two scripts? I want to be able to see
> >a breakdo
: Dist Stor Manager [mailto:[EMAIL PROTECTED] On
>Behalf Of Nancy L Backhaus
>Sent: Monday, November 22, 2004 12:59 PM
>To: [EMAIL PROTECTED]
>Subject: Select Statement Help for Volume Breakdown
>
>How do I combine these two scripts? I want to be able to see
>a breakdown
&g
How do I combine these two scripts? I want to be able to see a breakdown
by stg pools & breakdown of scratch/privates in the stgpools.
select status, count(*) from libvolumes where library_name = 'LTOLIB'
group by status
I have this..but, I really want to see the scratch/private breakdown?
s
