db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r1307003 - in /db/derby/docs/trunk/src/ref: refderby.ditamap rrefjdbc1020262.dita rrefjdbclimit.dita
Date Thu, 29 Mar 2012 17:18:44 GMT
Author: chaase3
Date: Thu Mar 29 17:18:43 2012
New Revision: 1307003

URL: http://svn.apache.org/viewvc?rev=1307003&view=rev
Log:
DERBY-5499  Document the new JDBC limit/offset escape syntax

Added new Reference Manual topic, modified another.

Patch: DERBY-5499-2.diff

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

Modified: db/derby/docs/trunk/src/ref/refderby.ditamap
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/refderby.ditamap?rev=1307003&r1=1307002&r2=1307003&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/refderby.ditamap (original)
+++ db/derby/docs/trunk/src/ref/refderby.ditamap Thu Mar 29 17:18:43 2012
@@ -632,6 +632,8 @@ URL syntax"></topicref>
 </topicref>
 <topicref href="rrefjdbc28456.dita" navtitle="JDBC escape syntax for LIKE clauses">
 </topicref>
+<topicref href="rrefjdbclimit.dita" navtitle="JDBC escape syntax for limit/offset clauses">
+</topicref>
 <topicref href="rrefjdbc88908.dita" navtitle="JDBC escape syntax for fn keyword">
 </topicref>
 <topicref href="rrefjdbc37244.dita" navtitle="JDBC escape syntax for outer joins">

Modified: db/derby/docs/trunk/src/ref/rrefjdbc1020262.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefjdbc1020262.dita?rev=1307003&r1=1307002&r2=1307003&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefjdbc1020262.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefjdbc1020262.dita Thu Mar 29 17:18:43 2012
@@ -39,6 +39,8 @@ the following JDBC escape keywords, whic
 for use in <i>CallableStatements</i>.</p></li>
 <li><i><xref href="rrefjdbc28456.dita#rrefjdbc28456"></xref></i>
  <p>The keyword
 for specifying escape characters for LIKE clauses.</p></li>
+<li><i><xref href="rrefjdbclimit.dita#rrefjdbclimit"></xref></i>
  <p>The
+escape keywords for specifying limit/offset clauses.</p></li>
 <li><i><xref href="rrefjdbc88908.dita#rrefjdbc88908"></xref></i>
  <p>The escape keyword
 for scalar functions.</p></li>
 <li><i><xref href="rrefjdbc37244.dita#rrefjdbc37244"></xref></i>
  <p>The escape keyword

Added: db/derby/docs/trunk/src/ref/rrefjdbclimit.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefjdbclimit.dita?rev=1307003&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefjdbclimit.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefjdbclimit.dita Thu Mar 29 17:18:43 2012
@@ -0,0 +1,57 @@
+<?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="rrefjdbclimit" xml:lang="en-us">
+<title>JDBC escape syntax for limit/offset clauses</title>
+<prolog><metadata>
+<keywords><indexterm>LIMIT (JDBC escape keyword)</indexterm>
+<indexterm>OFFSET (JDBC escape keyword)</indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section>
+<p>The LIMIT escape clause can occur in a query at the point where an
+OFFSET/FETCH FIRST clause can appear. See
+<xref href="rrefsqljoffsetfetch.dita#rrefsqljoffsetfetch"></xref> for more
+information.</p>
+</section>
+<refsyn><title>Syntax</title>
+<codeblock><b>{ LIMIT <i>rowCount</i> [ OFFSET <i>startRow</i>
] }</b></codeblock>
+<p>The <i>rowCount</i> is a non-negative integer that specifies the
+number of rows to return. If <i>rowCount</i> is 0, all rows from <i>startRow</i>
+forward are returned.</p>
+<p>The <i>startRow</i> is a non-negative number that specifies the number
of
+rows to skip before returning results.</p>
+</refsyn>
+<section><title>Equivalent to</title>
+<codeblock><b>OFFSET <i>startRow</i> FETCH NEXT <i>rowCount</i>
ROWS ONLY</b></codeblock>
+</section>
+<example><title>Examples</title> 
+<codeblock><b><ph>-- return the first two rows of sorted table t</ph>
+SELECT * FROM t
+ORDER BY a
+{ LIMIT 2 }
+<ph>-- return two rows of sorted table t, starting with the eleventh row</ph>
+SELECT * FROM t
+ORDER BY a
+{ LIMIT 2 OFFSET 10 }</b></codeblock> 
+</example>
+</refbody>
+</reference>

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



Mime
View raw message