Re: LTO Volume

[Andreas Priebe]

Hi Richard,
The Select is tried-and-true, and works well.
On one of my TSM servers it gives me an SQL error due
to the formmating:
ANR2948E The value '381468.0' can not be assigned or converted to SQL
data type
DECIMAL(6,1).
                                 |
         ........................V......................................
         ZED as "PCT UTIL" , DEC(EST_CAPACITY_MB,6) AS "MB_CAPACITY" , C
ANS8001I Return code 26.
As the original poster mentioned LTO, maybe it would be better to
change this part to
DEC(EST_CAPACITY_MB,7)
(until the next big step in increasing type capacity :-) )
Greetings,
Andreas