Re: How to pass servername as vaiable?
I'm not sure this is what you looking for:
Can you get server name from the environment variable.
in .profile files
ISTARSERVNAME="servicename"
in 4gl program
LET servername = fgl_getenv("ISTARSERVNAME")
I hope this help.
______________________________ Reply Separator _________________________________
>Subject: How to pass servername as vaiable?
>Author: INTERNET:jpowell@cv.hp.com at CSERVE
>Date: 4/22/96 1:27 PM
>
>
>Sender: informix-list-owner@rmy.emory.edu
>Received: from rmy.rmy.emory.edu (rmy.rmy.emory.edu [170.140.97.4]) by
>dub-img-1.compuserve.com (8.6.10/5.950515)
> id OAA23621; Mon, 22 Apr 1996 14:05:27 -0400
>Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id
>OAA19444 for susik_lee@united#u#group.ccmail.compuserve.com; Mon, 22 Apr 1996
>14:05:46 -0400 (EDT)
>From: jpowell@cv.hp.com (John Powell)
>Message-Id: <4lgbk9$dia@hpcvsnz.cv.hp.com>
>Subject: How to pass servername as vaiable?
>Date: 22 Apr 1996 16:20:25 GMT
>Reply-To: jpowell@cv.hp.com (John Powell)
>Organization: Hewlett Packard Corvallis Site
>Sender: informix-list-owner@rmy.emory.edu
>To: informix-list@rmy.emory.edu
>X-Informix-List-To: susik_lee@united#u#group.ccmail.compuserve.com
>X-Informix-List-Id: <news.23321>
I need to know how to how to place the name of a server in
a stored procedure variable and then use that variable as
the server name when specifying a fully qualified table name
I would like to go from something like this
select * from mydatabase@myserver:mytable:
to something like this
DEFINE hold_server char(8);
LET holdserver = "myserver";
select * from mydatabase@holdserver:mytable;
________________________________________________________________________
| John Powell |
| Hewlett-Packard Company Phone: 541-715-8389 |
| Inkjet Supplies Business Unit Fax: 541-715-2283 |
| 1040 NE Circle Blvd. E-mail: jpowell@cv.hp.com |
| Corvallis, OR 97330-4200 |
| MS: 633A |
------------------------------------------------------------------------