SEO

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.

A system call failed in the operating system. The following example
shows a statement that might cause an error:

SYSTEM 'hello';

Make sure that the system command is not trying to run something that
is
not in your path or that is not applicable to the environment.

Make sure that you have provided a user-id and password when
connecting
to the database server. The database server must have the user's
password
in order to execute a command on behalf of that user.

On Windows NT platforms, make sure the following Advanced User Rights
have
been assigned to user "informix": Act as part of the operating system;
Increase quotas; replace a process level token.

-1 Not owner.

An operating-system error code with the meaning shown was unexpectedly
returned to the database server. Check the ownership and permissions
of
files and directories that are used in the current operation. Look for
other operating-system error messages that might give more
information.



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

Hope you can help Me


Regards
Sharm

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
>