Linux fgl_getenv
Glen Johnson got error 674 (routine fgl_getenv cannot be resolved) calling fgl_getenv in a stored procedure on IDS 9.30.UC3 Linux. John Carlson and Jonathan Leffler explained it is an I4GL function, not available in SPL; a C or Java UDR would be needed and would only see the server's environment. Glen's last question, what to use instead, got no answer.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.
On Tue, 18 Nov 2003 18:26:17 GMT, "Glen Johnson" <glen@csisoft.com> wrote: >Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do >something before I can use the fgl_getenv call in a stored procedure? When >I try I get 674: Routine (fgl_getenv) can not be resolved. > fgl_getenv is a built-in 4gl function, I believe...
Glen Johnson wrote: > Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do > something before I can use the fgl_getenv call in a stored procedure? When > I try I get 674: Routine (fgl_getenv) can not be resolved. As John Carlson said, fgl_getenv() is an I4GL function. So, to be able to call it from a stored procedure, you'd have to create a (C or Java) UDR which does the right job. Of course, even if you had it, you'd only get a weird mixture of the server's own environment and some small portions of the user's environment - at best. Most likely, you'd only see what the server had in its environment. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/
Thanks, what do I use within a stored procedure to get environmental variables then? A system call to getenv? "Jonathan Leffler" <jleffler@earthlink.net> wrote in message news:fIDub.6590$n56.5976@newsread1.news.pas.earthlink.net... > Glen Johnson wrote: > > > Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do > > something before I can use the fgl_getenv call in a stored procedure? When > > I try I get 674: Routine (fgl_getenv) can not be resolved. > > As John Carlson said, fgl_getenv() is an I4GL function. So, to be > able to call it from a stored procedure, you'd have to create a (C or > Java) UDR which does the right job. > > Of course, even if you had it, you'd only get a weird mixture of the > server's own environment and some small portions of the user's > environment - at best. Most likely, you'd only see what the server > had in its environment. > > -- > Jonathan Leffler #include <disclaimer.h> > Email: jleffler@earthlink.net, jleffler@us.ibm.com > Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/ >