Hi, if i use tha API can i use queries like "select cast(v.volume_name as
char(9))as volume,cast(v.status as char(7))as status,cast(v.access as
char(9))as access,cast(v.stgpool_name as char (9))as
stgpool,cast(v.est_capacity_mb/1024 as decimal(5,2)) as GB,cast(pct_utilized as
decimal(4,1))as util from libvolumes as l,volumes as v where
l.volume_name=v.volume_name order by stgpool,status,util" or "SELECT
AVAIL_SPACE_MB,PCT_UTILIZED,CACHE_HIT_PCT, LAST_BACKUP_DATE FROM DB"?
Tanks in advance,
Amilcar
|