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.