CREATE SERVER (Define a foreign server)
Function
Defines a foreign database as a foreign server.
Privileges
Format
CREATE SERVER foreign-server-name |
Operands
Specifies the name of the foreign database that HiRDB accesses.
The specified name must be a name that can uniquely identify a server within HiRDB or a foreign server. The foreign server name specified in this operand is for HiRDB to identify a foreign database; it can be different from the actual name of the foreign database.
For server-type and server-version, specify the server type and server version of the DBMS to be accessed.
The following server types and server versions are available:
DBMS | Server type | Server version |
---|---|---|
XDM/RD E2#1 | XDMRD | 6.0 |
HiRDB Version 5.0 | HIRDB | 5.0 |
HiRDB Version 6 or later | HIRDB | 6.0 |
ORACLE 8i | ORACLE | 8.1.5#2 |
ORACLE 9i | ORACLE | 9.2 |
ORACLE 10g | ORACLE | 10.1 |
DB2#3 | DB2_UDB_OS390 | 6.0 |
Specifies the following options on foreign databases; options cannot be specified in duplicate.
Common rules
Note