Hi , Somebody could helpme ?

I have a simple sentence like this

system "usr/bin/ls" <--- this instruction is in storeprocedure

when this instruction is executed by superuser informix, it works fine
but if any other user execute the same sentence the code error
return -668 System command cannot be executed.

Thx fyt

Try system "/usr/bin/ls". Also, what are the permission setting for ls ? Which username(s) are explictly connecting to informix that are having this problem - and how are they defined on the unix box ? You also may have to manually set some environment variable in your sp. But try the absolute path and let me know.

Hi;

The user have total permissions, in fact that users make telnets and work with onstat , dbschema etc. every day and don't have any problem, but if they want to use that sp the error -668 followed by the -1 appear, my point is: What are the necessary conditions in the OS
to aceppt operating-systems calls? .

Why only informix can do that and my personal user don´t.

My user can shuttdown the DB and kill users , so I don´t understand.

Thanks for your time.

As rnealejr statet before, you might have to set an evironment. What are the permission for the 'ls' command?

the permissions are:

-r-xr-xr-x

What happens if you create a shell file with permissions 777:

test.ksh
. /usr/<YOURUSER>/.profile
/usr/bin/ls

Instead of executing the /usr/bin/ls, try the test.ksh and see what happens.