Re: system call from stored procedure

In article <70li2a$9ke@venice.dh.trw.com>, steve.cook@trw.com (Steve Cook) wrote: > I have a stored procedure that does a system call to execute a program. > When > the system call invokes a shell, the environment variables from my > informix > login are not passed as I thought they would. One of the environment > variables > points to a needed shared library, so it is required in order to run. > > [I'm running online, if that makes a difference] > > Any ideas? Thanks in advance... > > > The SPL does not source any of the standard login files where most of the environment is set. It might source /etc/profile but I can't remember. AFAIK you can set things in informix.rc but I believe this is only source for network connections. I have always found the best way is to source a known environment at the top of the script. Paul Watson # I don't suffer from WF Software Ltd. # stress, I'm just Tel. (+44) 1436 674729 # a carrier Fax. (+44) 1436 678693 # www.wfsoftware.co.uk