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

    Question 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
    Location
    Belgium
    Posts
    534
    with the 'system' command
    rws

  3. #3
    Join Date
    Dec 2002
    Location
    Portland, OR, USA
    Posts
    26

    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
  •