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