Re: HELP !! Stored procedures

Leonid Ilyevsky writes: |> |> I am using now INFORMIX-ONLINE 5.01 in Sun-OS. Experimenting with stored |> procedures, I decided to try the SYSTEM command. The result was: |> SQL error = -668 ISAM error = -1 , |> which means permission problems in UNIX file system. I checked my |> permissions, then |> I tried to login as "root" and execute the same procedure. I also tried |> different |> UNIX commands, like |> SYSTEM "echo > /dev/null" |> or even |> SYSTEM "" |> which are not supposed to require any permissions. The result was always |> the same. Take a look at the file sgidsh in $INFORMIXDIR/bin, and be sure it has the following permissions and ownership: -rwsr-sr-x 1 root informix 172032 Jun 22 1992 sgidsh sgidsh is used to execute the system command in SPL (so the correct user and group ids are maintained, since the server process fiddles with them). Dave Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney