RE: Executing Informix Stored procedure from PB
Posted in 1995
In article <488lfk$ig5@cssun.mathcs.emory.edu>, CRAIG@CHEMISTRY.CHEM.UTAH.EDU wrote: >Pete, > > First, the answer... Your environment variables are not being >set when you execute the system() command from a PowerBuilder called >stored procedure. .. > Now, all this is true when the procedure is called from PowerBuilder. >The difference, however, is the I-Net socket. With the network >connection, no "real" login is ever performed. Therefore, each step >is inheriting a very basic environment. If this is true, then when I-Net creates the sqlturbo processes to handle the request, do they inherit the I-Net environment? If they do, then the answer would be to create the proper environment when I-Net is spawned. I will try to set up an experiment to see if this is the case, unless someone knows one way or the other.