Stored procedure error: System command cannot be executed [Archive]

View Full Version : Stored procedure error: System command cannot be executed

stanleychong

03-25-02, 04:22

Dear all,

I have written a stored procedure to write a file to a certain path using the "system" command, which operates in the solaris environment.

I have confirmed that both the informix and my ID is able to write files directly into the path, i.e. by typing "echo 123 > file.txt", but when i
execute the stored procedure in dbaccess, it returns an error
"System command cannot be executed", "Not owner".

Any solutions?

Stanley

townscream

03-26-02, 08:10

please , show us your username in the passwd file
and also ls -l output from directory and other files
in the directory you are trying to write to

rnealejr

04-01-02, 16:06

Have you tried to blanket the permissions (777) in Unix ? Also, just try something simple like copying a file using absolute paths.