Hello All!

I have this finally working, but I was wondering if there is a way to
shorten the width of the columns so that they can all fit on one line?  And
also, the customer has requested that the successful column be changed to
completed, missed or failed.  I didn't think this was possible unless I
join 2 tables and then produce the same output.  Is this a correct
assumption?  Thanks!

ANS8000I Server command: 'select entity as node_name, date(start_time) as
date, cast(activity as varchar(10)) as activity, time(start_time) as start,
time(end_time) as end, cast(bytes/1024/1024 as decimal(6,0)) as megabytes,
cast(affected as decimal(7,0)) as files, successful from summary where
start_time>=current_timestamp - 1 day and (entity like 'HM%' or entity like
'PAB%' or entity like 'VMS%' or entity like 'GEOHMKLG%' ) and
activity='BACKUP' order by successful, node_name'

NODE_NAME                    DATE     ACTIVITY          START          END
MEGABYTES         FILES             SUCCESSFUL
------------------     ----------     ----------     --------     --------
---------     ---------     ------------------
HMCH1021               2005-02-09     BACKUP         19:12:14     19:22:03
572          2266                    YES
HMCH1028               2005-02-09     BACKUP         19:08:53     19:13:37
381          2063                    YES
HMCH1147               2005-02-09     BACKUP         19:12:13     19:42:06
384          2157                    YES
HMCH1150               2005-02-09     BACKUP         19:10:29     19:17:45
70           329                    YES
HMCH1160               2005-02-09     BACKUP         19:12:18     19:15:14
281          1987                    YES
HMCH1161               2005-02-09     BACKUP         19:09:25     19:13:47
187           221                    YES
********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************