Re: Unix shell from trigger(or)SPL

At 07:03 03/06/97 GMT, you wrote: >Is there anyway to use triggers or SPL to shell >out to Unix and run a unix shell? > >We would like a process to create a subprocess(background) whenever >a specific SQL action occurs. > >Anyone one know how, or a where I can look for more information. > >Thanks > Hi Rick, Have a look in the manuals for the SPL command 'system'. This allows you to run a unix command from a stored proc., but be careful - the command will be run with minimal environment settings, so you will need to put the command in a script that sets the appropriate variables for informix etc. (think of it like cron - you have to tell it everything - give it full pathnames for everything, etc). HTH, Richard.