Re: System call in a stored procedure

Hi I too had faced the same problem with Informix 7.11 in HP -UX 9.0. When I asked customer support, they gave me a work around which didn't work. Upon pursuing the same problem again, they asked me to upgrade my version of Informix as the bug has been fixed in the later version. Harinath Venkata Amy Cotter Wrote : }From: Amy Cotter <amy_cotter@administaff.com> }Received: from x9.boston.juno.com (x9.boston.juno.com [205.231.100.25]) } by m21.boston.juno.com (8.8.6.Beta0/8.8.6.Beta0/2.0.kim) with ESMTP id }QAAAA24046 } for <vhari@juno.com>; Fri, 27 Jun 1997 16:52:41 -0400 (EDT) }Received: from rmy.rmy.emory.edu (rmy.rmy.emory.edu [170.140.97.4]) } by x9.boston.juno.com (8.8.6.Beta0/8.8.6.Beta0/2.0.kim) with ESMTP id }QAAAA19405 } for <vhari@juno.com>; Fri, 27 Jun 1997 16:52:39 -0400 (EDT) }Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id }PAA13706 for informix-list-out; Fri, 27 Jun 1997 15:55:01 -0400 (EDT) }Return-path: <ilist@rmy.emory.edu> }Reply-To: Amy Cotter <amy_cotter@administaff.com> }To: informix-list@rmy.emory.edu }Date: Fri, 27 Jun 1997 13:44:25 -0500 }Subject: System call in a stored procedure }Message-ID: <33B408C7.74F7@administaff.com> } }I am trying to execute a system command from a stored procedure. It }works fine when executed by user informix. All other users receive a }-668 error (system command cannot be executed) from Informix, with a -1 }error (not owner) from AIX. I've made sure that if I'm manipulating }files, the permissions are OK. }The system command always fails no matter what I place in "" ie, }SYSTEM "id>/tmp/id.out" ; }SYSTEM "cp /tmp/a /tmp/b" ; }SYSTEM "cp $HOME/a $HOME/b" ; }I'm running Online 7.12 on AIX v4.1.5. }Any suggestions would be greatly appreciated! Thanks. }