Hi Iain

tsm: ABZBKUP001>SELECT STGPOOL_NAME AS "        STORAGE POOL         ",
-
cont>   CHAR(VOLUME_NAME,6) AS "VOLNAME", PCT_UTILIZED as "PCT UTIL", -
cont>   DEC(EST_CAPACITY_MB,7) AS "MB_CAPACITY", CHAR(ACCESS,11) AS
"ACCESS", -
cont>   LEFT(CHAR(LAST_WRITE_DATE),19) AS "LAST_WRITE_DATE    " -
cont>   FROM VOLUMES WHERE STATUS='FILLING' ORDER BY STGPOOL_NAME
ANR2948E The value '4096000.0' can not be assigned or converted to SQL
data type DECIMAL(7,1).

                                 |
         ........................V......................................
         ED as "PCT UTIL",   DEC(EST_CAPACITY_MB,7) AS "MB_CAPACITY", CH

ANS8001I Return code 26.

Yours said: value '4096000.0', mine said: value '381468.0', so counting
megabytes suggests, maybe in your case it should be at least

DEC(EST_CAPACITY_MB,8)

?

Regards,

Andreas