Not logged in : Login
(Sponging disallowed)

About: http://docs.openlinksw.com/virtuoso/fn_log_enable.html     Goto   Sponge   NotDistinct   Permalink

An Entity of Type : rss:item, within Data Space : openlinksw.com associated with source document(s)
QRcode icon
http://openlinksw.com/c/8LV3BeAqnz

AttributesValues
described by
Description
  • controls transaction logging and in-statement autocommitThe log_enable function allows turning off or on regular transaction logging or autocommit after every changed row. The parameter bits 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. The function do nothing if the bits is NULL. The function also do nothing when called inside atomic section. The function always returns the bitmask that describes old configuration of the log.
Creator
  • virtuoso.docs@openlinksw.com
Date
  • 2013-07-11T21:22:54Z
  • 2015-02-05T21:17:51Z
Title
  • Function: log_enable
type
content:encoded
  • controls transaction logging and in-statement autocommitThe log_enable function allows turning off or on regular transaction logging or autocommit after every changed row. The parameter bits 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. The function do nothing if the bits is NULL. The function also do nothing when called inside atomic section. The function always returns the bitmask that describes old configuration of the log.
rss:category
  • Administration
is topic of
is links to of
is rdf:_265 of
Faceted Search & Find service v1.17_git148 as of Oct 14 2024


Alternative Linked Data Documents: iSPARQL | ODE     Content Formats:   [cxml] [csv]     RDF   [text] [turtle] [ld+json] [rdf+json] [rdf+xml]     ODATA   [atom+xml] [odata+json]     Microdata   [microdata+json] [html]    About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 08.03.3332 as of Dec 6 2024, on Linux (x86_64-generic-linux-glibc25), Single-Server Edition (46 GB total memory, 32 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2025 OpenLink Software