DEFINE SCRIPT  QTRECL_V DESC="[ADM] Report volume utilization & PCT_RECLAIM"
UPDATE SCRIPT  QTRECL_V "select -"
UPDATE SCRIPT  QTRECL_V " cast(volume_name as varchar(8)) ""Volume"",-"
UPDATE SCRIPT  QTRECL_V " cast(stgpool_name as varchar(16)) ""Pool"",-"
UPDATE SCRIPT  QTRECL_V " cast(substr(status,1,8) as varchar(8)) ""Status"",-"
UPDATE SCRIPT  QTRECL_V " date(last_write_date) ""Last written"",-"
UPDATE SCRIPT  QTRECL_V " cast(((pct_utilized*est_capacity_mb)/100) as decimal(10)) ""MB used"",-"
UPDATE SCRIPT  QTRECL_V " pct_reclaim -"
UPDATE SCRIPT  QTRECL_V "from volumes -"
UPDATE SCRIPT  QTRECL_V "where (volume_name like upper('$1')) and (pct_reclaim is not null)"