Name
REPL_SERVER_NAME — Return bi-directional snapshot replication server name for specified DSN
Synopsis
varchar
REPL_SERVER_NAME
(
|
in
dsn
varchar
); |
Description
This function should be used to determine bi-directional snapshot replication server name.
Parameters
item
Dsn is a data source name.
Return Types
REPL_SERVER_NAME() returns remote server name which can be used in
calls to REPL_CREATE_SNAPSHOT_SUB() ,
REPL_DROP_SNAPSHOT_SUB() and
REPL_INIT_SNAPSHOT_SUB() functions.
Examples
Example 24.373. Obtaining replication server name
The following statement demonstrates obtaining replication server name for server with DSN 'localhost:1121':
SQL> select REPL_SERVER_NAME ('localhost:1121');
callret
VARCHAR
_______________________________________________________________________________
demoserver2
1 Rows. -- 4 msec.