Re: ps -f

> system("ps -f >> /tmp/testout"); > end procedure > > The grammar may not be absolutely correct, but the message is > there. The first three system calls work like a champ. The fourth, > gets a 668 system command cannot be executed, 1 not owner. > > What the heck is the problem? This is one of those 'my life ends > until it works' deals. If you have a solution, please post or > email me at the email listed below. Thanks, and please help me. To save you from dying I'll post a fast response without investigation. This is almost definitely due to the fact that a Stored Procedure is run within the engine. In other words it is run by tbinit not by sqlturbo. tbinit has a ppid of 1 and is owned by informix not by the user running the stored procedure so ps fails. Best bet would be to create a string along the lines of let p = "ps -fu" || user || " >>/tmp/" || user || "ps" system p I hope this is right! Cheers - Jim