Re: Informix SPL SYSTEM Command Question

ANISHA_VASWANI@HP-SanJose-om1.om.hp.com wrote: : : Running a stored procedure with the SYSTEM command that you suggested : gave me SOMEBODY's env setting wherein the INFORMIXSERVER parameter : was set to garbage. But the weird thing is, I don't know who's env the : stored procedure was reading -- I ran the env command from the UNIX : command line as the person I was logged on as (the same person who : executed the stored procedure and for that matter, created the stored : procedure), and the result on the env was COMPLETELY DIFFERENT from : the one I got by executing the SP. I also checked the env of informix : and root and they didn't match either. So who's env was that?!? : Because I couldn't figure out where the env was being read, I asked : the UNIX sys admin to bring the instance down and back up. Now, : running the same stored procedure revealed that the INFORMIXSERVER was : set to the correct value. And sure enough, the whole thing works : again. Just a guess, but do you start up OnLine in an rc file so that it comes back up automatically when you reboot the system? If so, it's probably whatever environment was active when you started it up. If bringing the instance down and back up gives different env settings, then apparently it wasn't originally initialized the same way. Stored procedures run from the back-end, so they don't inherit your environment (except for maybe some environment variables that your front-end reads and passes to the back-end -- INFORMIXSERVER probably wouldn't be one of them). June ---- June Tong Informix Software ---- ---- Senior Consultant (415) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Oakland ---- * * Standard disclaimers apply * - Please do not send me requests/questions by mail. When I have the knowledge - and time permits, I try to answer questions on comp.databases.informix, but - travel schedule, time, and volume make responding to personal requests - difficult and often slow. Please call your local Informix Technical Support - organization for assistance with technical issues.