Re: Informix equivalent to Oracle dbms_pipe?

Mark Smith wrote: > > Is there a (free?) Informix equivalent to the Oracle dbms_pipe > package? > > The dbms_pipe package allows a pipe-like connection from a stored > procedure to a Unix process. It's nice for being able > to initiate downstream processes based on trigger firings and such. > > Thanks, > > MarkUse the SYSTEM command SYSTEM "/usr/bin/lp file1" will issue a command to print file1, be warned that the environment may be undefined so it is best to set all environment variables that may be used. I generally call a UNIX script that sets the environment and calls the command(s) that I wish to execute. There is no need for a server process to be running, it seems to operate in a similar way to the Oracle HOST command. Peter Brueton