INFORMIX 4GL PROBLEM

Hi Family, I am facing a problem in INFORMIX 4 GL programme.. I have made a programme which is accessed 4 database.. All 3 database is accessed by their 3 different sqlexeced damon. It is running fine.. But if I want to run that same programme another location of our country then I have to change the dbserver name.. Like in our location sql script is.. select x,y,z from aaa@ccusss But our different location is holding different dbserver name.. Like Bangalore's machine dbserver name is blrsss, Bombay machine dbserver name is bomsss.. So my query is how I can define this dbserver name in any environment variable.. Otherwise I have to compile it different times with different dbserver name. Regards Sandip Samanta

On Wed, 10 Mar 99 17:48:40 +0530, SANDIP SAMANTA <samanta@ccu-sn.IN.DHL.COM> wrote: > > >Hi Family, > >I am facing a problem in INFORMIX 4 GL programme.. I have made a >programme which is accessed 4 database.. All 3 database is accessed >by their 3 different sqlexeced damon. It is running fine.. But if I >want to run that same programme another location of our country then >I have to change the dbserver name.. > >Like in our location sql script is.. > select x,y,z from aaa@ccusss> >But our different location is holding different dbserver name.. Like >Bangalore's machine dbserver name is blrsss, Bombay machine dbserver >name is bomsss.. > >So my query is how I can define this dbserver name in any environment >variable.. Otherwise I have to compile it different times with >different dbserver name. Set an environment variable LOCALSRVR=blrsss In the program: LET h_srvr_nm = fgl_getenv("LOCALSRVR") LET sql_txt = "SELECT x,y,z FROM aaa@", h_srvr_nm PREPARE ... DECLARE ... > > >Regards > >Sandip Samanta Chris