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
