Oninit cdi / Archive
Talk to an expert →

Linux fgl_getenv

Posted in 2003

Topics: Stored Procedures & SPL

Glen Johnson — — source: Usenet: comp.databases.informix

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.

↪ replying to Glen Johnson
John Carlson — — source: Usenet: comp.databases.informix

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...

↪ replying to Glen Johnson
Jonathan Leffler — — source: Usenet: comp.databases.informix

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/

↪ replying to Jonathan Leffler
Glen Johnson — — source: Usenet: comp.databases.informix

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/ >