sharmila.kuthubdeen@gmail.com wrote:
> Hi All
>
> We are using HP- UX B.11.00 U 9000/800 and Informix Dynamic Server
> 2000 Version 9.21.UC2
> I was trying to run a SYSTEM command inside a procedure and its called
> in a trigger and the procedure runs but crashes where the SYSTEM
> command is with the following error
>
> system "mailx -s '" || v_subject || "' " || v_spvalue || "</tmp/'" ||
> v_filename || "' ";
>
>
> EFACS X-Pro ERROR : update salesitems file
> -668 syntax command cannot be
> executed.
> -1 Not owner
>
>
> and the error described as follows
>
>
> -668 System command cannot be executed.

-668 either means that the system command couldn't be executed, or that
it was executed but it didn't return 0. That status it returned is in
the isam code.

The error message is wrong, basically.

>
> [snip finderr]
>
> -1 Not owner.

.... so your mailx returned 1. For -668, it doesn't mean 'not owner'.

>
> [snip]
>
> Checked the permissions in the file /directory and its fine . Also
> when I logged in as informix the procedure runs without any problem.

Does your non-informix user have a home directory?

>
> Hope you can help Me
>
>
> Regards
> Sharm
>