DEFINE SCRIPT  QNOCC_N DESC="[ADM] Report node N totals"
UPDATE SCRIPT  QNOCC_N "select -"
UPDATE SCRIPT  QNOCC_N " cast(coalesce(sum(num_files),0) as decimal(9,0)) ""# Files""-"
UPDATE SCRIPT  QNOCC_N " , cast(coalesce(sum(logical_mb)/1024.,0) as decimal(9,2)) ""GB logical""-"
UPDATE SCRIPT  QNOCC_N " , cast(coalesce(sum(physical_mb)/1024.,0) as decimal(9,2)) ""GB physical""-"
UPDATE SCRIPT  QNOCC_N " , upper('$1') ""Node ..........................""-"
UPDATE SCRIPT  QNOCC_N "from occupancy -"
UPDATE SCRIPT  QNOCC_N "where node_name=upper('$1')-"
UPDATE SCRIPT  QNOCC_N " and stgpool_name in (select -"
UPDATE SCRIPT  QNOCC_N "  stgpool_name from stgpools where pooltype='PRIMARY')"