How to pass servername as vaiable?
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 |
------------------------------------------------------------------------