Stored procedures and error message 668
Posted in 1997
Topics: Installation, Setup & Upgrades, Stored Procedures & SPL, Platform-Specific Issues
=20
Hi !
=20
Are using Informix OnLine 7.10 and 7.22 on a number if HP boxes ,all=20
of them running HP-UX 10.20.
=20
Our problem is that on just one of them the "SYSTEM" command from SP=20
will give error 668 System command .... and 1 Not owner. We are using=20
the same stored procedures on all boxes and the rest of the setup=20
should be the same.
There is of course some difference, but I would appreciate any hints=20
where to look.=20
=20
The problem started when we upgraded to HP-UX 10.20, was in 7.10 and=20
now 7.22.
=20
=20
An interesting thing is that if I execute the procedure as "informix"=20
it will work, normal users will fail.
=20
Have compared environment variables between the boxes, and can't find=20
any differences that should give this problem, all INFORMIX-variables=20
set.
=20
Are using a simple test procedure
=20
create procedure test(x char(200))
=20
system t; =20
end procedure;
=20
and execute it with for example "execute procedure t("/bin/env >=20
/tmp/env") to get the environment, Works for "informix" but nobody=20
else !.
=20
=20
Any information on where to look ??
=20
TIA
=20
Ulf