Good suggestion, Andreas, now that we're getting into "terrorbytes".
thanks, Richard Sims
On Mar 7, 2005, at 8:28 AM, Andreas Priebe wrote:
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
