Re: Stored procedure executing system calls

Jonathan Myatt wrote: > > Try dumping the environment to a file during one of these system calls > > and see what inspecting the entrails reveals. > > Hi Peter. > > I've tried this. In fact, I have a stored procedure which does just > > system 'env > /tmp/env.out' > > and all I get is a very small subset of the environment variables I > would expect to see. It's almost as if online only allows a subshell > to see those env vars which it considers relevant. I've tried setting > them in the user running the script's .profile, and in Informix's > .profile, and I've even bounced the instance but still the same. > > > You are remembering to flag environment variables for export, > > I presume? > > Indeed I am. > > Any more ideas? I'm stumped... > > Jon. Is the environment the same as /etc/profile. Are you explicitly calling the shell type at the top of the script? -- Paul Watson # WF Software Ltd # I don't suffer from stress - Tel: +44 1436 674729 # I'm a carrier. Fax: +44 1436 678693 # www.wfsoftware.co.uk #