db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r1361347 - in /db/derby/docs/trunk/src/ref: refderby.ditamap rrefsyscsinvalidatestoredstmts.dita
Date Fri, 13 Jul 2012 19:38:25 GMT
Author: chaase3
Date: Fri Jul 13 19:38:25 2012
New Revision: 1361347

URL: http://svn.apache.org/viewvc?rev=1361347&view=rev
Log:
DERBY-5793  Document new SYSCS_INVALIDATE_STORED_STATEMENTS procedure

Added new topic, src/ref/rrefsyscsinvalidatestoredstmts.dita.


Added:
    db/derby/docs/trunk/src/ref/rrefsyscsinvalidatestoredstmts.dita   (with props)
Modified:
    db/derby/docs/trunk/src/ref/refderby.ditamap

Modified: db/derby/docs/trunk/src/ref/refderby.ditamap
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/refderby.ditamap?rev=1361347&r1=1361346&r2=1361347&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/refderby.ditamap (original)
+++ db/derby/docs/trunk/src/ref/refderby.ditamap Fri Jul 13 19:38:25 2012
@@ -876,6 +876,8 @@ limitations under the License.
 </topicref>
 <topicref href="rrefproceduresinplacecompress.dita" navtitle="SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE
system procedure">
 </topicref>
+<topicref href="rrefsyscsinvalidatestoredstmts.dita" navtitle="SYSCS_UTIL.SYSCS_INVALIDATE_STORED_STATEMENTS
system procedure">
+</topicref>
 <topicref href="rrefnativemodifypasswordproc.dita" navtitle="SYSCS_UTIL.SYSCS_MODIFY_PASSWORD
system procedure">
 </topicref>
 <topicref href="rrefreloadpolicyproc.dita" navtitle="SYSCS_UTIL.SYSCS_RELOAD_SECURITY_POLICY
system procedure">

Added: db/derby/docs/trunk/src/ref/rrefsyscsinvalidatestoredstmts.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsyscsinvalidatestoredstmts.dita?rev=1361347&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsyscsinvalidatestoredstmts.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefsyscsinvalidatestoredstmts.dita Fri Jul 13 19:38:25 2012
@@ -0,0 +1,49 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefsyscsinvalidatestoredstmts" xml:lang="en-us">
+<title>SYSCS_UTIL.SYSCS_INVALIDATE_STORED_STATEMENTS system procedure</title>
+<refbody>
+<section><p>The <codeph>SYSCS_UTIL.SYSCS_INVALIDATE_STORED_STATEMENTS</codeph>
+system procedure invalidates all stored prepared statements (that is, all
+statements in the <xref href="rrefsistabs33768.dita#rrefsistabs33768"></xref>).
+The next time one of the invalid stored prepared statements is executed, it will
+be recompiled, and a new plan will be generated for it. This procedure can be
+especially useful after an upgrade.</p></section>
+<section><title>Syntax</title>
+<codeblock>SYSCS_UTIL.SYSCS_INVALIDATE_STORED_STATEMENTS()</codeblock>
+<p>No result is returned by this procedure.</p></section>
+<section><title>Execute privileges</title>
+<p>If authentication and SQL authorization are both enabled, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. The
+database owner can grant access to other users.</p>
+</section>
+<section><title>JDBC example</title>
+<codeblock>CallableStatement cs = conn.prepareCall
+("CALL SYSCS_UTIL.SYSCS_INVALIDATE_STORED_STATEMENTS()");
+cs.execute();
+cs.close();</codeblock></section>
+<section><title>SQL Example</title>
+<codeblock>CALL SYSCS_UTIL.SYSCS_INVALIDATE_STORED_STATEMENTS();</codeblock>
+</section>
+</refbody>
+</reference>

Propchange: db/derby/docs/trunk/src/ref/rrefsyscsinvalidatestoredstmts.dita
------------------------------------------------------------------------------
    svn:eol-style = native



Mime
View raw message