Informix

If you get 9635: An attempt has failed to convert an opaque type into another type without a cast function. Just remove the order by

Amit,. Run this against the sysmaster database... SELECT q1.*, (100 * size_kb / dbs_size) :: DECIMAL(5,2) AS percent FROM ( SELECT t2.owner [1,8], t2.dbsname [1,18] AS database, t2.tabname [1,22] AS table, ...

Why oh why didn't occur to me to check in the sysmaster? ^_^ Thanks Art! R ------------------------------ Ramon Rey ------------------------------