Sophie

Sophie

distrib > Fedora > 14 > x86_64 > media > updates > by-pkgid > 71d40963b505df4524269198e237b3e3 > files > 505

virtuoso-opensource-doc-6.1.4-2.fc14.noarch.rpm

<!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_UNSUBSCRIBE - Virtuoso Functions Guide" />
  <meta name="dc.subject" content="Function: REPL_UNSUBSCRIBE - Virtuoso Functions Guide" />
  <meta name="dc.creator" content="OpenLink Software Documentation Team ;&#10;" />
  <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_UNSUBSCRIBE - Virtuoso Functions Guide</title>
  <meta http-equiv="Content-Type" content="text/xhtml; charset=UTF-8" />
  <meta name="author" content="OpenLink Software Documentation Team ;&#10;" />
  <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_unsubscribe" />
    <img src="../images/misc/logo.jpg" alt="" />
    <h1>22. Virtuoso Functions Guide - REPL_UNSUBSCRIBE</h1>
  </div>
  <div id="navbartop">
   <div>
      <a class="link" href="functions.html">Chapter Contents</a> | <a class="link" href="fn_repl_unpublish.html" title="REPL_UNPUBLISH">Prev</a> | <a class="link" href="fn_repl_purge.html" title="repl_purge">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 &amp; 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 &amp; 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 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 class="selected" 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 &amp; 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 &amp; Internet</a>
   </div>
   <div>
      <a href="functions.html#xml">XML</a>
   </div>
   <div>
      <a href="functions.html#XPATH">XPATH &amp; XQUERY</a>
   </div>
    <br />
   <div>
      <a href="functionidx.html">Functions Index</a>
   </div>
    <br />
  </div>
  <div id="text">
    <h2>REPL_UNSUBSCRIBE</h2>
    <div class="refpurpose">drop subscription</div>
    <div class="funcsynopsis">
        <span class="funcdef">
     <span class="function">REPL_UNSUBSCRIBE</span>
     </span>
        (<span class="paramdef">in <span class="parameter">server_name</span> varchar</span>, 
        <span class="paramdef">in <span class="parameter">publication</span> varchar</span>, 
        <span class="paramdef">in <span class="parameter">item</span> varchar</span>);
      </div>
  
  
  
  <div class="refsect1">
      <div class="refsect1title">Description</div>
   <p>This function is used to stop receiving a replication messages from a 
   publisher server for a item or whole subscription.  It will be invoked 
   automatically when a publication is dropped.  The subscriber can also invoke 
   this function to stop receiving replication messages.  The existing items can be 
   dropped or not depending on the copy mode flag.  The description entries for 
   that subscription will be removed.  There is no &quot;undo&quot; ability.  To 
   temporally halt the replication messages you can use repl_disconnect().</p>
	</div>
  <div class="refsect1">
      <div class="refsect1title">Parameters</div>
    <div class="refsect2">
        <span class="refsect2title">server_name – </span>
      Name of the target publishing server.
    </div>
    <div class="refsect2">
        <span class="refsect2title">publication – </span>
      The name of the publication.
    </div>
    <div class="refsect2">
        <span class="refsect2title">item – </span>
      The item to removed.  NULL can be supplied to remove all items.
    </div>
  </div>

    
  <div class="refsect1">
      <div class="refsect1title">Example</div>
    <a name="ex_repl_unsubscribe_1" />
      <div class="example">
        <div class="exampletitle">Unsubscribing from a publication.</div>
     <p>This is to stop replication on subscription &#39;demo-publication&#39; from publisher server &#39;demo-srv&#39;.</p>
      <div>
          <pre class="screen">
SQL&gt; DB.DBA.REPL_UNSUBSCRIBE (&#39;demo-srv&#39;, &#39;demo-publication&#39;, 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_add.html">repl_pub_add()</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>
  </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>