Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003

    Question Unanswered: running a unix script using a stored procedure

    Can anyone tell me how to run a unix script in an informix stored procedure? Your help is much appreciated.

  2. #2
    Join Date
    Aug 2002
    with the 'system' command

  3. #3
    Join Date
    Dec 2002
    Portland, OR, USA

    Re: running a unix script using a stored procedure

    Yes, Philip,

    You can use the SYSTEM command, but according to the documentation, this is a one-way call. That is, you can execute shell scripts from inside a stored procedure, but return values are not available to the stored procedure upon completion of the script. So, if you have a bullet-proof script and require absolutely no proof that it executed properly, and the stored procedure does not require anything back from the script to continue on its way, this may be useful to you.

    I have used it once... HTH

    My Doc. reference = Informix Guide to SQL Vol. 2, Chapter 2 (SPL Statements), tested on Informix SE 7.25/RedHat 7.3

Posting Permissions

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