www.openlinksw.com
docs.openlinksw.com

Book Home

Contents
Preface

Virtuoso Functions Guide

Administration
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
RDF data
Remote SQL Data Source
Replication
repl_add_cr
repl_add_dav_cr
repl_add_snapshot_cr
repl_create_snapshot...
repl_create_snapshot...
repl_drop_snapshot_p...
repl_drop_snapshot_s...
repl_grant
repl_init_copy
repl_init_snapshot
repl_publish
repl_pub_add
repl_pub_init_image
repl_pub_remove
repl_revoke
repl_sched_init
repl_server
repl_server_name
repl_snp_server
repl_stat
repl_subscribe
repl_unpublish
repl_unsubscribe
repl_update_snapshot
repl_disconnect
repl_new_log
repl_purge
repl_server_rename
repl_status
repl_sync
repl_sync_all
repl_text
repl_this_server
sub_schedule
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web Server & Internet
XML
XPATH & XQUERY

Functions Index

REPL_CREATE_SNAPSHOT_SUB

Create bi-directional snapshot subscription to an existing publication.
None REPL_CREATE_SNAPSHOT_SUB (in server varchar, in item varchar, in type integer);
Description

This procedure should be used to create a bi-directional snapshot subscription.

Note:
This function should be run on publisher.
Parameters
server – The name of the server defined with REPL_SNP_SERVER(). The name of the server can be obtained using REPL_SERVER_NAME() function.
item – Item is a DAV collection or table name.
type – Type is used to denote the type of Item: 1 if item is a DAV collection, or 2 if item is a table name.
Return Types

None.

Examples
Creating bi-directional snapshot subscription

The following statement creates bi-directional snapshot subscription of server with DSN 'localhost:1121' for table 'Demo.demo.Shippers':

SQL> DB.DBA.REPL_CREATE_SNAPSHOT_SUB (REPL_SERVER_NAME ('localhost:1121'), 'Demo.demo.Shippers', 2);
      

The following statement creates bi-directional snapshot subscription of server with DSN 'localhost:1121' for DAV collection '/DAV/doc':

SQL> DB.DBA.REPL_CREATE_SNAPSHOT_SUB (REPL_SERVER_NAME ('localhost:1121'), '/DAV/doc', 1);
      
See Also

REPL_CREATE_SNAPSHOT_PUB()

REPL_DROP_SNAPSHOT_SUB()

REPL_DROP_SNAPSHOT_PUB()

REPL_INIT_SNAPSHOT()

REPL_UPDATE_SNAPSHOT()

REPL_SNP_SERVER()

REPL_SERVER_NAME()