Hi
I have run compressions on many tables in my database, always running them
from the sysadmin database using dbaccess. However, I have a table which is
owned by a different user (sapr3), and I cannot get the following to work .
EXECUTE FUNCTION task("table estimate_compression","table","database","owner")
It says the table doesn't exist ....
SCHAPI ERROR:fr1:sapr3.vbbe-No such table
If I do a
select * from database:owner.table that does work
The other tables I have compressed are owned by informix.
regards
Jim