db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r1028853 [2/2] - in /db/derby/docs/trunk/src: adminguide/ ref/ tools/
Date Fri, 29 Oct 2010 17:11:21 GMT
Modified: db/derby/docs/trunk/src/ref/rrefsqljoffsetfetch.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljoffsetfetch.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljoffsetfetch.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljoffsetfetch.dita Fri Oct 29 17:11:19 2010
@@ -71,10 +71,8 @@ the clause is omitted entirely, all rows
 a <i>result offset clause</i> is also given) will be returned.
 </p>
 </refsyn>
-<example>
-  <title>Examples</title>
-  <codeblock><b>
--- Fetch the first row of T
+<example><title>Examples</title>
+  <codeblock><b>-- Fetch the first row of T
 SELECT * FROM T FETCH FIRST ROW ONLY
 
 -- Sort T using column I, then fetch rows 11 through 20 of the sorted

Modified: db/derby/docs/trunk/src/ref/rrefsqljrenametablestatement.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljrenametablestatement.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljrenametablestatement.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljrenametablestatement.dita Fri Oct 29 17:11:19 2010
@@ -35,8 +35,9 @@ href="rrefnewtablename.dita#rrefnewtable
 there is a view or foreign key that references the table, attempts to rename
 it will generate an error. In addition, if there are any check constraints
 or triggers on the table, attempts to rename it will also generate an error.</p> </refsyn>
-<example> <codeblock><b>RENAME TABLE SAMP.EMP_ACT TO EMPLOYEE_ACT</b></codeblock>
<p>Also
-see <xref href="rrefsqlj81859.dita#rrefsqlj81859"></xref> for more information.</p>
</example>
+<example><title>Example</title>
+<codeblock><b>RENAME TABLE SAMP.EMP_ACT TO EMPLOYEE_ACT</b></codeblock>
+<p>See <xref href="rrefsqlj81859.dita#rrefsqlj81859"></xref> for more information.</p>
</example>
 <section><title>Statement dependency system</title>
 <p>The RENAME TABLE statement
 is not allowed if there are any open cursors that reference the table that

Modified: db/derby/docs/trunk/src/ref/rrefsqljtfinvoke.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljtfinvoke.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljtfinvoke.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljtfinvoke.dita Fri Oct 29 17:11:19 2010
@@ -24,19 +24,12 @@ limitations under the License.
 <example>
 <codeblock>
 <b>TABLE <i>function-name</i>( [ [ function-arg ] [, function-arg ]* ]
)
-</b></codeblock></example>
-
-<section>
+</b></codeblock>
 <p>
 Note that when you invoke a table function, you must bind it to a
 correlation name. For example:
 </p>
-</section>
-
-<example>
-<codeblock>
-<b>
-SELECT s.*
+<codeblock><b>SELECT s.*
 FROM TABLE( externalEmployees( 42 ) ) s
 </b></codeblock></example>
 

Modified: db/derby/docs/trunk/src/ref/rrefsyscschecktablefunc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsyscschecktablefunc.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsyscschecktablefunc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsyscschecktablefunc.dita Fri Oct 29 17:11:19 2010
@@ -25,19 +25,19 @@ limitations under the License.
 checks the specified table, ensuring that all of its indexes are consistent
 with the base table.  If the table and indexes are consistent, the method returns a SMALLINT
 with value 1. If the table and indexes are inconsistent, the function will throw an exception.</p></section>
-<section><title>Syntax</title> <codeblock>SMALLINT SYSCS_UTIL.SYSCS_CHECK_TABLE(IN
SCHEMANAME VARCHAR(128),
+<refsyn><title>Syntax</title> <codeblock>SMALLINT SYSCS_UTIL.SYSCS_CHECK_TABLE(IN
SCHEMANAME VARCHAR(128),
 IN TABLENAME VARCHAR(128)) </codeblock> <p>An error will occur if either SCHEMANAME
-or TABLENAME are null.</p></section>
-<section><title>Examples</title> 
-Check a single table:
+or TABLENAME are null.</p></refsyn>
+<example><title>Examples</title> 
+<p>Check a single table:</p>
 <codeblock>VALUES SYSCS_UTIL.SYSCS_CHECK_TABLE('SALES', 'ORDERS');</codeblock>
-Check all tables:
-<codeblock>SELECT schemaname, tablename, SYSCS_UTIL.SYSCS_CHECK_TABLE(schemaname,
-tablename) FROM sys.sysschemas s, sys.systables t WHERE s.schemaid =
-t.schemaid;
-</codeblock>
+<p>Check all tables:</p>
+<codeblock>SELECT schemaname, tablename, 
+    SYSCS_UTIL.SYSCS_CHECK_TABLE(schemaname, tablename) 
+  FROM sys.sysschemas s, sys.systables t 
+  WHERE s.schemaid = t.schemaid;</codeblock>
 
-</section>
+</example>
 </refbody>
 </reference>
 

Modified: db/derby/docs/trunk/src/ref/rreftimefunc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rreftimefunc.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rreftimefunc.dita (original)
+++ db/derby/docs/trunk/src/ref/rreftimefunc.dita Fri Oct 29 17:11:19 2010
@@ -36,7 +36,8 @@ other rules depend on the data type of t
 string.</li>
 </ul></p></section>
 <refsyn><title>Syntax</title> <codeblock><b>TIME ( <i>expression</i>
)</b></codeblock> </refsyn>
-<example> <codeblock><b>values time(current_timestamp)</b></codeblock>
<p>If
+<example><title>Example</title>
+<codeblock><b>values time(current_timestamp)</b></codeblock> <p>If
 the current time is 5:03 PM, the value returned is <codeph>17:03:00</codeph>.</p>
</example>
 </refbody>
 </reference>

Modified: db/derby/docs/trunk/src/tools/rtoolsijpropref10135.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/rtoolsijpropref10135.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tools/rtoolsijpropref10135.dita (original)
+++ db/derby/docs/trunk/src/tools/rtoolsijpropref10135.dita Fri Oct 29 17:11:19 2010
@@ -35,8 +35,10 @@ current connection, if there is more tha
 specified on the command line the <i>databaseConnectionURL</i> should not
 be enclosed in single quotations, however, if the database path contains special
 characters (e.g. a space) it must be enclosed in double quotes.</p> </refsyn>
-<example><title>Example</title>This example connects to the existing database
<i>sample</i> and
-creates then connects to the database <i>anohterDB</i>.<codeblock>D:&gt;
<b>java -Dij.connection.sample1=jdbc:derby:sample
+<example><title>Example</title>
+<p>This example connects to the existing database <i>sample</i> and
+creates, then connects to, the database <i>anotherDB</i>.</p>
+<codeblock>D:&gt; <b>java -Dij.connection.sample1=jdbc:derby:sample
 -Dij.connection.anotherConn=jdbc:derby:anotherDB;create=true
     org.apache.derby.tools.ij</b>
 ij version <ph conref="../conrefs.dita#vers/shortversionnumber"></ph>

Modified: db/derby/docs/trunk/src/tools/ttoolsij30600.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/ttoolsij30600.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tools/ttoolsij30600.dita (original)
+++ db/derby/docs/trunk/src/tools/ttoolsij30600.dita Fri Oct 29 17:11:19 2010
@@ -25,9 +25,10 @@ limitations under the License.
 <li>by specifying a properties file using the <codeph>-p propertyfile</codeph>
option
 on the command line</li>
 </ol><p><note type="remember">ij property names are case-sensitive, while
-commands are case-insensitive.</note></p><p>The following examples illustrate
-how to use ij properties:</p> </context>
-<example><p>To start ij by using a properties file called <codeph>ij.properties</codeph>,
+commands are case-insensitive.</note></p></context>
+<example><title>Examples</title>
+<p>The following examples illustrate how to use ij properties.</p>
+<p>To start ij by using a properties file called <codeph>ij.properties</codeph>,
 use a command like the following (with the addition of the file paths):   
 <codeblock><b><userinput>java -jar derbyrun.jar -p ij.properties</userinput></b></codeblock></p><p>To
 start ij with a maximumDisplayWidth of 1000:   



Mime
View raw message