Post by "Nick Elson" <@@@nick@@@.@@@@@@.@@@com@@@>Do you happen to have something like
multiple remote servers defined (possibly
to the same external DBMS server) but
with different connection parameters?
If so, is the question of altering the proxy
to reference a different server maybe?
Yes. Sorry for the ambiguity. My reference to location came from the
documentation (although I should have said "location-string"):
CREATE EXISTING TABLE [owner.]table-name
[ (column-definition, ...) ]
AT *location-string*
I would like to be able, instead of deleting/re-creating a proxy table, to
just alter the location, like:
ALTER EXISTING TABLE table-name
AT location-string
Sometimes I want to go back and forth between dev and test remote servers
without having to delete/re-create them.
Thanks
Spencer
Post by "Nick Elson" <@@@nick@@@.@@@@@@.@@@com@@@>What do you mean by location Spencer?
The location of a proxy table definition
is in the current database. The location
of the remote table is, uh, well ... ~remote~
... as per the remote server definition.
Do you happen to have something like
multiple remote servers defined (possibly
to the same external DBMS server) but
with different connection parameters?
If so, is the question of altering the proxy
to reference a different server maybe?
And/Or what do you expect to be the benefit
of such a feature would be?
Post by Spencer WasdenSQL Anywhere 10.0.1.3619
I haven't been able to find a way to alter the location of a proxy table.
Is there a way? If not, has this been considered as a feature?
Thanks
Spencer