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
Example24.348.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.