<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html> <head profile="http://internetalchemy.org/2003/02/profile"> <link rel="foaf" type="application/rdf+xml" title="FOAF" href="http://www.openlinksw.com/dataspace/uda/about.rdf" /> <link rel="schema.dc" href="http://purl.org/dc/elements/1.1/" /> <meta name="dc.title" content="Function: REPL_PUB_ADD - Virtuoso Functions Guide" /> <meta name="dc.subject" content="Function: REPL_PUB_ADD - Virtuoso Functions Guide" /> <meta name="dc.creator" content="OpenLink Software Documentation Team ; " /> <meta name="dc.copyright" content="OpenLink Software, 1999 - 2009" /> <link rel="top" href="index.html" title="OpenLink Virtuoso Universal Server: Documentation" /> <link rel="search" href="/doc/adv_search.vspx" title="Search OpenLink Virtuoso Universal Server: Documentation" /> <link rel="parent" href="functions.html" title="Chapter Contents" /> <link rel="prev" href="appendixa.html" title="Appendix" /> <link rel="next" href="functions.html#.html" title="" /> <link rel="shortcut icon" href="../images/misc/favicon.ico" type="image/x-icon" /> <link rel="stylesheet" type="text/css" href="doc.css" /> <link rel="stylesheet" type="text/css" href="/doc/translation.css" /> <title>Function: REPL_PUB_ADD - Virtuoso Functions Guide</title> <meta http-equiv="Content-Type" content="text/xhtml; charset=UTF-8" /> <meta name="author" content="OpenLink Software Documentation Team ; " /> <meta name="copyright" content="OpenLink Software, 1999 - 2009" /> <meta name="keywords" content="" /> <meta name="GENERATOR" content="OpenLink XSLT Team" /> </head> <body> <div id="header"> <a name="fn_repl_pub_add" /> <img src="../images/misc/logo.jpg" alt="" /> <h1>22. Virtuoso Functions Guide - REPL_PUB_ADD</h1> </div> <div id="navbartop"> <div> <a class="link" href="functions.html">Chapter Contents</a> | <a class="link" href="fn_repl_publish.html" title="REPL_PUBLISH">Prev</a> | <a class="link" href="fn_repl_pub_init_image.html" title="REPL_PUB_INIT_IMAGE">Next</a> </div> </div> <div id="currenttoc"> <form method="post" action="/doc/adv_search.vspx"> <div class="search">Keyword Search: <br /> <input type="text" name="q" /> <input type="submit" name="go" value="Go" /> </div> </form> <div> <a href="http://www.openlinksw.com/">www.openlinksw.com</a> </div> <div> <a href="http://docs.openlinksw.com/">docs.openlinksw.com</a> </div> <br /> <div> <a href="index.html">Book Home</a> </div> <br /> <div> <a href="contents.html">Contents</a> </div> <div> <a href="preface.html">Preface</a> </div> <br /> <div> <a class="selected" href="functions.html">Virtuoso Functions Guide</a> </div> <br /> <div> <a href="functions.html#admin">Administration</a> </div> <div> <a href="functions.html#aggr">Aggregate Functions</a> </div> <div> <a href="functions.html#array">Array Manipulation</a> </div> <div> <a href="functions.html#bpel">BPEL APIs</a> </div> <div> <a href="functions.html#backup">Backup</a> </div> <div> <a href="functions.html#compression">Compression</a> </div> <div> <a href="functions.html#cursors">Cursor</a> </div> <div> <a href="functions.html#time">Date & Time Manipulation</a> </div> <div> <a href="functions.html#debug">Debug</a> </div> <div> <a href="functions.html#dict">Dictionary Manipulation</a> </div> <div> <a href="functions.html#encoding">Encoding & Decoding</a> </div> <div> <a href="functions.html#file">File Manipulation</a> </div> <div> <a href="functions.html#ft">Free Text</a> </div> <div> <a href="functions.html#hash">Hashing / Cryptographic</a> </div> <div> <a href="functions.html#ldap">LDAP</a> </div> <div> <a href="functions.html#localization">Locale</a> </div> <div> <a href="functions.html#mail">Mail</a> </div> <div> <a href="functions.html#misc">Miscellaneous</a> </div> <div> <a href="functions.html#number">Number</a> </div> <div> <a href="functions.html#phrz">Phrases</a> </div> <div> <a href="functions.html#rdf">RDF data</a> </div> <div> <a href="functions.html#rmt">Remote SQL Data Source</a> </div> <div> <a class="selected" href="functions.html#repl">Replication</a> </div> <div class="selected"> <div> <a href="fn_rdf_repl_graph_del.html">rdf_repl_graph_del</a> </div> <div> <a href="fn_rdf_repl_graph_ins.html">rdf_repl_graph_ins</a> </div> <div> <a href="fn_rdf_repl_start.html">rdf_repl_start</a> </div> <div> <a href="fn_REPL_ADD_CR.html">repl_add_cr</a> </div> <div> <a href="fn_REPL_ADD_DAV_CR.html">repl_add_dav_cr</a> </div> <div> <a href="fn_REPL_ADD_SNAPSHOT_CR.html">repl_add_snapshot_cr</a> </div> <div> <a href="fn_REPL_CREATE_SNAPSHOT_PUB.html">repl_create_snapshot...</a> </div> <div> <a href="fn_REPL_CREATE_SNAPSHOT_SUB.html">repl_create_snapshot...</a> </div> <div> <a href="fn_REPL_DROP_SNAPSHOT_PUB.html">repl_drop_snapshot_p...</a> </div> <div> <a href="fn_REPL_DROP_SNAPSHOT_SUB.html">repl_drop_snapshot_s...</a> </div> <div> <a href="fn_repl_grant.html">repl_grant</a> </div> <div> <a href="fn_repl_init_copy.html">repl_init_copy</a> </div> <div> <a href="fn_REPL_INIT_SNAPSHOT.html">repl_init_snapshot</a> </div> <div> <a href="fn_repl_publish.html">repl_publish</a> </div> <div> <a class="selected" href="fn_repl_pub_add.html">repl_pub_add</a> </div> <div> <a href="fn_repl_pub_init_image.html">repl_pub_init_image</a> </div> <div> <a href="fn_repl_pub_remove.html">repl_pub_remove</a> </div> <div> <a href="fn_repl_revoke.html">repl_revoke</a> </div> <div> <a href="fn_repl_sched_init.html">repl_sched_init</a> </div> <div> <a href="fn_repl_server.html">repl_server</a> </div> <div> <a href="fn_REPL_SERVER_NAME.html">repl_server_name</a> </div> <div> <a href="fn_REPL_SNP_SERVER.html">repl_snp_server</a> </div> <div> <a href="fn_repl_stat.html">repl_stat</a> </div> <div> <a href="fn_repl_subscribe.html">repl_subscribe</a> </div> <div> <a href="fn_repl_unpublish.html">repl_unpublish</a> </div> <div> <a href="fn_repl_unsubscribe.html">repl_unsubscribe</a> </div> <div> <a href="fn_REPL_UPDATE_SNAPSHOT.html">repl_update_snapshot</a> </div> <div> <a href="fn_repl_disconnect.html">repl_disconnect</a> </div> <div> <a href="fn_repl_new_log.html">repl_new_log</a> </div> <div> <a href="fn_repl_purge.html">repl_purge</a> </div> <div> <a href="fn_repl_server_rename.html">repl_server_rename</a> </div> <div> <a href="fn_repl_status.html">repl_status</a> </div> <div> <a href="fn_repl_sync.html">repl_sync</a> </div> <div> <a href="fn_repl_sync_all.html">repl_sync_all</a> </div> <div> <a href="fn_repl_text.html">repl_text</a> </div> <div> <a href="fn_repl_this_server.html">repl_this_server</a> </div> <div> <a href="fn_sub_schedule.html">sub_schedule</a> </div> </div> <div> <a href="functions.html#soap">SOAP</a> </div> <div> <a href="functions.html#sql">SQL</a> </div> <div> <a href="functions.html#string">String</a> </div> <div> <a href="functions.html#txn">Transaction</a> </div> <div> <a href="functions.html#type">Type Mapping</a> </div> <div> <a href="functions.html#uddi">UDDI</a> </div> <div> <a href="functions.html#udt">User Defined Types & The CLR</a> </div> <div> <a href="functions.html#vad">VAD</a> </div> <div> <a href="functions.html#jvmpl">Virtuoso Java PL API</a> </div> <div> <a href="functions.html#bif">Virtuoso Server Extension Interface (VSEI)</a> </div> <div> <a href="functions.html#ws">Web & Internet</a> </div> <div> <a href="functions.html#xml">XML</a> </div> <div> <a href="functions.html#XPATH">XPATH & XQUERY</a> </div> <br /> <div> <a href="functionidx.html">Functions Index</a> </div> <br /> </div> <div id="text"> <h2>REPL_PUB_ADD</h2> <div class="refpurpose">add item to a publication</div> <div class="funcsynopsis"> <span class="funcdef"> <span class="function">REPL_PUB_ADD</span> </span> (<span class="paramdef">in <span class="parameter">publication</span> varchar</span>, <span class="paramdef">in <span class="parameter">item</span> varchar</span>, <span class="paramdef">in <span class="parameter">type</span> integer</span>, <span class="paramdef">in <span class="parameter">mode</span> integer</span>, <span class="paramdef">in <span class="parameter">procedure_replication_options</span> integer</span>); </div> <div class="refsect1"> <div class="refsect1title">Description</div> <p>This function is used to add items to a pre-existing publication and to set replication options for the published items. Operations concerning the added item will henceforth be logged into the publication's log. Performing this operation will copy the item and optionally its definition to existing subscribers.</p> </div> <div class="refsect1"> <div class="refsect1title">Parameters</div> <div class="refsect2"> <span class="refsect2title">publication – </span> publication account name.</div> <div class="refsect2"> <span class="refsect2title">item – </span> dependent on <strong>type</strong> should be: <ul> <li>Valid WebDAV collection full path in local repository.</li> <li>Fully qualified table name.</li> <li>Fully qualified Virtuoso/PL procedure name.</li> </ul> </div> <div class="refsect2"> <span class="refsect2title">type – </span> type of item, can accept following types: <ul> <li>1 - item is a WebDAV collection.</li> <li>2 - item is a database table.</li> <li>3 - item is a Virtuoso/PL procedure.</li> </ul> </div> <div class="refsect2"> <span class="refsect2title">mode – </span> mode of remote copy: <ul> <li>0 - if publication is removed leave remote copy (on subscribers).</li> <li>1 - if publication is removed drop remote copy (on subscribers).</li> </ul> </div> <div class="refsect2"> <span class="refsect2title">procedure_replication_options – </span> valid only in case of Virtuoso/PL procedure: <ul> <li>1 - published procedure calls.</li> <li>2 - published procedure definition.</li> <li>3 - published both calls and definition.</li> </ul> </div> </div> <div class="refsect1"> <div class="refsect1title">Example</div> <a name="ex_repl_pub_add_1" /> <div class="example"> <div class="exampletitle">Adding a table to the publication</div> <p>This is to add a table Demo.demo.Orders (available in the demo DataBase) to the an existing publication named table_publication. The default flag for removal when publication is dropped is set to off. The parameter mode is NULL as it has effect only for procedures.</p> <div> <pre class="screen"> SQL> DB.DBA.REPL_PUB_ADD ('table_publication', 'Demo.demo.Orders', 2, 0, NULL); </pre> </div> </div> </div> <div class="refsect1"> <div class="refsect1title">See Also</div> <p> <a href="fn_sub_schedule.html">sub_schedule()</a> </p> <p> <a href="fn_repl_disconnect.html">repl_disconnect()</a> </p> <p> <a href="fn_repl_grant.html">repl_grant()</a> </p> <p> <a href="fn_repl_init_copy.html">repl_init_copy()</a> </p> <p> <a href="fn_repl_new_log.html">repl_new_log()</a> </p> <p> <a href="fn_repl_pub_init_image.html">repl_pub_init_image()</a> </p> <p> <a href="fn_repl_pub_remove.html">repl_pub_remove()</a> </p> <p> <a href="fn_repl_publish.html">repl_publish()</a> </p> <p> <a href="fn_repl_revoke.html">repl_revoke()</a> </p> <p> <a href="fn_repl_sched_init.html">repl_sched_init()</a> </p> <p> <a href="fn_repl_server.html">repl_server()</a> </p> <p> <a href="fn_repl_server_rename.html">repl_server_rename()</a> </p> <p> <a href="fn_repl_stat.html">repl_stat()</a> </p> <p> <a href="fn_repl_status.html">repl_status()</a> </p> <p> <a href="fn_repl_subscribe.html">repl_subscribe()</a> </p> <p> <a href="fn_repl_sync.html">repl_sync()</a> </p> <p> <a href="fn_repl_sync_all.html">repl_sync_all()</a> </p> <p> <a href="fn_repl_text.html">repl_text()</a> </p> <p> <a href="fn_repl_this_server.html">repl_this_server()</a> </p> <p> <a href="fn_repl_unpublish.html">repl_unpublish()</a> </p> <p> <a href="fn_repl_unsubscribe.html">repl_unsubscribe()</a> </p> </div> </div> <div id="footer"> <div>Copyright© 1999 - 2009 OpenLink Software All rights reserved.</div> <div id="validation"> <a href="http://validator.w3.org/check/referer"> <img src="http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0!" height="31" width="88" /> </a> <a href="http://jigsaw.w3.org/css-validator/"> <img src="http://jigsaw.w3.org/css-validator/images/vcss" alt="Valid CSS!" height="31" width="88" /> </a> </div> </div> </body> </html>