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