Other Remote Operations

In addition to querying and updating data, there are other remote operations that you can perform using the distributed query framework.

Opening a Remote Database

By specifying a remote object in the DATABASE statement, you can open a remote database as in the following examples:

DATABASE dbname@servername; 
DATABASE "//servernam/database";

Creating a Remote Database

You can create a remote database by qualifying the database name with a server name when using the CREATE DATABASE statement.

CREATE DATABASE remfoo@rsys;

Creating a Remote Synonym

You can create a remote synonym for a table in another database or a remote table using a qualified name in the CREATE SYNONYM statement. For example, the following statement creates a synonym for rdb@srsys:rtab:

CREATE SYNONYM myrtab FOR rdb@rsys:rtab;

It is possible for a synonym to exist in both the local and remote server. In the example above, it is possible that rtab is itself a synonym for rdb2@rsys2:rtab2. The chain of synonyms is followed when retrieving catalog information until the physical database and server where the table resides is found. If a synonym ultimately points back to itself, an error is returned.