RE: -668 error

David, Here is what the programmer said: Since the program doesn't check the return value from the program, but instead checks the value in a table, I am not returning a value through the EXIT PROGRAM statement. Instead the program simply exits out via the END MAIN. Thanks, Dianne -----Original Message----- From: David Williams [mailto:djw@smooth1.demon.co.uk] Sent: October 22,1999 5:53 PM To: informix-list@iiug.org Subject: Re: -668 error In article <7uqr70$fao$1@news.xmission.com>, dianne.pendleton@autodesk.com writes > >Hi all. IDS 7.31.UC2. HP-UX 10.20. > >We have a stored procedure that does some stuff and then makes a SYSTEM call >to run a .4ge program. Most of the time it works. But sometimes we get a >-668 error and the words not owner. > > >-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. > > >The stored procedure is always called by the same userid. There is not a >problem with permissions or ownership. If it was, it would error out >everytime. Does anyone know what might cause this scenario? An >intermittent failure of a SYSTEM call? > Doee the 4ge do an EXIT PROGRAM 0 END MAIN or just let the exit value from the process be undefined (i.e. random?) >Thanks, Dianne -- David Williams