Hi all,

Can someone tell me if there is any other way of automagically getting around
this problem?

select bytes_size, decimal(bytes_free,10,2), decimal(percent_used,10,2) from
info_tablespace

SQL0413N Overflow occurred during numeric data type conversion.
SQLSTATE=22003

I know the error has to do with decimal(bytes_free,10,2), i.e., I got some
values that need more than 10 characters, so if I change this to
decimal(bytes_free,20,2), I don't get the error message.

Is there any way that I can tell DB2 automagically use whatever number is ideal
instead of hard-coding 20 to the decimal function? Reason is, for now, 20 is
acceptable, but in the future, if it needs more than 20 characters or digits,
then my script will error out again.

Thanks in advance.








DB2 & UDB email list listserv db2-l LazyDBA home page