db-general mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rhille...@apache.org
Subject svn commit: r843115 [18/44] - in /websites/production/db/content/derby: ./ binaries/ blogs/ blogs/images/ dev/ docs/ images/ integrate/ integrate/plugin_help/ integrate/plugin_help/images/ logo/ manuals/ papers/ papers/DerbyTut/ releases/ skin/ skin/cs...
Date Wed, 19 Dec 2012 18:20:28 GMT
Added: websites/production/db/content/derby/logo/final_logo.png
==============================================================================
Binary file - no diff available.

Propchange: websites/production/db/content/derby/logo/final_logo.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: websites/production/db/content/derby/logo/final_logo.psd
==============================================================================
Binary file - no diff available.

Propchange: websites/production/db/content/derby/logo/final_logo.psd
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: websites/production/db/content/derby/logo/final_logo128.png
==============================================================================
Binary file - no diff available.

Propchange: websites/production/db/content/derby/logo/final_logo128.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: websites/production/db/content/derby/logo/final_logo32.png
==============================================================================
Binary file - no diff available.

Propchange: websites/production/db/content/derby/logo/final_logo32.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: websites/production/db/content/derby/logo/final_logo64.png
==============================================================================
Binary file - no diff available.

Propchange: websites/production/db/content/derby/logo/final_logo64.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: websites/production/db/content/derby/logo/final_logowithtext.ai
==============================================================================
Files websites/production/db/content/derby/logo/final_logowithtext.ai (added) and websites/production/db/content/derby/logo/final_logowithtext.ai Wed Dec 19 18:20:21 2012 differ

Added: websites/production/db/content/derby/logo/final_logowithtext.eps
==============================================================================
Binary file - no diff available.

Propchange: websites/production/db/content/derby/logo/final_logowithtext.eps
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: websites/production/db/content/derby/logo/final_logowithtext.png
==============================================================================
Binary file - no diff available.

Propchange: websites/production/db/content/derby/logo/final_logowithtext.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: websites/production/db/content/derby/logo/final_logowithtext.psd
==============================================================================
Binary file - no diff available.

Propchange: websites/production/db/content/derby/logo/final_logowithtext.psd
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: websites/production/db/content/derby/logo/final_logowithtext.svg
==============================================================================
--- websites/production/db/content/derby/logo/final_logowithtext.svg (added)
+++ websites/production/db/content/derby/logo/final_logowithtext.svg Wed Dec 19 18:20:21 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.
+-->
+<!-- Generator: Adobe Illustrator 12.0.0, SVG Export Plug-In . SVG Version: 6.00 Build 51448)  -->
+<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN" "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd" [
+	<!ENTITY ns_svg "http://www.w3.org/2000/svg">
+	<!ENTITY ns_xlink "http://www.w3.org/1999/xlink">
+]>
+<svg  version="1.1" xmlns="&ns_svg;" xmlns:xlink="&ns_xlink;" width="502.811" height="123.223" viewBox="0 0 502.811 123.223"
+	 overflow="visible" enable-background="new 0 0 502.811 123.223" xml:space="preserve">
+<g id="Layer_2">
+</g>
+<g id="Layer_1">
+	<g>
+		<path fill="#FFFFFF" d="M422.333,55.188c0,0-57.656,18.365-69.068,18.561c0,0-0.272,5.211,3.002,16.316
+			c3.71,1.32,45.955-9.455,50.653-11.922c18.847-9.895,12.657-14.899,58.366-30.797c0,0-0.865-3.968-4.335-9.584
+			C460.951,37.763,444.11,49.218,422.333,55.188z"/>
+		<linearGradient id="XMLID_4_" gradientUnits="userSpaceOnUse" x1="326.1489" y1="99.2178" x2="409.394" y2="99.2178">
+			<stop  offset="0" style="stop-color:#575757"/>
+			<stop  offset="1" style="stop-color:#000000"/>
+		</linearGradient>
+		<path fill="url(#XMLID_4_)" d="M356.822,89.902c-1.488-1.975-3.62-14.323-3.62-14.323s-30.228,13.139-26.778,35.059
+			c1.617,10.298,10.39,11.698,14.139,12.125c8.119,0.926,19.914-5.284,26.633-9.966c13.519-9.419,20.799-18.508,42.199-35.986
+			C409.394,76.811,379.102,88.361,356.822,89.902z"/>
+		<linearGradient id="XMLID_5_" gradientUnits="userSpaceOnUse" x1="350.9038" y1="36.8745" x2="460.9507" y2="36.8745">
+			<stop  offset="0" style="stop-color:#666666"/>
+			<stop  offset="1" style="stop-color:#000000"/>
+		</linearGradient>
+		<path fill="url(#XMLID_5_)" d="M353.264,73.75c0,0-11.72-43.32,17.066-59.808c9.613-5.505,28.292-11.514,37.585-12.747
+			c9.294-1.232,31.186-5.128,42.44,13.437c4.114,6.783,9.466,18.786,10.595,23.131C449.192,50.586,366.3,72.923,353.264,73.75z"/>
+		<linearGradient id="XMLID_6_" gradientUnits="userSpaceOnUse" x1="427.3989" y1="54.2637" x2="502.4292" y2="54.2637">
+			<stop  offset="0" style="stop-color:#616161"/>
+			<stop  offset="1" style="stop-color:#000000"/>
+		</linearGradient>
+		<path fill="url(#XMLID_6_)" d="M427.399,66.57c0,0,19.601-3.876,45.232-4.892c20.483-0.81,32.261-9.313,29.362-13.689
+			C499.092,43.614,476.843,30.258,427.399,66.57z"/>
+		<path d="M502.653,47.494c0,0-30.744-34.994-127.965,57.962c-21.76,17.283-42.291,20.321-47.529,7.681
+			c4.16,12.052,16.037,11.844,30.716,6.936c19.213-6.426,45.868-31.832,49.225-34.336c26.3-19.629,71.279-51.303,95.205-35.324
+			C502.304,50.413,503.154,48.854,502.653,47.494z"/>
+	</g>
+	<text transform="matrix(1 0 0 1 1.4321 70.4546)"><tspan x="0" y="0" font-family="'Myriad-Italic'" font-size="55.1086">Apache </tspan><tspan x="176.84" y="0" font-family="'Myriad-BoldItalic'" font-size="55.1086">Derby</tspan></text>
+</g>
+</svg>

Added: websites/production/db/content/derby/logo/final_logowithtext120.png
==============================================================================
Binary file - no diff available.

Propchange: websites/production/db/content/derby/logo/final_logowithtext120.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: websites/production/db/content/derby/logo/final_logowithtext220.png
==============================================================================
Binary file - no diff available.

Propchange: websites/production/db/content/derby/logo/final_logowithtext220.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: websites/production/db/content/derby/logo/final_logowithtextdark.png
==============================================================================
Binary file - no diff available.

Propchange: websites/production/db/content/derby/logo/final_logowithtextdark.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: websites/production/db/content/derby/logo/final_logowithtextdark.psd
==============================================================================
Binary file - no diff available.

Propchange: websites/production/db/content/derby/logo/final_logowithtextdark.psd
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: websites/production/db/content/derby/logo_contest.html
==============================================================================
--- websites/production/db/content/derby/logo_contest.html (added)
+++ websites/production/db/content/derby/logo_contest.html Wed Dec 19 18:20:21 2012
@@ -0,0 +1,238 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+<html>
+<head>
+<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
+<meta content="Apache Forrest" name="Generator">
+<meta name="Forrest-version" content="0.7">
+<meta name="Forrest-skin-name" content="pelt">
+<title>Apache Derby: Logo Contest</title>
+<link type="text/css" href="skin/basic.css" rel="stylesheet">
+<link media="screen" type="text/css" href="skin/screen.css" rel="stylesheet">
+<link media="print" type="text/css" href="skin/print.css" rel="stylesheet">
+<link type="text/css" href="skin/profile.css" rel="stylesheet">
+<script src="skin/getBlank.js" language="javascript" type="text/javascript"></script><script src="skin/getMenu.js" language="javascript" type="text/javascript"></script><script src="skin/fontsize.js" language="javascript" type="text/javascript"></script>
+<link rel="shortcut icon" href="">
+</head>
+<body onload="init()">
+<script type="text/javascript">ndeSetTextSize();</script>
+<div id="top">
+<div class="breadtrail">
+<a href="http://www.apache.org/">apache</a> &gt; <a href="http://db.apache.org/">db</a><script src="skin/breadcrumbs.js" language="JavaScript" type="text/javascript"></script>
+</div>
+<div class="header">
+<div class="grouplogo">
+<a href="http://db.apache.org/derby"><img class="logoImage" alt="Apache Derby" src="images/derby-logo-web.png" title="Derby is a zero-admin Java RDBMS"></a>
+</div>
+<div class="projectlogoA1">
+<a href="http://db.apache.org"><img class="logoImage" alt="Apache DB Project" src="images/db-logo-white.png" title="Apache DB creates and maintains database solutions."></a>
+</div>
+<ul id="tabs">
+<li>
+<a class="base-not-selected" href="index.html">Home</a>
+</li>
+<li>
+<a class="base-not-selected" href="quick_start.html">Quick Start</a>
+</li>
+<li>
+<a class="base-not-selected" href="derby_downloads.html">Download</a>
+</li>
+<li class="current">
+<a class="base-selected" href="derby_comm.html">Community</a>
+</li>
+<li>
+<a class="base-not-selected" href="manuals/index.html">Documentation</a>
+</li>
+<li>
+<a class="base-not-selected" href="integrate/index.html">Resources</a>
+</li>
+</ul>
+</div>
+</div>
+<div id="main">
+<div id="publishedStrip">
+<div id="level2tabs"></div>
+<script type="text/javascript"><!--
+document.write("<text>Last Published:</text> " + document.lastModified);
+//  --></script>
+</div>
+<div class="breadtrail">
+             
+             &nbsp;
+           </div>
+<div id="menu">
+<div onclick="SwitchMenu('menu_selected_1.1', 'skin/')" id="menu_selected_1.1Title" class="menutitle" style="background-image: url('skin/images/chapter_open.gif');">Community</div>
+<div id="menu_selected_1.1" class="selectedmenuitemgroup" style="display: block;">
+<div class="menuitem">
+<a href="derby_comm.html">Get Involved!</a>
+</div>
+<div class="menuitem">
+<a href="faq.html">FAQs</a>
+</div>
+<div class="menuitem">
+<a href="derby_mail.html">Mailing Lists</a>
+</div>
+<div class="menuitem">
+<a href="http://wiki.apache.org/db-derby">Derby Wiki</a>
+</div>
+<div class="menuitem">
+<a href="DerbyBugGuidelines.html">BUGS</a>
+</div>
+<div class="menuitem">
+<a href="derby_tests.html">Tests</a>
+</div>
+<div class="menupage">
+<div class="menupagetitle">Logo</div>
+</div>
+<div class="menuitem">
+<a href="papers/derby_web.html">Updating the web site</a>
+</div>
+</div>
+<div class="searchbox">
+<hr>
+<form action="http://www.google.com/search" method="get">
+<input value="db.apache.org" name="sitesearch" type="hidden"><input onFocus="getBlank (this, 'Search the site with google');" size="18" name="q" id="query" type="text" value="Search the site with google">&nbsp; 
+                  <input attr="value" name="Search" value="Search" type="submit">
+</form>
+</div>
+<div id="credit"></div>
+<div id="roundbottom">
+<img style="display: none" class="corner" height="15" width="15" alt="" src="skin/images/rc-b-l-15-1body-2menu-3menu.png"></div>
+<div id="credit2"></div>
+</div>
+<div id="content">
+<div class="trail">
+<text>Font size:</text> 
+	          &nbsp;<input value="Reset" class="resetfont" title="Reset text" onclick="ndeSetTextSize('reset'); return false;" type="button">      
+	          &nbsp;<input value="-a" class="smallerfont" title="Shrink text" onclick="ndeSetTextSize('decr'); return false;" type="button">
+	          &nbsp;<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
+</div>
+<h1>Apache Derby: Logo Contest</h1>
+<div id="minitoc-area">
+<ul class="minitoc">
+<li>
+<a href="#Contest+Results">Contest Results</a>
+</li>
+<li>
+<a href="#Contest+Rules">Contest Rules</a>
+</li>
+<li>
+<a href="#Entries">Entries</a>
+</li>
+</ul>
+</div>
+
+
+<a name="N1000C"></a><a name="Contest+Results"></a>
+<h2 class="boxed">Contest Results</h2>
+<div class="section">
+<p>
+The vote closed at noon PST on Dec 7, 2005, and 
+<a class="external" href="http://mail-archives.apache.org/mod_mbox/db-derby-user/200512.mbox/%3c43974AD5.9020304@sun.com%3e">Roger Dudler's entries won</a>:
+</p>
+<ul>
+ 
+<li>
+<a class="external" href="http://issues.apache.org/jira/secure/attachment/12321022/derby_logo_only.jpg">derby_logo_only.jpg</a>
+</li>
+ 
+<li>
+<a class="external" href="http://issues.apache.org/jira/secure/attachment/12321023/derby_with_text.jpg">derby_with_text.jpg</a>
+</li>
+ 
+<li>
+<a class="external" href="http://issues.apache.org/jira/secure/attachment/12321055/roger_full_showcase.jpg">roger_full_showcase.jpg</a>
+</li>
+
+</ul>
+<p>
+Thanks to everyone for participating!
+</p>
+</div>
+
+
+<a name="N1002F"></a><a name="Contest+Rules"></a>
+<h2 class="boxed">Contest Rules</h2>
+<div class="section">
+<div class="frame note">
+<div class="label">Note</div>
+<div class="content">
+The contest is now over.
+This section left for historical reasons. 
+</div>
+</div>
+<p>
+Derby needs a logo!  
+This contest is open to anyone in the Derby community who would like to submit
+an image for the Apache Derby logo.
+The contest was kicked off on
+<a class="external" href="http://mail-archives.apache.org/mod_mbox/db-derby-user/200505.mbox/%3c20050503184855.71659.qmail@web81310.mail.yahoo.com%3e">May 3, 2005</a>.
+Please participate in the creation of rules on the
+<a href="derby_mail.html">derby-user@db.apache.org</a> mail list.
+</p>
+</div>
+
+
+<a name="N10044"></a><a name="Entries"></a>
+<h2 class="boxed">Entries</h2>
+<div class="section">
+<div class="frame note">
+<div class="label">Note</div>
+<div class="content">
+The contest is now over.
+This section left for historical reasons. 
+</div>
+</div>
+<p>
+Please attach logo entries to Jira issue
+<a class="external" href="http://issues.apache.org/jira/browse/DERBY-297">DERBY-297</a>.
+Anyone can upload a logo to this Jira issue.  
+You do need a Jira id, which you can sign up for at
+<a class="external" href="http://issues.apache.org/jira/">http://issues.apache.org/jira/</a>.
+</p>
+<p>
+When you upload attachments to Jira, 
+you have two options:
+</p>
+<ul>
+ 
+<li>Grant license to ASF for inclusion in ASF works (as per the
+     <a class="external" href="http://www.apache.org/licenses/LICENSE-2.0">Apache
+     Software License</a>)</li>
+ 
+<li> Attachment not intended for inclusion</li>
+
+</ul>
+<p>
+The only logos that will be considered are those for which the
+license has been granted to the ASF.
+But only grant the license to the ASF if you are entitled to do so.
+Don't include any elements to which you don't have rights or permission.
+</p>
+</div>
+
+
+<p>
+
+<em>Last updated: December 7, 2005</em>
+
+</p>
+
+</div>
+<div class="clearboth">&nbsp;</div>
+</div>
+<div id="footer">
+<div class="lastmodified">
+<script type="text/javascript"><!--
+document.write("<text>Last Published:</text> " + document.lastModified);
+//  --></script>
+</div>
+<div class="copyright">
+        Copyright &copy;
+         2004-2006 Apache Software Foundation</div>
+<div id="feedback">
+    Send feedback about the website to:
+  <a id="feedbackto" href="mailto:derby-dev@db.apache.org?subject=Feedback%C2%A0logo_contest.html">derby-dev@db.apache.org</a>
+</div>
+</div>
+</body>
+</html>

Added: websites/production/db/content/derby/manuals/dita.html
==============================================================================
--- websites/production/db/content/derby/manuals/dita.html (added)
+++ websites/production/db/content/derby/manuals/dita.html Wed Dec 19 18:20:21 2012
@@ -0,0 +1,872 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+<html>
+<head>
+<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
+<meta content="Apache Forrest" name="Generator">
+<meta name="Forrest-version" content="0.8">
+<meta name="Forrest-skin-name" content="pelt">
+<title>Apache Derby: DITA-sourced documentation</title>
+<link type="text/css" href="../skin/basic.css" rel="stylesheet">
+<link media="screen" type="text/css" href="../skin/screen.css" rel="stylesheet">
+<link media="print" type="text/css" href="../skin/print.css" rel="stylesheet">
+<link type="text/css" href="../skin/profile.css" rel="stylesheet">
+<script src="../skin/getBlank.js" language="javascript" type="text/javascript"></script><script src="../skin/getMenu.js" language="javascript" type="text/javascript"></script><script src="../skin/fontsize.js" language="javascript" type="text/javascript"></script>
+<link rel="shortcut icon" href="../">
+</head>
+<body onload="init()">
+<script type="text/javascript">ndeSetTextSize();</script>
+<div id="top">
+<!--+
+    |breadtrail
+    +-->
+<div class="breadtrail">
+<a href="http://www.apache.org/">apache</a> &gt; <a href="http://db.apache.org/">db</a><script src="../skin/breadcrumbs.js" language="JavaScript" type="text/javascript"></script>
+</div>
+<!--+
+    |header
+    +-->
+<div class="header">
+<!--+
+    |start group logo
+    +-->
+<div class="grouplogo">
+<a href="http://db.apache.org/derby"><img class="logoImage" alt="Apache Derby" src="../images/derby-logo-web.png" title="Derby is a zero-admin Java RDBMS"></a>
+</div>
+<!--+
+    |end group logo
+    +-->
+<!--+
+    |start Project Logo
+    +-->
+<div class="projectlogoA1">
+<a href="http://db.apache.org"><img class="logoImage" alt="Apache DB Project" src="../images/db-logo-white.png" title="Apache DB creates and maintains database solutions."></a>
+</div>
+<!--+
+    |end Project Logo
+    +-->
+<!--+
+    |start Tabs
+    +-->
+<ul id="tabs">
+<li>
+<a class="unselected" href="../index.html">Home</a>
+</li>
+<li>
+<a class="unselected" href="../quick_start.html">Quick Start</a>
+</li>
+<li>
+<a class="unselected" href="../derby_downloads.html">Download</a>
+</li>
+<li>
+<a class="unselected" href="../derby_comm.html">Community</a>
+</li>
+<li class="current">
+<a class="selected" href="../manuals/index.html">Documentation</a>
+</li>
+<li>
+<a class="unselected" href="../blogs/index.html">Resources</a>
+</li>
+</ul>
+<!--+
+    |end Tabs
+    +-->
+</div>
+</div>
+<div id="main">
+<div id="publishedStrip">
+<!--+
+    |start Subtabs
+    +-->
+<div id="level2tabs"></div>
+<!--+
+    |end Endtabs
+    +-->
+<script type="text/javascript"><!--
+document.write("Last Published: " + document.lastModified);
+//  --></script>
+</div>
+<!--+
+    |breadtrail
+    +-->
+<div class="breadtrail">
+
+             &nbsp;
+           </div>
+<!--+
+    |start Menu, mainarea
+    +-->
+<!--+
+    |start Menu
+    +-->
+<div id="menu">
+<div onclick="SwitchMenu('menu_selected_1.1', '../skin/')" id="menu_selected_1.1Title" class="menutitle" style="background-image: url('../skin/images/chapter_open.gif');">Documentation</div>
+<div id="menu_selected_1.1" class="selectedmenuitemgroup" style="display: block;">
+<div class="menuitem">
+<a href="../manuals/index.html">Overview</a>
+</div>
+<div class="menupage">
+<div class="menupagetitle">DITA Source</div>
+</div>
+<div class="menuitem">
+<a href="../manuals/guidelines.html">Writing Guidelines</a>
+</div>
+<div class="menuitem">
+<a href="../manuals/messages.html">Documenting Messages</a>
+</div>
+<div class="menuitem">
+<a href="../manuals/docsfaq.html">Writing FAQs</a>
+</div>
+<div class="menuitem">
+<a href="../manuals/docscheck.html">Release Checklist</a>
+</div>
+</div>
+<!--+
+    |start Search
+    +-->
+<div class="searchbox">
+<hr>
+<form action="http://www.google.com/search" method="get">
+<input value="db.apache.org" name="sitesearch" type="hidden"><input onFocus="getBlank (this, 'Search the site with google');" size="18" name="q" id="query" type="text" value="Search the site with google">&nbsp; 
+                  <input name="Search" value="Search" type="submit">
+</form>
+</div>
+<!--+
+    |end search
+    +-->
+<div id="credit"></div>
+<div id="roundbottom">
+<img style="display: none" class="corner" height="15" width="15" alt="" src="../skin/images/rc-b-l-15-1body-2menu-3menu.png"></div>
+<!--+
+  |alternative credits
+  +-->
+<div id="credit2"></div>
+</div>
+<!--+
+    |end Menu
+    +-->
+<!--+
+    |start content
+    +-->
+<div id="content">
+<div class="trail">Font size: 
+	          &nbsp;<input value="Reset" class="resetfont" title="Reset text" onclick="ndeSetTextSize('reset'); return false;" type="button">      
+	          &nbsp;<input value="-a" class="smallerfont" title="Shrink text" onclick="ndeSetTextSize('decr'); return false;" type="button">
+	          &nbsp;<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
+</div>
+<h1>Apache Derby: DITA-sourced documentation</h1>
+<div id="minitoc-area">
+<ul class="minitoc">
+<li>
+<a href="#Setting+up+your+environment">Setting up your environment</a>
+</li>
+<li>
+<a href="#Locating+the+correct+DITA+file">Locating the correct DITA file</a>
+</li>
+<li>
+<a href="#Editing+DITA+files">Editing DITA files</a>
+</li>
+<li>
+<a href="#Creating+output">Creating output</a>
+</li>
+<li>
+<a href="#DITA+file+names">DITA file names</a>
+</li>
+<li>
+<a href="#Modifying+the+output+format">Modifying the output format</a>
+</li>
+<li>
+<a href="#Submitting+documentation+patches">Submitting documentation patches</a>
+</li>
+<li>
+<a href="#Committing+documentation+patches">Committing documentation patches</a>
+</li>
+</ul>
+</div> 
+
+
+<p>
+Starting with Derby 10.1,
+each Derby manual is sourced in an XML implementation called the Darwin Information Typing Architecture, or DITA.  The original HTML source for the Derby documentation was converted to DITA to create an easy solution for requirements such as creating PDF outputs or single HTML files for each manual (See the 
+<a class="external" href="http://mail-archives.apache.org/mod_mbox/db-derby-dev/200410.mbox/%3c200410071315.32497.Joel.Rosi-Schwartz@Etish.org%3e">Derby 
+documentation in PDF format</a> thread).
+</p>
+
+<p>This page lists the software required to convert the DITA-sourced documentation into HTML or PDF, and describes how to convert the DITA source to the desired outputs.  These instructions describe how to use an <span class="codefrag">ant</span> build file with the DITA Toolkit to create output.</p>
+
+
+<a name="N1001A"></a><a name="Setting+up+your+environment"></a>
+<h2 class="boxed">Setting up your environment</h2>
+<div class="section">
+<p>
+Requirements:</p>
+<ul>
+
+<li>
+<p>The binary download of the <a class="external" href="http://prdownloads.sourceforge.net/dita-ot/DITA-OT1.1.2.1_bin-ASL.zip?download">DITA Toolkit</a> Version 1.1.2.1 
+from <a class="external" href="http://sourceforge.net/projects/dita-ot">SourceForge</a>. Use ONLY this version.</p>
+</li>
+
+<li>
+<p>Derby's DITA source files, Apache FOP, and the <span class="codefrag">build.xml</span> file used with ant to build the output.  These can ALL be extracted at once using svn: </p>
+<pre class="code">
+<a class="external" href="http://svnbook.red-bean.com/en/1.1/re04.html">svn checkout</a> https://svn.apache.org/repos/asf/db/derby/docs/trunk/</pre>
+Note that the <span class="codefrag">https</span> is required (not <span class="codefrag">http</span>) if you will
+be committing changes.
+</li>
+
+<li>
+<p>
+<a class="external" href="http://ant.apache.org/">Apache Ant</a> version 1.6.2 or later</p>
+</li>
+
+<li>Any JDK 1.4.2 or later. Java's reference implementation is at <a class="external" href="http://java.sun.com/javase/">http://java.sun.com/javase/</a>.</li>
+
+<li> Set up your subversion configuration file according to
+     the <a class="external" href="http://www.apache.org/dev/version-control.html#https-svn">ASF
+     instructions</a>.
+     Apache provides an
+     <a class="external" href="http://www.apache.org/dev/svn-eol-style.txt">initial
+     configuration file</a> file that sets properties, such as
+     line endings, for various file types
+     (more information is in the
+     <a class="external" href="http://svnbook.red-bean.com/en/1.1/ch07.html">subversion 
+     documentation</a>).
+     Add these DITA file types to your configuration file:
+<pre class="code">*.dita = svn:eol-style=native
+*.ditamap = svn:eol-style=native</pre>
+
+</li>
+
+</ul>
+<p>To set up your environment for creating output from DITA-source:
+</p>
+<ol>
+<li>Install the JDK 1.4.2 or later implementation.</li>
+
+<li>
+<p>Extract the DITA source files, Apache FOP, and the <span class="codefrag">build.xml</span> file from svn using the command described above. We will call the extraction home directory <span class="codefrag">%DOC_ROOT%/trunk</span>.  For example, after extracting, the <em>Getting Started with Derby</em> DITA files would be located in <span class="codefrag">%DOC_ROOT%/trunk/src/getstart/</span>.
+</p>
+</li>
+
+<li>
+<p>Place the downloaded DITA-OT1.1.2.1_bin-ASL.zip file into the lib directory where you have checked out the DITA source files, <span class="codefrag">%DOC_ROOT%/trunk/lib</span>. The first time you build one of the manuals, Ant will extract the DITA Toolkit to the <span class="codefrag">%DOC_ROOT%/trunk/</span> directory.  After extraction, the DITA Toolkit files should be located in <span class="codefrag">%DOC_ROOT%/trunk/DITA-OT1.1.2.1/</span>.</p>
+</li>
+
+<li>
+<p>Install Apache Ant, and make sure to follow the <a class="external" href="http://ant.apache.org/manual/index.html">instructions</a> for setting your environment variables.</p>
+If you encounter problems with running out of memory on the doc build, 
+set the
+<span class="codefrag">ANT_OPTS</span> environment variable to <span class="codefrag">"-Xms100m -Xmx200m"</span>.
+</li>
+
+<li>
+<p>For PDF output: Make sure to include the <span class="codefrag">fop.jar</span>, <span class="codefrag">avalon-framework-cvs-20020806.jar</span>, and <span class="codefrag">batik.jar</span> files located in <span class="codefrag">%DOC_ROOT%/trunk/lib/</span> in your <span class="codefrag">CLASSPATH</span> environment variable.</p>
+</li>
+
+</ol>
+</div>
+
+
+<a name="N100AF"></a><a name="Locating+the+correct+DITA+file"></a>
+<h2 class="boxed">Locating the correct DITA file</h2>
+<div class="section">
+<p>The simpliest way to determine the name of the file that contains the information that you want to update is to:</p>
+<ol>
+
+<li>
+<p>Go to the Derby Documentation <a href="http://db.apache.org/derby/manuals/index.html">Overiew</a> page.</p>
+</li>
+
+<li>
+<p>Under the section <strong>Latest Alpha Manuals</strong>, click the link for the HTML Pages for the manual that contains the information that you want to update.</p>
+</li>
+
+<li>
+<p>An outline of the manual topics appears on the left side of the screen. Use the outline to find the topic that you want to update.</p>
+</li>
+
+<li>
+<p>In the outline, right-click on the topic name and choose <strong>properties</strong>. The name of the file is at the top of the dialog.  The address (URL) contains the path and name of the file. For example, if the address contains <span class="codefrag">http://db.apache.org/derby/docs/dev/getstart/cgsquck19524.html</span>, the fliename for the topic that you want to update is <strong>cgsquck19524.dita</strong>
+</p>
+</li>
+
+</ol>
+<p>
+Guidelines for writing Derby information using DITA is on the Derby Documentation  
+<a href="http://db.apache.org/derby/manuals/guidelines.html">Writing Guidelines</a> page.</p>
+<p>To learn more about DITA, how to create or edit DITA files, and find more XML editors that support DITA, go to:</p>
+<pre class="code">
+<a class="external" href="http://dita.xml.org/">http://dita.xml.org/</a>
+</pre>
+</div> 
+
+
+<a name="N100EA"></a><a name="Editing+DITA+files"></a>
+<h2 class="boxed">Editing DITA files</h2>
+<div class="section">
+<p>DITA is an XML specification.  You can edit DITA files in any text editor, but XML editors allow you to insert and modifiy tags easily while conforming to the DITA DTD and schemas.  It is HIGHLY recommended that you use an XML editor to avoid errors in tagging.</p>
+<p>There are many different XML editors available at various costs and some for no cost at all. Make sure to read the licenses for any XML editor you use to modify Derby DITA documentation. Some XML editors include:</p>
+<ul>
+
+<li>
+<a class="external" href="http://www.ptc.com/appserver/mkt/products/home.jsp?k=3593">Arbortext Editor</a>
+</li>
+
+<li>
+<a class="external" href="http://www.oxygenxml.com">oXygen</a>
+</li>
+
+<li>
+<a class="external" href="http://xmlbuddy.com/">XML Buddy</a> (an <a class="external" href="http://www.eclipse.org/">Eclipse</a> plugin)</li>
+
+<li>
+<a class="external" href="http://www.altova.com">Altova XML Spy</a>
+</li>
+
+</ul>
+<p>Guidelines for writing Derby information using DITA is on the Derby Documentation <a href="http://db.apache.org/derby/manuals/guidelines.html">Writing Guidelines</a> page.</p>
+<p>To learn more about DITA, how to create or edit DITA files, and find more XML editors that support DITA, go to:</p>
+<pre class="code">
+<a class="external" href="http://dita.xml.org/">http://dita.xml.org/&gt;</a>
+</pre>
+</div>
+
+
+<a name="N10122"></a><a name="Creating+output"></a>
+<h2 class="boxed">Creating output</h2>
+<div class="section">
+<p>To create output from the DITA source files:</p>
+<ol>
+
+<li>From a command line, navigate to <span class="codefrag">%DOC_ROOT%/trunk/</span>.</li>
+
+<li>Enter the desired <span class="codefrag">ant</span> command on the command line using the following syntax:
+<pre class="code">ant &lt;output_type&gt;.&lt;manual_id&gt;</pre>
+The <span class="codefrag">&lt;output_type&gt;</span> is the format of the output you wish to create.
+The options are HTML, PDF, or monohtml.  The <span class="codefrag">&lt;manual_id&gt;</span> is 
+the id of the manual that you want to output.  The id is the same as the name 
+of the directory containing that manual's DITA source files in 
+<span class="codefrag">%DOC_ROOT%/trunk/src/</span>. A list of the ids are shown in the table
+below. For example, to create PDF output for the 
+<em>Getting Started with Derby</em> guide, enter the following command:
+<pre class="code">ant pdf.getstart</pre> 
+
+</li>
+
+</ol>
+<p>
+To create PDF or HTML output for ALL SIX manuals at once, specify the output 
+type with no manual. For example:</p>
+<pre class="code">ant pdf</pre>
+<p>or</p>
+<pre class="code">ant html</pre>
+<p>or</p>
+<pre class="code">ant monohtml</pre>
+<p>To create all three output formats for just one manual, enter the manual 
+with no type. For example, the command shown below builds PDF, HTML, and MONOHTML
+for the <em>Getting Started with Derby</em> guide:</p>
+<pre class="code">ant getstart</pre>
+<p>
+<strong>Note:</strong> <span class="codefrag">monohtml</span> creates a single HTML file for 
+the manual you specify, while <span class="codefrag">html</span> creates multiple HTML files 
+with a navigation tree.</p>
+<p>The output files will be built by the ant file and placed in the 
+<span class="codefrag">%DOC_ROOT%/trunk/out/</span> directory.  If any of the software is not 
+set up and configured correctly, the build will fail.</p>
+<p>The following table lists the manual id's for each Derby manual:</p>
+<table class="ForrestTable" cellspacing="1" cellpadding="4">
+
+   
+<tr> 
+    
+<th colspan="1" rowspan="1">Manual ID</th>
+    <th colspan="1" rowspan="1">Derby Manual</th>
+   
+</tr> 
+
+
+<tr> 
+         
+<td colspan="1" rowspan="1">adminguide</td>
+         <td colspan="1" rowspan="1">Derby Server and Administration Guide</td>
+   
+</tr> 
+
+   
+<tr> 
+         
+<td colspan="1" rowspan="1">getstart</td>
+         <td colspan="1" rowspan="1">Getting Started with Derby</td>
+   
+</tr> 
+
+<tr> 
+         
+<td colspan="1" rowspan="1">devguide</td>
+         <td colspan="1" rowspan="1">Derby Developer's Guide</td>
+   
+</tr> 
+
+<tr> 
+         
+<td colspan="1" rowspan="1">ref</td>
+         <td colspan="1" rowspan="1">Derby Reference Manual</td>
+   
+</tr> 
+
+<tr> 
+         
+<td colspan="1" rowspan="1">tools</td>
+         <td colspan="1" rowspan="1">Derby Tools and Utilities Guide</td>
+   
+</tr> 
+
+<tr> 
+         
+<td colspan="1" rowspan="1">tuning</td>
+         <td colspan="1" rowspan="1">Tuning Derby</td>
+   
+</tr>
+
+</table>
+</div>
+
+<a name="N101E0"></a><a name="DITA+file+names"></a>
+<h2 class="boxed">DITA file names</h2>
+<div class="section">
+<p>Dita files are named to provide a sense of what type of topic they contain as well as to which manual they belong.  All DITA topics are classified as either concepts, tasks, or reference material.  Thus, every file begins with either a "c", "t", or "r".  In addition, the letters that appear immediately after this first one provide a shorthand id for the manual.  For example, the <span class="codefrag">Getting Started with Derby</span> manual uses "gs", so a reference topic DITA file in that manual will start with "rgs".  Subsequent letters in the file name may provide hints at the topic's section within the manual, as well as numbers distinguishing it from other DITA files.</p>
+<p>It is suggested that any new DITA files that you may add follow this naming scheme to maintain organization of the files.</p>
+</div>
+
+
+<a name="N101EF"></a><a name="Modifying+the+output+format"></a>
+<h2 class="boxed">Modifying the output format</h2>
+<div class="section">
+<p>You may wish to modify the output created by the DITA Toolkit to fix organization, formatting, links, indexing, etc.  To do this, you will have to modify the xsl files distributed with the DITA Toolkit.  The instructions for which files to modify and how are included within the Toolkit documentation.  To modify the PDF output, it is recommended that you make changes only to the <span class="codefrag">dita2fo_shell.xsl</span> file.</p>
+<p>
+You are invited to submit your modified xsl files to <span class="codefrag">derby-dev</span>.  If you wish to use a modified xsl file, just replace the version of the file in the toolkit with the new one.
+</p>
+</div>
+
+
+<p>
+Please post feedback to the 
+<a href="../derby_mail.html">derby-dev</a> mail list.
+</p>
+
+
+<a name="N10208"></a><a name="Submitting+documentation+patches"></a>
+<h2 class="boxed">Submitting documentation patches</h2>
+<div class="section">
+<p> 
+
+<strong>Contribution guidelines</strong>
+
+</p>
+<p>
+If you would like to participate directly in any Derby development (including documentation changes), 
+be sure to read the guidelines found <a href="http://db.apache.org/derby/derby_comm.html#Contribute+Code+or+Documentation">here</a>.
+</p>
+<p> 
+
+<strong>How to create a patch</strong>
+
+</p>
+<ol>
+
+<li>
+<a class="external" href="http://issues.apache.org/jira/browse/DERBY">Open a Jira issue</a> 
+       under the documentation component for Derby, if one has not already 
+       been created for this issue.  You will be posting your patch to the entry. 
+       You can also create a documentation subtask to an existing JIRA entry for 
+       code changes if your change is to reflect a bug fix, new feature, etc.
+       <br>
+       
+</li>
+
+<li> 
+     
+<p>
+     Sync up your local svn copy with any changes checked into the server:
+     </p>
+     
+<pre class="code">
+     cd &lt;my_derby_loc&gt;/trunk
+     svn update</pre>
+     
+</li>
+
+<li> 
+     
+<p>
+     Make your changes. 
+     </p>
+     
+<ul>
+    
+<li>
+    
+<p>
+    If you are adding a new file, add a topicref for the new file to the 
+    ditamap. You need to place the topicref in the ditamap exactly where you 
+    want the new topic to appear in the manual.  You must also add the file 
+    using svn.
+    The example below shows adding a file named 
+    <span class="codefrag">cgsnewditafile.dita</span> to the <span class="codefrag">Getting Started Guide</span>,
+    using the command line:
+    </p>
+
+    
+<pre class="code">
+    svn add src/getstart/cgsnewditafile.dita 
+    </pre>
+    
+<p>
+    If you are using TortoiseSVN, you can add the file to svn through Windows
+    Explorer. 
+    </p>
+    
+<br>
+    
+<p>After you add the file to the repository, it's important to set the 
+    end-of-line property for the file to <span class="codefrag">native</span>. This is because
+    people making documentation contributions work on different operating systems.
+    You can set this property explicitly with the command shown below: </p>  
+    
+    
+<pre class="code">svn propset svn:eol-style native src/getstart/cgsnewditafile.dita </pre>
+    
+    
+<p>However, the easiest way to manage the <span class="codefrag">svn:eol-style</span> property 
+    is to automatically set end of line for common file types by adding the   
+    <a class="external" href="http://www.apache.org/dev/svn-eol-style.txt">Apache dev list  
+    of files to your ~/.subversion/config file</a>.</p>
+    
+<br>
+  
+</li>
+  
+<li>
+    
+<p>
+    If you are deleting a file, remove the topicref from the ditamap and
+    delete the file using svn.
+    The example below shows deleting a file named 
+    <span class="codefrag">rdevcsecure131.dita</span> in the 
+    <span class="codefrag">Developer's Guide</span> using the command line:
+    </p>
+    
+<pre class="code">
+    svn del src/devguide/rdevcsecure131.dita
+    </pre>
+    
+<p>
+    If you are using TortoiseSVN, you can delete the file through Windows
+    Explorer.  
+    </p>
+    
+<br>
+  
+</li>
+  
+</ul>
+
+</li> 
+
+<li> 
+
+<p>
+Test your changes.
+</p> 
+   
+<ul>
+   
+<li>At the very least run <span class="codefrag">ant html.&lt;manual_id&gt;</span> and 
+   <span class="codefrag">ant pdf.&lt;manual_id&gt;</span> 
+   to create the HTML and PDF outputs for the book that you are changing.</li>
+   
+<li>Verify that the PDF docs were actually created. If they weren't created, 
+   doublecheck that the <span class="codefrag">fop.jar</span>, 
+   <span class="codefrag">avalon-framework-cvs-20020806.jar</span>, and <span class="codefrag">batik.jar</span> 
+   files are in your <span class="codefrag">CLASSPATH</span>.</li>
+   
+<li>Make sure no new errors or build failures result from your changes.</li>
+   
+<li>Check that the output looks correct.</li>
+   
+<li>This is the documentation that users will read, so please check your 
+   writing for spelling, grammar, and punctuation mistakes.  </li>
+   
+</ul>
+
+<br>
+
+</li>
+
+<li>
+
+<p>Make the patch. 
+</p>
+
+<ul> 
+
+<li>Be sure to create the patch from the <span class="codefrag">trunk/</span> directory.</li> 
+
+<li>Run "svn stat" to see a list of the files that have been modified, added, 
+or deleted.</li> 
+
+<li>Specify the JIRA issue in the patch name.</li> 
+
+<li>If you think that there will be comments on your patch you should consider 
+adding a number to the end of the patch name to making tracking subsequent patches
+easier.</li> 
+    
+</ul>
+     
+<br>
+    
+<p>The following command creates a patch with all the diffs in your
+    working copy. </p>
+    
+<pre class="code">
+    svn diff &gt; derby2222.diff
+    </pre>
+    
+<p>The following command simply adds "ref" to the patch name, to indicate 
+    that the patch contains updates to the Reference  manual. </p>
+    
+<pre class="code">
+    svn diff &gt; derby2222-ref.diff
+    </pre>
+    
+<p> 
+    You can also create a patch with changes for just one book, as shown below:
+    </p> 
+    
+<pre class="code">
+    svn diff src/tuning &gt; derby2222-tuning1.diff
+    </pre>
+
+</li>
+
+<li>Create a zip file of the HTML (and perhaps DITA) files
+    <p>It will be necessary for the community to review your changes, and the best 
+     way to do that is to see the HTML output that reflects your changes.  Since you 
+     have already created HTML output when testing your changes, simply add the 
+     relevant HTML files to a zip file.</p>
+     
+<p>If you are new to DITA, it is a good idea to include the DITA files in the 
+     zip file.  This will give the community the opportunity to review the tagging
+    that you used to ensure that consistent tagging is used in all Derby topics.
+     </p>
+
+<br>
+
+</li>
+
+<li> 
+     
+<p> 
+    Attach the zip file to the appropriate JIRA entry.
+     </p> 
+     
+<p> 
+    Include the following information with your attachment:
+        </p> 
+     
+<ul>
+    
+<li>Which manuals are affected by your changes, and whether you tested them for 
+    successful building.</li>
+    
+<li>For a feature, bug fix, or large overhaul of the documentation, a 
+    description of the detailed functionality or reasons for the changes documented 
+    is essential.</li>
+    
+<li>If you added or deleted files, post the results from "svn stat" in the
+    JIRA issue.</li>
+    
+</ul>
+
+</li>
+
+
+</ol>
+</div>
+
+
+<a name="N102FB"></a><a name="Committing+documentation+patches"></a>
+<h2 class="boxed">Committing documentation patches</h2>
+<div class="section">
+<p>You must be a Derby committer to commit Derby patches.</p>
+<ol>
+   
+<li>
+   
+<p>Set up your environment (download required software, checkout Derby
+        documentation source, set environment variables) as described in the
+       <a href="#Setting+up+your+environment">Setting up your environment</a>
+       section.</p>
+      
+<ul>
+      
+<li>Don't forget to update your 
+     <a class="external" href="http://www.apache.org/dev/version-control.html#https-svn">subversion
+     configuration file</a> with these entries:
+     
+     <pre class="code">*.dita = svn:eol-style=native
+*.ditamap = svn:eol-style=native</pre>
+     
+</li>
+     
+     
+<li>If you already have your environment setup, then you need to 
+     check out the Derby documentation source into a new directory and prepare 
+     your environment to generate output.
+     <br>
+     
+</li>
+     
+     
+<li>If you use windows, you need to use a cygwin window to apply and commit 
+     the patch. Download cygwin from the <a class="external" href="http://www.cygwin.com/">
+     cygwin Web site</a>. When you open a cygwin window, you must use a FORWARD slash to 
+     change to a directory. For example:
+     <pre class="code">
+     $ cd c:/authoring/derby/commits </pre>
+     
+</li>
+     
+</ul>
+     
+</li>
+
+<li>The instructions in the 
+        <a href="#Submitting+documentation+patches">Submitting documentation 
+        patches</a> section tell contributors to create patches at the trunk
+        level, so download the patch to the trunk of your working copy.
+   <br>
+   
+<br>
+   
+</li>
+   
+<li>
+<p>Apply the patch using the GNU
+       <a class="external" href="http://en.wikipedia.org/wiki/Patch_(Unix)"><span class="codefrag">patch</span></a> 
+       command:</p>
+
+<pre class="code">
+<a class="external" href="http://linux.about.com/od/commands/l/blcmdl1_patch.htm">patch -p0</a> &lt; patchname.diff</pre>
+   
+</li>
+   
+<li>Check modifications with the
+       <a class="external" href="http://svnbook.red-bean.com/en/1.1/re26.html"><span class="codefrag">svn status</span></a>
+       command and add or delete any files as necessary. Follow the instuctions 
+       to <a class="external" href="http://wiki.apache.org/db-derby/AddedOrDeletedFilesInDiff">
+       add or delete files</a>.
+   <br>
+   
+</li>
+   
+<li>Follow the instructions in the
+       <a href="#Creating+output">Creating output</a> section
+        to verify the doc build succeeds.
+   <br>
+   
+<br>
+   
+</li>
+   
+<li>Commit the changes using the 
+       <a class="external" href="http://svnbook.red-bean.com/en/1.1/re06.html"><span class="codefrag">svn 
+       commit</span></a> command. 
+       <p>
+       Please include the following information in the log message:
+       </p>
+     
+<ul>
+         
+<li>DERBY Jira issue.</li>
+         
+<li>Description of the change.</li>
+         
+<li>Name of the patch contributor if you didn't author this change.</li>
+     
+</ul>
+   
+     
+<p>
+       Sample commit syntax is shown below for
+       changes made to the Developer's guide:</p>
+
+<pre class="code">
+<!--svn commit src/devguide -->
+svn commit --message "DERBY-1622: Add documentation for encrypting databases 
+using encryptionKey connection attribute. The patch derby1622-3.diff was
+contributed by Robin Williams." src/devguide
+
+svn commit --file /tmp/derby-1622.txt src/devguide
+</pre>
+<!--     The first command, without the
+        <code>message</code> or <code>file</code> arguments,
+        will pull up the editor defined by the
+        <a href="http://svnbook.red-bean.com/en/1.1/ch07.html">subversion
+        <code>editor-cmd</code> property or the
+        <code>SVN_EDITOR</code> environment variable</a>.-->
+     The <span class="codefrag">--message</span> argument lets you enter the log message on
+     the command line, and the
+     <span class="codefrag">--file</span> argument lets you set the log message from a file.
+    <br> 
+    
+<br>
+    
+</li>
+
+<li>Update the JIRA issue.
+<p>Copy the statement that is returned when you commit the patch
+(for example: Committed revision 513081) and paste it into a comment in the 
+JIRA issue. If the patch resolves the issue, mark the issue as resolved and
+remove the check from "Patch Available".
+</p>
+
+</li>
+
+</ol>
+</div>
+
+
+
+<p>
+<em>Last Updated: March 19, 2007</em>
+</p>
+
+</div>
+<!--+
+    |end content
+    +-->
+<div class="clearboth">&nbsp;</div>
+</div>
+<div id="footer">
+<!--+
+    |start bottomstrip
+    +-->
+<div class="lastmodified">
+<script type="text/javascript"><!--
+document.write("Last Published: " + document.lastModified);
+//  --></script>
+</div>
+<div class="copyright">
+        Copyright &copy;
+         2004-2012 Apache Software Foundation</div>
+<div id="feedback">
+    Send feedback about the website to:
+  <a id="feedbackto" href="mailto:derby-user@db.apache.org?subject=Feedback%C2%A0manuals/dita.html">derby-user@db.apache.org</a>
+</div>
+<!--+
+    |end bottomstrip
+    +-->
+</div>
+</body>
+</html>

Added: websites/production/db/content/derby/manuals/docscheck.html
==============================================================================
--- websites/production/db/content/derby/manuals/docscheck.html (added)
+++ websites/production/db/content/derby/manuals/docscheck.html Wed Dec 19 18:20:21 2012
@@ -0,0 +1,384 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+<html>
+<head>
+<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
+<meta content="Apache Forrest" name="Generator">
+<meta name="Forrest-version" content="0.8">
+<meta name="Forrest-skin-name" content="pelt">
+<title>Apache Derby: Release Checklist for Docs</title>
+<link type="text/css" href="../skin/basic.css" rel="stylesheet">
+<link media="screen" type="text/css" href="../skin/screen.css" rel="stylesheet">
+<link media="print" type="text/css" href="../skin/print.css" rel="stylesheet">
+<link type="text/css" href="../skin/profile.css" rel="stylesheet">
+<script src="../skin/getBlank.js" language="javascript" type="text/javascript"></script><script src="../skin/getMenu.js" language="javascript" type="text/javascript"></script><script src="../skin/fontsize.js" language="javascript" type="text/javascript"></script>
+<link rel="shortcut icon" href="../">
+</head>
+<body onload="init()">
+<script type="text/javascript">ndeSetTextSize();</script>
+<div id="top">
+<!--+
+    |breadtrail
+    +-->
+<div class="breadtrail">
+<a href="http://www.apache.org/">apache</a> &gt; <a href="http://db.apache.org/">db</a><script src="../skin/breadcrumbs.js" language="JavaScript" type="text/javascript"></script>
+</div>
+<!--+
+    |header
+    +-->
+<div class="header">
+<!--+
+    |start group logo
+    +-->
+<div class="grouplogo">
+<a href="http://db.apache.org/derby"><img class="logoImage" alt="Apache Derby" src="../images/derby-logo-web.png" title="Derby is a zero-admin Java RDBMS"></a>
+</div>
+<!--+
+    |end group logo
+    +-->
+<!--+
+    |start Project Logo
+    +-->
+<div class="projectlogoA1">
+<a href="http://db.apache.org"><img class="logoImage" alt="Apache DB Project" src="../images/db-logo-white.png" title="Apache DB creates and maintains database solutions."></a>
+</div>
+<!--+
+    |end Project Logo
+    +-->
+<!--+
+    |start Tabs
+    +-->
+<ul id="tabs">
+<li>
+<a class="unselected" href="../index.html">Home</a>
+</li>
+<li>
+<a class="unselected" href="../quick_start.html">Quick Start</a>
+</li>
+<li>
+<a class="unselected" href="../derby_downloads.html">Download</a>
+</li>
+<li>
+<a class="unselected" href="../derby_comm.html">Community</a>
+</li>
+<li class="current">
+<a class="selected" href="../manuals/index.html">Documentation</a>
+</li>
+<li>
+<a class="unselected" href="../blogs/index.html">Resources</a>
+</li>
+</ul>
+<!--+
+    |end Tabs
+    +-->
+</div>
+</div>
+<div id="main">
+<div id="publishedStrip">
+<!--+
+    |start Subtabs
+    +-->
+<div id="level2tabs"></div>
+<!--+
+    |end Endtabs
+    +-->
+<script type="text/javascript"><!--
+document.write("Last Published: " + document.lastModified);
+//  --></script>
+</div>
+<!--+
+    |breadtrail
+    +-->
+<div class="breadtrail">
+
+             &nbsp;
+           </div>
+<!--+
+    |start Menu, mainarea
+    +-->
+<!--+
+    |start Menu
+    +-->
+<div id="menu">
+<div onclick="SwitchMenu('menu_selected_1.1', '../skin/')" id="menu_selected_1.1Title" class="menutitle" style="background-image: url('../skin/images/chapter_open.gif');">Documentation</div>
+<div id="menu_selected_1.1" class="selectedmenuitemgroup" style="display: block;">
+<div class="menuitem">
+<a href="../manuals/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../manuals/dita.html">DITA Source</a>
+</div>
+<div class="menuitem">
+<a href="../manuals/guidelines.html">Writing Guidelines</a>
+</div>
+<div class="menuitem">
+<a href="../manuals/messages.html">Documenting Messages</a>
+</div>
+<div class="menuitem">
+<a href="../manuals/docsfaq.html">Writing FAQs</a>
+</div>
+<div class="menupage">
+<div class="menupagetitle">Release Checklist</div>
+</div>
+</div>
+<!--+
+    |start Search
+    +-->
+<div class="searchbox">
+<hr>
+<form action="http://www.google.com/search" method="get">
+<input value="db.apache.org" name="sitesearch" type="hidden"><input onFocus="getBlank (this, 'Search the site with google');" size="18" name="q" id="query" type="text" value="Search the site with google">&nbsp; 
+                  <input name="Search" value="Search" type="submit">
+</form>
+</div>
+<!--+
+    |end search
+    +-->
+<div id="credit"></div>
+<div id="roundbottom">
+<img style="display: none" class="corner" height="15" width="15" alt="" src="../skin/images/rc-b-l-15-1body-2menu-3menu.png"></div>
+<!--+
+  |alternative credits
+  +-->
+<div id="credit2"></div>
+</div>
+<!--+
+    |end Menu
+    +-->
+<!--+
+    |start content
+    +-->
+<div id="content">
+<div class="trail">Font size: 
+	          &nbsp;<input value="Reset" class="resetfont" title="Reset text" onclick="ndeSetTextSize('reset'); return false;" type="button">      
+	          &nbsp;<input value="-a" class="smallerfont" title="Shrink text" onclick="ndeSetTextSize('decr'); return false;" type="button">
+	          &nbsp;<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
+</div>
+<h1>Apache Derby: Release Checklist for Docs</h1>
+<div id="minitoc-area">
+<ul class="minitoc">
+<li>
+<a href="#Update+the+conrefs+files">Update the conrefs files</a>
+</li>
+<li>
+<a href="#Update+examples+in+the+manuals">Update examples in the manuals</a>
+</li>
+<li>
+<a href="#Check+the+licensing+and+copyright+information">Check the licensing and copyright information</a>
+</li>
+<li>
+<a href="#Update+the+ditamap+files">Update the ditamap files</a>
+</li>
+</ul>
+</div> 
+
+<p>
+For each release, the following list of items should be used as a checklist
+by the people making documentation contributions. This checklist contains
+items that should be reviewed (and updated) before each new Derby release is 
+approved and goes live.
+</p>
+
+<p>
+You can read a high-level writeup on 
+<a class="external" href="http://wiki.apache.org/db-derby/DerbySnapshotOrRelease">the actions 
+that need to be done for Derby releases</a>
+for more information.
+</p>
+
+<a name="N10017"></a><a name="Update+the+conrefs+files"></a>
+<h2 class="boxed">Update the conrefs files</h2>
+<div class="section">
+<p>
+
+<strong>WHEN: After each new release is made public</strong>
+
+<br>
+The conref files for the Derby manuals need to be updated so that the 
+Alpha versions of the manuals reflect the next release number.  
+This task needs to be completed for each new minor and point release.
+</p>
+<p>
+To complete this task:
+</p>
+<ol>
+
+<li>Ask on the derby-dev list what the correct release number is (minor
+or point).</li>
+
+<li>Create a JIRA issue for this task. </li>
+
+<li>Open the conrefs files for each Derby manual. For example: devconrefs.dita </li>
+
+<li>In the "Version and release numbers" section, change the ph tag for
+shortversionnumber. </li>
+
+<li> If this is a new major release, for example from 10 to 11,
+in the "Product specific entities" section change the ph tag for
+productinstallname.  </li>
+
+</ol>
+<p>
+If a new manual has been added to the Derby documentation set, you must list the
+new manual in the "pub" section in each conrefs file.
+</p>
+</div>
+
+<a name="N1003E"></a><a name="Update+examples+in+the+manuals"></a>
+<h2 class="boxed">Update examples in the manuals</h2>
+<div class="section">
+<p>
+
+<strong>WHEN: Before each new point release is made public, such as 10.3, 10.4</strong>
+
+<br>
+Some of the examples in the manuals contain specific 
+date references. For the documentation to be current, these references
+need to be updated each release.  
+</p>
+<p>
+In the <strong>Working with Derby</strong> 
+manual, the following files need to be updated:
+</p>
+<ul>
+
+<li>twwdactivity1.dita</li>
+
+<li>twwdactivity2.dita</li>
+
+<li>twwdactivity3_Setup.dita</li>
+
+<li>twwdactivity4.dita</li>
+
+</ul>
+<p>
+In the <strong>Reference Guide</strong> 
+manual, the following files need to be updated:
+</p>
+<ul>
+
+<li>rrefdayfunc.dita</li>
+
+</ul>
+<p>
+In the <strong>Developer's Guide</strong> 
+manual, the following files need to be updated:
+</p>
+<ul>
+
+<li>cdevdvlp27715.dita</li>
+
+</ul>
+<p>
+Additionally, some of the files in the <strong>Working with Derby</strong> guide 
+have specific release and tag values that need to be updated each release.  
+The following files need to be updated:
+</p>
+<ul>
+
+<li>twwdactivity1.dita</li>
+
+<li>twwdactivity2.dita</li>
+
+<li>twwdactivity4.dita</li>
+
+</ul>
+</div>
+
+<a name="N1008C"></a><a name="Check+the+licensing+and+copyright+information"></a>
+<h2 class="boxed">Check the licensing and copyright information</h2>
+<div class="section">
+<p>
+
+<strong>WHEN: As new files are created and before each new release is made public</strong>
+
+<br>
+Each new dita file that is created must contain licensing information 
+at the top of the file. This information is internal and does not print out.
+The template files contain this hidden licensing information. 
+</p>
+<p>
+If you used the DITA topic templates to create your new files, the licensing
+information should appear at the top of the topic in your editor. If you did not 
+use the template files, you must paste a copy of this information into each
+new topic that you created in this release. The templates 
+are located in the <strong>\trunk\templates</strong> directory.
+</p>
+<p>
+Additionally, each manual must display copyright information at the beginning
+of the output along with a date. The date should be updated as necessary.
+Sometimes the wording of the copyright changes. Check with <a href="../derby_mail.html">derby-dev</a>
+for any updates to the copyright wording. 
+</p>
+<p>
+If the licensing wording needs to be changed in all of the files, you can use
+the following steps to update the topics and the generated output:
+</p>
+<p>
+For more information on ASF copyright requirements, see the comments on
+JIRA issue <a class="external" href="https://issues.apache.org/jira/browse/DERBY-2227">Derby-2227.</a>  
+
+</p>
+</div>
+
+<a name="N100B2"></a><a name="Update+the+ditamap+files"></a>
+<h2 class="boxed">Update the ditamap files</h2>
+<div class="section">
+<p>
+
+<strong>WHEN: Only if the content has changed. This does not apply when
+only the formatting has changed. </strong>
+
+<br>
+For each manual, there is a ditamap file which contains a <strong>copyryear</strong>
+tag.  The tag displays 2 years, the first year the content in the manual was 
+developed and the last year that the content in the manual was modified. 
+If any file in a manual is updated during the year, the second year in the 
+<strong>copyryear</strong> tag must be updated.
+</p>
+<p>
+For example, if the tag has "copyryear year="2002,2006" and the contents are
+changed in 2007, you must update the second year so that the tag reads:
+</p>
+<pre class="code">copyryear year="2002,2007"</pre>
+</div>
+
+<p>
+
+<br>
+Please post feedback to the 
+<a href="../derby_mail.html">derby-dev</a> mail list.
+</p>
+
+
+<p>
+<em>Last Updated: January 29, 2007</em>
+</p>
+
+</div>
+<!--+
+    |end content
+    +-->
+<div class="clearboth">&nbsp;</div>
+</div>
+<div id="footer">
+<!--+
+    |start bottomstrip
+    +-->
+<div class="lastmodified">
+<script type="text/javascript"><!--
+document.write("Last Published: " + document.lastModified);
+//  --></script>
+</div>
+<div class="copyright">
+        Copyright &copy;
+         2004-2012 Apache Software Foundation</div>
+<div id="feedback">
+    Send feedback about the website to:
+  <a id="feedbackto" href="mailto:derby-user@db.apache.org?subject=Feedback%C2%A0manuals/docscheck.html">derby-user@db.apache.org</a>
+</div>
+<!--+
+    |end bottomstrip
+    +-->
+</div>
+</body>
+</html>

Added: websites/production/db/content/derby/manuals/docsfaq.html
==============================================================================
--- websites/production/db/content/derby/manuals/docsfaq.html (added)
+++ websites/production/db/content/derby/manuals/docsfaq.html Wed Dec 19 18:20:21 2012
@@ -0,0 +1,387 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+<html>
+<head>
+<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
+<meta content="Apache Forrest" name="Generator">
+<meta name="Forrest-version" content="0.8">
+<meta name="Forrest-skin-name" content="pelt">
+<title>Apache Derby: Writing FAQs</title>
+<link type="text/css" href="../skin/basic.css" rel="stylesheet">
+<link media="screen" type="text/css" href="../skin/screen.css" rel="stylesheet">
+<link media="print" type="text/css" href="../skin/print.css" rel="stylesheet">
+<link type="text/css" href="../skin/profile.css" rel="stylesheet">
+<script src="../skin/getBlank.js" language="javascript" type="text/javascript"></script><script src="../skin/getMenu.js" language="javascript" type="text/javascript"></script><script src="../skin/fontsize.js" language="javascript" type="text/javascript"></script>
+<link rel="shortcut icon" href="../">
+</head>
+<body onload="init()">
+<script type="text/javascript">ndeSetTextSize();</script>
+<div id="top">
+<!--+
+    |breadtrail
+    +-->
+<div class="breadtrail">
+<a href="http://www.apache.org/">apache</a> &gt; <a href="http://db.apache.org/">db</a><script src="../skin/breadcrumbs.js" language="JavaScript" type="text/javascript"></script>
+</div>
+<!--+
+    |header
+    +-->
+<div class="header">
+<!--+
+    |start group logo
+    +-->
+<div class="grouplogo">
+<a href="http://db.apache.org/derby"><img class="logoImage" alt="Apache Derby" src="../images/derby-logo-web.png" title="Derby is a zero-admin Java RDBMS"></a>
+</div>
+<!--+
+    |end group logo
+    +-->
+<!--+
+    |start Project Logo
+    +-->
+<div class="projectlogoA1">
+<a href="http://db.apache.org"><img class="logoImage" alt="Apache DB Project" src="../images/db-logo-white.png" title="Apache DB creates and maintains database solutions."></a>
+</div>
+<!--+
+    |end Project Logo
+    +-->
+<!--+
+    |start Tabs
+    +-->
+<ul id="tabs">
+<li>
+<a class="unselected" href="../index.html">Home</a>
+</li>
+<li>
+<a class="unselected" href="../quick_start.html">Quick Start</a>
+</li>
+<li>
+<a class="unselected" href="../derby_downloads.html">Download</a>
+</li>
+<li>
+<a class="unselected" href="../derby_comm.html">Community</a>
+</li>
+<li class="current">
+<a class="selected" href="../manuals/index.html">Documentation</a>
+</li>
+<li>
+<a class="unselected" href="../blogs/index.html">Resources</a>
+</li>
+</ul>
+<!--+
+    |end Tabs
+    +-->
+</div>
+</div>
+<div id="main">
+<div id="publishedStrip">
+<!--+
+    |start Subtabs
+    +-->
+<div id="level2tabs"></div>
+<!--+
+    |end Endtabs
+    +-->
+<script type="text/javascript"><!--
+document.write("Last Published: " + document.lastModified);
+//  --></script>
+</div>
+<!--+
+    |breadtrail
+    +-->
+<div class="breadtrail">
+
+             &nbsp;
+           </div>
+<!--+
+    |start Menu, mainarea
+    +-->
+<!--+
+    |start Menu
+    +-->
+<div id="menu">
+<div onclick="SwitchMenu('menu_selected_1.1', '../skin/')" id="menu_selected_1.1Title" class="menutitle" style="background-image: url('../skin/images/chapter_open.gif');">Documentation</div>
+<div id="menu_selected_1.1" class="selectedmenuitemgroup" style="display: block;">
+<div class="menuitem">
+<a href="../manuals/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../manuals/dita.html">DITA Source</a>
+</div>
+<div class="menuitem">
+<a href="../manuals/guidelines.html">Writing Guidelines</a>
+</div>
+<div class="menuitem">
+<a href="../manuals/messages.html">Documenting Messages</a>
+</div>
+<div class="menupage">
+<div class="menupagetitle">Writing FAQs</div>
+</div>
+<div class="menuitem">
+<a href="../manuals/docscheck.html">Release Checklist</a>
+</div>
+</div>
+<!--+
+    |start Search
+    +-->
+<div class="searchbox">
+<hr>
+<form action="http://www.google.com/search" method="get">
+<input value="db.apache.org" name="sitesearch" type="hidden"><input onFocus="getBlank (this, 'Search the site with google');" size="18" name="q" id="query" type="text" value="Search the site with google">&nbsp; 
+                  <input name="Search" value="Search" type="submit">
+</form>
+</div>
+<!--+
+    |end search
+    +-->
+<div id="credit"></div>
+<div id="roundbottom">
+<img style="display: none" class="corner" height="15" width="15" alt="" src="../skin/images/rc-b-l-15-1body-2menu-3menu.png"></div>
+<!--+
+  |alternative credits
+  +-->
+<div id="credit2"></div>
+</div>
+<!--+
+    |end Menu
+    +-->
+<!--+
+    |start content
+    +-->
+<div id="content">
+<div class="trail">Font size: 
+	          &nbsp;<input value="Reset" class="resetfont" title="Reset text" onclick="ndeSetTextSize('reset'); return false;" type="button">      
+	          &nbsp;<input value="-a" class="smallerfont" title="Shrink text" onclick="ndeSetTextSize('decr'); return false;" type="button">
+	          &nbsp;<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
+</div>
+<h1>Apache Derby: Writing FAQs</h1>
+<div id="minitoc-area">
+<ul class="minitoc">
+<li>
+<a href="#Cross+references%3A+To+another+DITA+topic+in+the+same+Derby+manual">Cross references: To another DITA topic in the same Derby manual</a>
+</li>
+<li>
+<a href="#Cross+references%3A+To+a+DITA+topic+in+a+different+Derby+manual">Cross references: To a DITA topic in a different Derby manual</a>
+</li>
+<li>
+<a href="#Cross+references%3A+To+a+Web+site">Cross references: To a Web site</a>
+</li>
+<li>
+<a href="#Code+Examples">Code Examples</a>
+</li>
+<li>
+<a href="#Semi-colon+use+at+the+end+of+statements+and+commands">Semi-colon use at the end of statements and commands</a>
+</li>
+<li>
+<a href="#SQL+terminology%3A+When+do+I+use+the+terms+statement%2C+clause%2C+parameter%2C+%0Aor+expression%3F">SQL terminology: When do I use the terms statement, clause, parameter, 
+or expression?</a>
+</li>
+</ul>
+</div>
+
+<a name="N1000D"></a><a name="Cross+references%3A+To+another+DITA+topic+in+the+same+Derby+manual"></a>
+<h2 class="boxed">Cross references: To another DITA topic in the same Derby manual</h2>
+<div class="section">
+<p>To create a cross reference to another DITA topic in the same Derby manual, 
+use the <strong>xref</strong> tag. You must specify the filename for the DITA 
+topic,  followed by the pound symbol and the ID specified inside the topic.
+</p>
+<p>For example:
+<br>
+
+</p>
+<pre class="code">
+&lt;xref href="rrefjdbc32052.dita#rrefjdbc32052"&gt;&lt;/xref&gt;
+</pre>
+<p>
+
+</p>
+</div>
+
+<a name="N10026"></a><a name="Cross+references%3A+To+a+DITA+topic+in+a+different+Derby+manual"></a>
+<h2 class="boxed">Cross references: To a DITA topic in a different Derby manual</h2>
+<div class="section">
+<p>Currently, you cannot create a cross reference to a DITA topic in a different 
+Derby manual. However, you can create a citation to the other manual.
+</p>
+<p>You specify the manual by using the <strong>cite</strong> and 
+<strong>conref</strong> tags. If you mention the name of the topic, 
+use quotations around the name of the topic. Here is an example:
+<br>
+
+</p>
+<pre class="code">
+For information about Derby properties, see the "derby.stream.error.logSeverityLevel property" topic 
+in the &lt;cite&gt; &lt;ph conref="refconrefs.dita#pub/cittuning"&gt;&lt;/ph&gt; guide&lt;/cite&gt; 
+for instructions on how to print more information to Derby log files.
+</pre>
+<p>
+
+</p>
+</div>
+
+<a name="N10042"></a><a name="Cross+references%3A+To+a+Web+site"></a>
+<h2 class="boxed">Cross references: To a Web site</h2>
+<div class="section">
+<p>To create a cross reference to a Web site, use the 
+<strong>xref</strong> tag. You must specify the type, href, and scope attributes.
+</p>
+<p>For example:
+<br>
+
+</p>
+<pre class="code">
+&lt;xref format="html" href="http://www.w3.org/TR/xpath" scope="external"&gt;http://www.w3.org/TR/xpath&lt;/xref&gt;
+</pre>
+<p>
+
+</p>
+</div>
+
+<a name="N1005B"></a><a name="Code+Examples"></a>
+<h2 class="boxed">Code Examples</h2>
+<div class="section">
+<p>
+When you have a long code example, it is a good idea to display the code
+over several lines. There are several reasons for this:
+</p>
+<ol>
+
+<li>The example is easier to read if it is broken up into logical sections</li>
+
+<li>In PDF output, a long code example might extend beyond the page borders and
+get truncated.</li>
+
+</ol>
+<p>
+You should always use <strong>4 spaces</strong> to indent the lines that are below the 
+first line in the code example. <strong>Do not use tabs</strong> to indent. Tabs produce
+inconsistent output.  
+</p>
+<p>
+Here an example of a simple SQL statement:
+</p>
+<pre class="code">
+SELECT * FROM flights 
+    WHERE HOUR(departure_time) = 6 and MINUTE(departure_time) &lt; 31  
+</pre>
+<p>
+Here an example of a more complex SQL statement:
+</p>
+<pre class="code">
+CREATE TABLE x_table 
+    ( id INT, 
+    xcol XML CHECK (XMLEXISTS ('//student[@age &lt; 25]' PASSING BY REF xcol))
+    ) 
+</pre>
+</div>
+
+<a name="N10085"></a><a name="Semi-colon+use+at+the+end+of+statements+and+commands"></a>
+<h2 class="boxed">Semi-colon use at the end of statements and commands</h2>
+<div class="section">
+<p>
+The semi-colon should be included only when you want to document an example 
+statement that will be issued in ij.  For example:
+</p>
+<pre class="code">
+   ij&gt; connect 'mydb'; 
+   ij&gt; select * from t1; 
+</pre>
+<p>If the example is just an example of how to use the syntax for a Derby 
+SQL statement, the semi-colon should not be used. For example:
+<br>
+
+</p>
+<pre class="code">
+   select * from t1 
+</pre>
+<p>This issue was discussed on derby-dev in August 2006:
+<br>
+
+<a class="external" href="http://www.nabble.com/Documentation-Style-Issue---semi-colon-at-the-end-of-SQL-statement-examples-tf2141831.html#a5913071">Documentation Style Issue - semi-colon at the end of SQL statement examples</a>.
+</p>
+</div>
+
+<a name="N100A5"></a><a name="SQL+terminology%3A+When+do+I+use+the+terms+statement%2C+clause%2C+parameter%2C+%0Aor+expression%3F"></a>
+<h2 class="boxed">SQL terminology: When do I use the terms statement, clause, parameter, 
+or expression?</h2>
+<div class="section">
+<p>
+
+<strong>Statement</strong> should be used only for actual SQL statements, 
+such as these statements:
+</p>
+<pre class="code">
+   ALTER
+   CREATE
+   DELETE
+   GRANT
+   INSERT
+   SELECT
+   UPDATE
+</pre>
+<p>
+
+<strong>Clause</strong> should be used for parts of SQL statements, 
+such as these clauses:
+</p>
+<pre class="code">
+   FROM
+   GROUP BY
+   HAVING
+   ORDER BY
+   WHERE
+</pre>
+<p>
+
+<strong>Parameter</strong> should be used to describe SQL values that are 
+being passed into and out of procedures. 
+</p>
+<p>
+
+<strong>Expression</strong> should be used for parts of SQL statements that 
+return a value. For more information, see "SQL expressions" in the 
+<a href="http://db.apache.org/derby/docs/dev/ref/">Derby Reference Manual</a>
+
+</p>
+</div>
+
+<p>
+
+<br>
+Please post feedback to the 
+<a href="../derby_mail.html">derby-dev</a> mail list.
+</p>
+
+
+<p>
+<em>Last Updated: March 19, 2007</em>
+</p>
+
+</div>
+<!--+
+    |end content
+    +-->
+<div class="clearboth">&nbsp;</div>
+</div>
+<div id="footer">
+<!--+
+    |start bottomstrip
+    +-->
+<div class="lastmodified">
+<script type="text/javascript"><!--
+document.write("Last Published: " + document.lastModified);
+//  --></script>
+</div>
+<div class="copyright">
+        Copyright &copy;
+         2004-2012 Apache Software Foundation</div>
+<div id="feedback">
+    Send feedback about the website to:
+  <a id="feedbackto" href="mailto:derby-user@db.apache.org?subject=Feedback%C2%A0manuals/docsfaq.html">derby-user@db.apache.org</a>
+</div>
+<!--+
+    |end bottomstrip
+    +-->
+</div>
+</body>
+</html>



Mime
View raw message