Re: Select statement output
2005-04-20 16:10:29
Joni,
Try this:
select count(*) "Full/Filling Volumes" from volumes where status in
('FULL','FILLING')
Etc.
Steve Schaub, Network Engineer
BlueCross BlueShield of Tennessee
Steve_Schaub AT bcbst DOT com
423-752-6574 (office)
423-785-7347 (cell)
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Joni Moyer
Sent: Wednesday, April 20, 2005 2:42 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Select statement output
I have defined the following script to find the status of tapes.
Name VOLUME_USAGE
Description -
Last Update Date/Time 2005-04-20 14:40:07.000000
Last Update by (administrator) LIDZR8V
Managing profile -
Lines:
/* Volumes that are full & filling */
select count(*) volume_name from volumes where status in ('FULL','FILLING')
/* Volumes that are empty */
select count(*) volume_name from volumes where status='EMPTY'
/* Volumes that are pending */
select count(*) volume_name from volumes where status='PENDING'
I get the following results:
VOLUME_NAME
-----------
529
VOLUME_NAME
-----------
0
VOLUME_NAME
-----------
160
How do I get a heading of Full/Filling Volumes to appear above the first
column? Empty to appear above the second and Pending above the third?
Thank you in advance!
********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************
Please see the following link for the BlueCross BlueShield of Tennessee E-mail
disclaimer: http://www.bcbst.com/email_disclaimer.shtm
|
|
|