Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    5

    Question Unanswered: System Command Error!

    TRY TO RUN A UNIX SCRIPT IN A STORED PROCEDURE USING THE SYSTEM COMMAND. I GOT THIS ERROR. SQL statement error number -668. System Command cannot be executed. System error number -1. Not owner. The user login name that I use to create the procedure is the same login name that I use to run my program. I also did the chmod 777 * to all the files. Also I did Grant the permission to public in the sql.

    My code in the procedure is this : SYSTEM './u/stand/test.sh'
    Is it correct ? Did I forgot to do something else?
    Your help is much appreciated. tnx.

  2. #2
    Join Date
    Apr 2003
    Location
    Phoenix, AZ
    Posts
    177
    First, I'll assume that the script you are trying to execute runs problem-free from which ever userid invoked the Informix instance (ie. informix or root).

    Second, as opposed to invoking the script as an executable (ie. ./test.sh) you might try invoking a shell to run the script (ie. sh ./test.sh). The environment that the system command executes in might not have a proper default shell "wired" into it.
    Fred Prose

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •