Hi To All
Did is a way to get a clean output from a macro just the result for further
programming (want just the data ….) I think I saw once an answer about
this.
When running my macro I got in the output my select command and dash:
ANS8000I Server command: 'select entity as " " , cast(sum(bytes/1024/1024)
as decimal(10,3)) as " ", substr(cast(min(start_time) as char(26)),1,19) as
" ", cast(substr(cast(max(end_time)-min(start_time) as
char(20)),3,8) as char(8)) as " " from summary where
date(Start_time)=current date - 1 days and time(start_time)>'18:00:00' and
activity='BACKUP' group by entity'
------------------ ------------ ---------------------- --------
EXCHANGE1 57767.095 2004-01-12 22:07:18 01:37:19
HIGHLEARN2K 2750.848 2004-01-12 22:30:05 00:13:38
My TSM server version is 5.1.8 on Windows.
Regards
Robert Ouzen
E-mail: rouzen AT univ.haifa.ac DOT il
|