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