<!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: log_enable - Virtuoso Functions Guide" />
<meta name="dc.subject" content="Function: log_enable - 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: log_enable - 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_log_enable" />
<img src="../images/misc/logo.jpg" alt="" />
<h1>22. Virtuoso Functions Guide - log_enable</h1>
</div>
<div id="navbartop">
<div>
<a class="link" href="functions.html">Chapter Contents</a> | <a class="link" href="fn_fk_check_input_values.html" title="fk_check_input_values">Prev</a> | <a class="link" href="fn_log_text.html" title="log_text">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 class="selected" href="functions.html#admin">Administration</a>
</div>
<div class="selected">
<div>
<a href="fn_vacuum.html">db.dba.vacuum</a>
</div>
<div>
<a href="fn_USER_CHANGE_PASSWORD.html">user_change_password</a>
</div>
<div>
<a href="fn_USER_CREATE.html">user_create</a>
</div>
<div>
<a href="fn_USER_DROP.html">user_drop</a>
</div>
<div>
<a href="fn_USER_GET_OPTION.html">user_get_option</a>
</div>
<div>
<a href="fn_USER_GRANT_ROLE.html">user_grant_role</a>
</div>
<div>
<a href="fn_USER_REVOKE_ROLE.html">user_revoke_role</a>
</div>
<div>
<a href="fn_USER_ROLE_CREATE.html">user_role_create</a>
</div>
<div>
<a href="fn_USER_ROLE_DROP.html">user_role_drop</a>
</div>
<div>
<a href="fn_USER_SET_OPTION.html">user_set_option</a>
</div>
<div>
<a href="fn_USER_SET_QUALIFIER.html">user_set_qualifier</a>
</div>
<div>
<a href="fn_dbf_set.html">__dbf_set</a>
</div>
<div>
<a href="fn_cfg_item_count.html">cfg_item_count</a>
</div>
<div>
<a href="fn_cfg_item_name.html">cfg_item_name</a>
</div>
<div>
<a href="fn_cfg_item_value.html">cfg_item_value</a>
</div>
<div>
<a href="fn_cfg_section_count.html">cfg_section_count</a>
</div>
<div>
<a href="fn_cfg_section_name.html">cfg_section_name</a>
</div>
<div>
<a href="fn_cfg_write.html">cfg_write</a>
</div>
<div>
<a href="fn_checkpoint_interval.html">checkpoint_interval</a>
</div>
<div>
<a href="fn_disconnect_user.html">disconnect_user</a>
</div>
<div>
<a href="fn_fk_check_input_values.html">fk_check_input_value...</a>
</div>
<div>
<a href="fn_key_estimate.html">key_estimate</a>
</div>
<div>
<a class="selected" href="fn_log_enable.html">log_enable</a>
</div>
<div>
<a href="fn_log_text.html">log_text</a>
</div>
<div>
<a href="fn_prof_enable.html">prof_enable</a>
</div>
<div>
<a href="fn_prof_sample.html">prof_sample</a>
</div>
<div>
<a href="fn_server_root.html">server_root</a>
</div>
<div>
<a href="fn_status.html">status</a>
</div>
<div>
<a href="fn_sys_lockdown.html">sys_lockdown</a>
</div>
<div>
<a href="fn_sys_stat.html">sys_stat</a>
</div>
<div>
<a href="fn_system.html">system</a>
</div>
<div>
<a href="fn_trace_status.html">trace_status</a>
</div>
<div>
<a href="fn_user_set_password.html">user_set_password</a>
</div>
<div>
<a href="fn_virtuoso_ini_path.html">virtuoso_ini_path</a>
</div>
</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 href="functions.html#repl">Replication</a>
</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>log_enable</h2>
<div class="refpurpose">controls transaction logging and in-statement autocommit</div>
<div class="funcsynopsis">
<span class="funcdef">
<span class="function">log_enable</span>
</span>
(<span class="paramdefoptional">[in <span class="parameter">bits</span> integer
in <span class="optional">quiet</span> integer]</span>);
</div>
<div class="refsect1">
<div class="refsect1title">Description</div>
<p>The <span class="computeroutput">log_enable</span> function allows turning off or on
regular transaction logging or autocommit after every changed row.
The parameter <span class="computeroutput">bits</span> is a bitmask.
Two bits that are in use in current versions are 1 and 2.
When bit 1 is not set (e.g. parameter value 0) then the function call
terminates logging of DML statements inside the calling
transaction. A value of 1 resumes logging of DML statements.
If bit 2 is set then automatic commits take place after every change
in every row in every DML statement.
Thus a parameter value of 2 disables logging and enables row-by-row autocommit.
A value of 3 enables row-by-row autocommit and enables logging.
While log on and off setting alone is reset at the end of the transaction so that one does not end up with logging disabled by accident,
the row-by-row autocommit mode causes the setting to be permanent inside the calling connection or web request.
That is, for a SQL client the setting stays in effect until changed or disconnected and for a web request it stays in effect until the request is completed.
</p>
<p>
The function do nothing if the <span class="computeroutput">bits</span> is NULL.
The function also do nothing when called inside atomic section.
</p>
<p>The function always returns the bitmask that describes old configuration of the log.</p>
<p>Attempt to disable transaction log that is disabled already result in an error.
If the second parameter is passed and it is not equal to zero then the error is
suppressed (and it's still possible to turn on or off autocommit).</p>
<p>Using this function one can create situations where a transaction's outcome
would be different from the outcome of doing a roll forward of the
transaction log.</p>
<p>There are rare cases where it is more efficient to log an action in
the form of a procedure call instead of logging the effects of the procedure on
a row by row basis. This is similar in concept to replicating procedure
calls but applies to roll forward instead.</p>
</div>
<div class="refsect1">
<div class="refsect1title">See Also</div>
<p>
<a href="fn_log_text.html">log_text</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>
distrib
>
Fedora
>
14
>
x86_64
>
media
>
updates
>
by-pkgid
>
71d40963b505df4524269198e237b3e3
>
files
>
386
