Script broken after informix 11.5 upgrade. We recently let go our informix guy and I'm attempting to fix a broken script while in between database people. If anybody can see as to why this script doesn't work anymore I would be eternally greatful.
execute_sql sysmaster \
select b.name\[1,20\], \
sum\(chksize\) size, \
round\(100 - \(\(sum\(nfree\) \/ sum\(chksize\)\) \* 100\)\) \
round\(\(sum\(nfree\) \/ sum\(chksize\)\) \* 100\) \pct_avail \
from syschunks a, sysdbspaces b \
where a.chknum \= b.dbsnum \
group by 1 order by 1;
I dont know "execute_sql" but the statement is correct
round(100 - ((sum(nfree) / sum(chksize)) * 100))
round((sum(nfree) / sum(chksize)) * 100) pct_avail
from syschunks a, sysdbspaces b
where a.chknum = b.dbsnum
group by 1 order by 1;' | dbaccess sysmaster
Can you give me an error code or something like this?