You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by db...@apache.org on 2016/03/15 21:38:45 UTC

[18/35] incubator-trafodion-site git commit: Two new guides plus other documentation (PR 379)

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/2.0.0/rest_reference/apidocs/overview-summary.html
----------------------------------------------------------------------
diff --git a/docs/2.0.0/rest_reference/apidocs/overview-summary.html b/docs/2.0.0/rest_reference/apidocs/overview-summary.html
index d2fad89..951db6a 100644
--- a/docs/2.0.0/rest_reference/apidocs/overview-summary.html
+++ b/docs/2.0.0/rest_reference/apidocs/overview-summary.html
@@ -2,10 +2,10 @@
 <!-- NewPage -->
 <html lang="en">
 <head>
-<!-- Generated by javadoc (version 1.7.0_91) on Thu Mar 03 20:15:56 UTC 2016 -->
+<!-- Generated by javadoc (version 1.7.0_91) on Tue Mar 15 20:23:42 UTC 2016 -->
 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
 <title>Overview (Trafodion REST 2.0.0 API)</title>
-<meta name="date" content="2016-03-03">
+<meta name="date" content="2016-03-15">
 <link rel="stylesheet" type="text/css" href="stylesheet.css" title="Style">
 </head>
 <body>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/2.0.0/rest_reference/apidocs/overview-tree.html
----------------------------------------------------------------------
diff --git a/docs/2.0.0/rest_reference/apidocs/overview-tree.html b/docs/2.0.0/rest_reference/apidocs/overview-tree.html
index 1f163e7..3997ddf 100644
--- a/docs/2.0.0/rest_reference/apidocs/overview-tree.html
+++ b/docs/2.0.0/rest_reference/apidocs/overview-tree.html
@@ -2,10 +2,10 @@
 <!-- NewPage -->
 <html lang="en">
 <head>
-<!-- Generated by javadoc (version 1.7.0_91) on Thu Mar 03 20:15:56 UTC 2016 -->
+<!-- Generated by javadoc (version 1.7.0_91) on Tue Mar 15 20:23:42 UTC 2016 -->
 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
 <title>Class Hierarchy (Trafodion REST 2.0.0 API)</title>
-<meta name="date" content="2016-03-03">
+<meta name="date" content="2016-03-15">
 <link rel="stylesheet" type="text/css" href="stylesheet.css" title="Style">
 </head>
 <body>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/2.0.0/rest_reference/apidocs/serialized-form.html
----------------------------------------------------------------------
diff --git a/docs/2.0.0/rest_reference/apidocs/serialized-form.html b/docs/2.0.0/rest_reference/apidocs/serialized-form.html
index 534679e..bce39bc 100644
--- a/docs/2.0.0/rest_reference/apidocs/serialized-form.html
+++ b/docs/2.0.0/rest_reference/apidocs/serialized-form.html
@@ -2,10 +2,10 @@
 <!-- NewPage -->
 <html lang="en">
 <head>
-<!-- Generated by javadoc (version 1.7.0_91) on Thu Mar 03 20:15:56 UTC 2016 -->
+<!-- Generated by javadoc (version 1.7.0_91) on Tue Mar 15 20:23:42 UTC 2016 -->
 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
 <title>Serialized Form (Trafodion REST 2.0.0 API)</title>
-<meta name="date" content="2016-03-03">
+<meta name="date" content="2016-03-15">
 <link rel="stylesheet" type="text/css" href="stylesheet.css" title="Style">
 </head>
 <body>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/2.0.0/rest_reference/failsafe-report.html
----------------------------------------------------------------------
diff --git a/docs/2.0.0/rest_reference/failsafe-report.html b/docs/2.0.0/rest_reference/failsafe-report.html
index c4eebf2..1b8acb3 100644
--- a/docs/2.0.0/rest_reference/failsafe-report.html
+++ b/docs/2.0.0/rest_reference/failsafe-report.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2016-03-03 -->
+<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2016-03-15 -->
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20160303" />
+    <meta name="Date-Revision-yyyymmdd" content="20160315" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
                     
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2016-03-03</span>
+        <span id="publishDate">Last Published: 2016-03-15</span>
                   &nbsp;| <span id="projectVersion">Version: 2.0.0</span>
                       </div>
             <div class="xright">                    <a href="./" title="Trafodion REST">Trafodion REST</a>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/2.0.0/rest_reference/index.html
----------------------------------------------------------------------
diff --git a/docs/2.0.0/rest_reference/index.html b/docs/2.0.0/rest_reference/index.html
index 2e74b2c..7d055f1 100644
--- a/docs/2.0.0/rest_reference/index.html
+++ b/docs/2.0.0/rest_reference/index.html
@@ -95,7 +95,7 @@ under the License.</p>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">2.0.0</p></td>
-<td class="tableblock halign-left valign-top"><p class="tableblock">2016-03-03T20:14</p></td>
+<td class="tableblock halign-left valign-top"><p class="tableblock">2016-03-15T20:21</p></td>
 </tr>
 </tbody>
 </table>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/2.0.0/rest_reference/mail-lists.html
----------------------------------------------------------------------
diff --git a/docs/2.0.0/rest_reference/mail-lists.html b/docs/2.0.0/rest_reference/mail-lists.html
index 89f73a0..652b70f 100644
--- a/docs/2.0.0/rest_reference/mail-lists.html
+++ b/docs/2.0.0/rest_reference/mail-lists.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2016-03-03 -->
+<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2016-03-15 -->
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20160303" />
+    <meta name="Date-Revision-yyyymmdd" content="20160315" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
                     
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2016-03-03</span>
+        <span id="publishDate">Last Published: 2016-03-15</span>
                   &nbsp;| <span id="projectVersion">Version: 2.0.0</span>
                       </div>
             <div class="xright">                    <a href="./" title="Trafodion REST">Trafodion REST</a>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/2.0.0/rest_reference/project-info.html
----------------------------------------------------------------------
diff --git a/docs/2.0.0/rest_reference/project-info.html b/docs/2.0.0/rest_reference/project-info.html
index c5ffa7f..1162043 100644
--- a/docs/2.0.0/rest_reference/project-info.html
+++ b/docs/2.0.0/rest_reference/project-info.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2016-03-03 -->
+<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2016-03-15 -->
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20160303" />
+    <meta name="Date-Revision-yyyymmdd" content="20160315" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
                     
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2016-03-03</span>
+        <span id="publishDate">Last Published: 2016-03-15</span>
                   &nbsp;| <span id="projectVersion">Version: 2.0.0</span>
                       </div>
             <div class="xright">                    <a href="./" title="Trafodion REST">Trafodion REST</a>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/2.0.0/rest_reference/project-reports.html
----------------------------------------------------------------------
diff --git a/docs/2.0.0/rest_reference/project-reports.html b/docs/2.0.0/rest_reference/project-reports.html
index be20889..d202c88 100644
--- a/docs/2.0.0/rest_reference/project-reports.html
+++ b/docs/2.0.0/rest_reference/project-reports.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2016-03-03 -->
+<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2016-03-15 -->
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20160303" />
+    <meta name="Date-Revision-yyyymmdd" content="20160315" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
                     
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2016-03-03</span>
+        <span id="publishDate">Last Published: 2016-03-15</span>
                   &nbsp;| <span id="projectVersion">Version: 2.0.0</span>
                       </div>
             <div class="xright">                    <a href="./" title="Trafodion REST">Trafodion REST</a>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/2.0.0/rest_reference/team-list.html
----------------------------------------------------------------------
diff --git a/docs/2.0.0/rest_reference/team-list.html b/docs/2.0.0/rest_reference/team-list.html
index 109c982..5d2fa8c 100644
--- a/docs/2.0.0/rest_reference/team-list.html
+++ b/docs/2.0.0/rest_reference/team-list.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2016-03-03 -->
+<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2016-03-15 -->
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20160303" />
+    <meta name="Date-Revision-yyyymmdd" content="20160315" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
                     
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2016-03-03</span>
+        <span id="publishDate">Last Published: 2016-03-15</span>
                   &nbsp;| <span id="projectVersion">Version: 2.0.0</span>
                       </div>
             <div class="xright">                    <a href="./" title="Trafodion REST">Trafodion REST</a>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/2.0.0/sql_reference/Trafodion_SQL_Reference_Manual.pdf
----------------------------------------------------------------------
diff --git a/docs/2.0.0/sql_reference/Trafodion_SQL_Reference_Manual.pdf b/docs/2.0.0/sql_reference/Trafodion_SQL_Reference_Manual.pdf
index 94e2783..839e3fb 100644
Binary files a/docs/2.0.0/sql_reference/Trafodion_SQL_Reference_Manual.pdf and b/docs/2.0.0/sql_reference/Trafodion_SQL_Reference_Manual.pdf differ

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/2.0.0/sql_reference/dependencies.html
----------------------------------------------------------------------
diff --git a/docs/2.0.0/sql_reference/dependencies.html b/docs/2.0.0/sql_reference/dependencies.html
index 310aaee..fd2440a 100644
--- a/docs/2.0.0/sql_reference/dependencies.html
+++ b/docs/2.0.0/sql_reference/dependencies.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<!-- Generated by Apache Maven Doxia at Mar 3, 2016 -->
+<!-- Generated by Apache Maven Doxia at Mar 15, 2016 -->
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20160303" />
+    <meta name="Date-Revision-yyyymmdd" content="20160315" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
         
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2016-03-03</span>
+        <span id="publishDate">Last Published: 2016-03-15</span>
                   &nbsp;| <span id="projectVersion">Version: 2.0.0</span>
                       </div>
             <div class="xright">                    <a href="./" title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</a>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/2.0.0/sql_reference/index.html
----------------------------------------------------------------------
diff --git a/docs/2.0.0/sql_reference/index.html b/docs/2.0.0/sql_reference/index.html
index 7504cfc..aea4bfb 100644
--- a/docs/2.0.0/sql_reference/index.html
+++ b/docs/2.0.0/sql_reference/index.html
@@ -1941,42 +1941,7 @@ table.CodeRay td.code>pre{padding:0}
 <li><a href="#reserved_sql_identifiers_z">9.25. Reserved SQL Identifiers: Z</a></li>
 </ul>
 </li>
-<li><a href="#cqd_attributes">10. Control Query Default (CQD) Attributes</a>
-<ul class="sectlevel2">
-<li><a href="#hive_environment_cqds">10.1. Hive Environment CQDs</a>
-<ul class="sectlevel3">
-<li><a href="#hive_max_string_length">10.1.1. HIVE_MAX_STRING_LENGTH</a></li>
-</ul>
-</li>
-<li><a href="#managing_histograms">10.2. Managing Histograms</a>
-<ul class="sectlevel3">
-<li><a href="#cache_histograms_refresh_interval">10.2.1. CACHE_HISTOGRAMS_REFRESH_INTERVAL</a></li>
-<li><a href="#hist_no_stats_refresh_interval">10.2.2. HIST_NO_STATS_REFRESH_INTERVAL</a></li>
-<li><a href="#hist_prefetch">10.2.3. HIST_PREFETCH</a></li>
-<li><a href="#hist_rowcount_requiring_stats">10.2.4. HIST_ROWCOUNT_REQUIRING_STATS</a></li>
-</ul>
-</li>
-<li><a href="#optimizer">10.3. Optimizer</a>
-<ul class="sectlevel3">
-<li><a href="#join_order_by_user">10.3.1. JOIN_ORDER_BY_USER</a></li>
-<li><a href="#mdam_scan_method">10.3.2. MDAM_SCAN_METHOD</a></li>
-<li><a href="#subquery_unnesting">10.3.3. SUBQUERY_UNNESTING</a></li>
-</ul>
-</li>
-<li><a href="#managing_schemas">10.4. Managing Schemas</a>
-<ul class="sectlevel3">
-<li><a href="#schema">10.4.1. SCHEMA</a></li>
-</ul>
-</li>
-<li><a href="#transaction_control_and_locking">10.5. Transaction Control and Locking</a>
-<ul class="sectlevel3">
-<li><a href="#block_to_prevent_halloween">10.5.1. BLOCK_TO_PREVENT_HALLOWEEN</a></li>
-<li><a href="#upd_ordered">10.5.2. UPD_ORDERED</a></li>
-</ul>
-</li>
-</ul>
-</li>
-<li><a href="#limits">11. Limits</a></li>
+<li><a href="#limits">10. Limits</a></li>
 </ul>
 </div>
 </div>
@@ -2171,11 +2136,7 @@ Management System (RMS) and describes the RMS counters that are returned.</p></t
 <td class="tableblock halign-left valign-top"><p class="tableblock">Lists the words that are reserved in Trafodion SQL.</p></td>
 </tr>
 <tr>
-<td class="tableblock halign-left valign-top"><p class="tableblock"><a href="#Control_Query_Default">Appendix B: Control Query Default (CQD) Attributes</a></p></td>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Describes the Control Query Default (CQD) attributes that are supported in a Trafodion SQL environment.</p></td>
-</tr>
-<tr>
-<td class="tableblock halign-left valign-top"><p class="tableblock"><a href="#limits">Appendix C: Limits</a></p></td>
+<td class="tableblock halign-left valign-top"><p class="tableblock"><a href="#limits">Appendix B: Limits</a></p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Describes limits in Trafodion SQL.</p></td>
 </tr>
 </tbody>
@@ -2526,7 +2487,8 @@ identifiers, literals, and predicates. For more information, see:</p>
 </ul>
 </div>
 <div class="paragraph">
-<p>For a list of Control Query Default (CQD) settings for the HBase environment, see <a href="#HBase_Environment_CQDs">HBase Environment CQDs</a>.</p>
+<p>For a list of Control Query Default (CQD) settings for the HBase environment, see the
+<a href="http://trafodion.incubator.apache.org/docs/cqd_reference/index.hmtl">Trafodion Control Query Default (CQD) Reference Guide</a>.</p>
 </div>
 <div class="sect3">
 <h4 id="ways_to_access_hbase_tables">2.2.1. Ways to Access HBase Tables</h4>
@@ -2780,7 +2742,8 @@ so users lose the flexibility of dynamic columns that comes with HBase.</p>
 </ul>
 </div>
 <div class="paragraph">
-<p>For a list of Control Query Default (CQD) settings for the Hive environment, see <a href="#Hive_Environment_CQDs">Hive Environment CQDs</a>.</p>
+<p>For a list of Control Query Default (CQD) settings for the Hive environment, see the
+<a href="http://trafodion.incubator.apache.org/docs/cqd_reference/index.hmtl">Trafodion Control Query Default (CQD) Reference Guide</a>.</p>
 </div>
 <div class="sect3">
 <h4 id="ansi_names_for_hive_tables">2.3.1. ANSI Names for Hive Tables</h4>
@@ -2799,7 +2762,7 @@ This example should work if a Hive table named <code>T</code> has already been d
 <div class="content">
 <pre class="CodeRay highlight"><code data-lang="text">set schema hive.hive;
 
-cqd hive_max_string_length '20'; -- creates a more readable display
+CQD HIVE_MAX_STRING_LENGTH '20'; -- creates a more readable display
 select * from t; -- implicit table name
 
 set schema trafodion.seabase;
@@ -2863,7 +2826,8 @@ select * from hive.hive.t; -- explicit table name</code></pre>
 <div class="olist arabic">
 <ol class="arabic">
 <li>
-<p>The value <code><em>n</em></code> is determined by <code>CQD HIVE_MAX_STRING_LENGTH</code>. See <a href="#hive_environment_cqds">Hive Environment CQDs</a>.</p>
+<p>The value <code><em>n</em></code> is determined by <code>CQD HIVE_MAX_STRING_LENGTH</code>. See the
+<a href="http://trafodion.incubator.apache.org/docs/cqd_reference/index.hmtl">Trafodion Control Query Default (CQD) Reference Guide</a>.</p>
 </li>
 <li>
 <p>Hive supports timestamps with nanosecond resolution (precision of 9). Trafodion SQL supports only microsecond resolution (precision 6).</p>
@@ -5115,7 +5079,7 @@ control-default-option is:
 <p><code><em>attribute</em></code></p>
 <div class="paragraph">
 <p>is a character string that represents an attribute name. For descriptions of these attributes,
-see <a href="#Control_Query_Default_Attributes">Control Query Default (CQD) Attributes</a>.</p>
+see the <a href="http://trafodion.incubator.apache.org/docs/cqd_reference/index.html">Trafodion Control Query Default (CQD) Reference Guide</a>.</p>
 </div>
 </li>
 <li>
@@ -14966,8 +14930,8 @@ see the <a href="#control_query default_statement">Control Query Default Stateme
 <p><code><em>attribute-name</em>[, MATCH {FULL | PARTIAL }]</code></p>
 <div class="paragraph">
 <p>displays only the defaults that match, either fully or partially, the <em>attribute</em> used in CONTROL QUERY DEFAULT
-statements. The match is not case-sensitive. For descriptions of these attributes, see
-<a href="#control_query_default_attributes">CONTROL QUERY (CQD) DEFAULT Attributes</a>.</p>
+statements. The match is not case-sensitive. For descriptions of these attributes, see the
+<a href="http://trafodion.incubator.apache.org/docs/cqd_reference/index.html">Trafodion Control Query Default (CQD) Reference Guide</a>.</p>
 </div>
 <div class="paragraph">
 <p>MATCH FULL specifies that <em>attribute-name</em> must be the same as the attribute name used in a control query default
@@ -41938,638 +41902,12 @@ enclose them in double quotes.</p>
 </div>
 <div class="sect2">
 <h3 id="reserved_sql_identifiers_z">9.25. Reserved SQL Identifiers: Z</h3>
-<div style="page-break-after: always;"></div>
-<div style="page-break-after: always;"></div>
-</div>
-</div>
-</div>
-<div class="sect1">
-<h2 id="cqd_attributes">10. Control Query Default (CQD) Attributes</h2>
-<div class="sectionbody">
-<div class="paragraph">
-<p>This section describes CQDs that are used to override system-level
-default settings.</p>
-</div>
-<div class="sect2">
-<h3 id="hive_environment_cqds">10.1. Hive Environment CQDs</h3>
-<div class="sect3">
-<h4 id="hive_max_string_length">10.1.1. HIVE_MAX_STRING_LENGTH</h4>
-<table class="tableblock frame-all grid-all spread">
-<colgroup>
-<col style="width: 25%;">
-<col style="width: 75%;">
-</colgroup>
-<tbody>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Category</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Hive</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Description</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Maximum supported string length for the <em>string</em> data type in Hive. All
-string columns in Hive tables get converted to VARCHAR(<em>n</em> BYTES)
-CHARACTER SET UTF8, with <em>n</em> being the value of this CQD.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Values</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">The default value is 32000.</p></td>
-</tr>
-</tbody>
-</table>
-<div style="page-break-after: always;"></div>
-</div>
-</div>
-<div class="sect2">
-<h3 id="managing_histograms">10.2. Managing Histograms</h3>
-<div class="sect3">
-<h4 id="cache_histograms_refresh_interval">10.2.1. CACHE_HISTOGRAMS_REFRESH_INTERVAL</h4>
-<table class="tableblock frame-all grid-all spread">
-<colgroup>
-<col style="width: 25%;">
-<col style="width: 75%;">
-</colgroup>
-<tbody>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Category</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Histograms</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Description</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Defines the time interval after which timestamps for cached histograms
-are checked to be refreshed.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Values</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Unsigned integer. Unit is seconds.<br>
-<br>
-The default value is '3600' (1 hour).</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Usage</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Histogram statistics are cached so that the compiler can avoid access to
-the metadata tables, thereby reducing compile times. The time stamp of
-the tables are checked against those of the cached histograms at an
-interval specified by this CQD, in order to see if the cached histograms
-need to be refreshed.<br>
-<br>
-You can increase the interval to reduce the impact on compile times as
-long as you do not need to obtain fresh statistics more frequently in
-order to improve query performance. It may
-<br>
-be that the default interval is too long and you would rather refresh
-the statistics more frequently than the default one hour, in order to
-improve query performance at the cost of increased compile times.
-<br>
-This setting depends on how frequently you are updating statistics on
-tables. There is no point in refreshing statistics frequently when
-statistics are not being updated during that time. On the other hand if
-you are updating statistics, or generating them for the first time on
-freshly loaded tables frequently enough, and you want these to be picked
-up immediately by the compiler because you have seen this to have a
-dramatic impact on plan quality, then you can make the refresh more
-frequent.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Production Usage</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Not applicable.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Impact</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Longer histogram refresh intervals can improve compile times. However,
-the longer the refresh interval the more obsolete the histograms. That
-could result in poor performance for queries that could leverage
-recently updated statistics.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Level</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">System or Service Not applicable</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Addressing the Real Problem</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Not applicable.</p></td>
-</tr>
-</tbody>
-</table>
-<div style="page-break-after: always;"></div>
-</div>
-<div class="sect3">
-<h4 id="hist_no_stats_refresh_interval">10.2.2. HIST_NO_STATS_REFRESH_INTERVAL</h4>
-<table class="tableblock frame-all grid-all spread">
-<colgroup>
-<col style="width: 25%;">
-<col style="width: 75%;">
-</colgroup>
-<tbody>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Category</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Histograms</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Description</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Defines the time interval after which the fake histograms in the cache should be refreshed unconditionally.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Values</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Integer. Unit is seconds.<br>
-<br>
-The default value is '3600' (1 hour).</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Usage</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Histogram statistics are "fake" when update statistics is not being run,
-but instead the customer is updating the histogram tables directly with
-statistics to guide the optimizer. This may be done if the data in the
-table is very volatile (such as for temporary tables), update statistics
-is not possible because of constant flush and fill of the table
-occurring, and statistics are manually set to provide some guidance to
-the optimizer to generate a good plan.
-<br>
-If these fake statistics are updated constantly to reflect the data
-churn, this default can be set to 0. This would ensure that the
-histograms with fake statistics are not cached, and are always
-refreshed. If these fake statistics are set and not touched again, then
-this interval could be set very high.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Production Usage</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Not applicable.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Impact</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Setting a high interval improves compilation time. However, if statistics are being updated, the compiler may be working with obsolete
-histogram statistics, potentially resulting in poorer plans.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Level</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Service.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Conflicts/Synergies</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Not applicable.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Addressing the Real Problem</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Not applicable.</p></td>
-</tr>
-</tbody>
-</table>
-</div>
-<div class="sect3">
-<h4 id="hist_prefetch">10.2.3. HIST_PREFETCH</h4>
-<table class="tableblock frame-all grid-all spread">
-<colgroup>
-<col style="width: 25%;">
-<col style="width: 75%;">
-</colgroup>
-<tbody>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Category</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Histograms</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Description</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Influences the compiler to pre-fetch the histograms and save them in cache.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Values</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">'ON'    Pre-fetches the histograms.<br>
-'OFF'   Does not pre-fetch the histograms.<br>
-<br>
- The default value is 'ON'.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Usage</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">You may want to turn this off if you don&#8217;t want to pre-fetch a large number of histograms, many of which may not be used.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Production Usage</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Not applicable.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Impact</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Though it makes compilation time faster, it may result in the histogram cache to be filled with histograms that may never be used.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Level</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">System or Service.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Conflicts/Synergies</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Use this CQD with CACHE_HISTOGRAMS. If CACHE_HISTOGRAMS is OFF, then this CQD has no effect.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Addressing the Real Problem</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Not applicable.</p></td>
-</tr>
-</tbody>
-</table>
-</div>
-<div class="sect3">
-<h4 id="hist_rowcount_requiring_stats">10.2.4. HIST_ROWCOUNT_REQUIRING_STATS</h4>
-<table class="tableblock frame-all grid-all spread">
-<colgroup>
-<col style="width: 25%;">
-<col style="width: 75%;">
-</colgroup>
-<tbody>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Category</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Histograms</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Description</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Specifies the minimum row count for which the optimizer needs histograms, in order to compute better cardinality estimates. The
-optimizer does not issue any missing statistics warnings for tables whose size is smaller than the value of this CQD.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Values</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Integer.<br>
-<br>
-The default value is '50000'.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Usage</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Use this CQD to reduce the number of statistics warnings.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Production Usage</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Not applicable.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Impact</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Missing statistics warnings are not displayed for smaller tables, which in most cases don&#8217;t impact plan quality much.
-However, there may be some exceptions where missing statistics on small tables could result in less than optimal plans.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Level</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">System</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Conflicts/Synergies</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Use this CQD with HIST_MISSING_STATS_WARNING_LEVEL. If the warning level CQD is 0, then this CQD does not have any effect. Also, for tables
-having fewer rows than set in this CQD, no warnings are displayed irrespective of the warning level.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Addressing the Real Problem</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Not applicable.</p></td>
-</tr>
-</tbody>
-</table>
-<div style="page-break-after: always;"></div>
-</div>
-</div>
-<div class="sect2">
-<h3 id="optimizer">10.3. Optimizer</h3>
-<div class="sect3">
-<h4 id="join_order_by_user">10.3.1. JOIN_ORDER_BY_USER</h4>
-<table class="tableblock frame-all grid-all spread">
-<colgroup>
-<col style="width: 25%;">
-<col style="width: 75%;">
-</colgroup>
-<tbody>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Category</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Influencing Query Plans</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Description</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Enables or disables the join order in which the optimizer joins the tables to be the sequence of the tables in the FROM clause of the query.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Values</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">'ON'   Join order is forced.<br>
-<br>
-'OFF'   Join order is decided by the optimizer.<br>
-<br>
-The default value is 'OFF'.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Usage</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">When set to ON, the optimizer considers only execution plans that have the join order matching the sequence of the tables in the FROM clause.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Production Usage</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">This setting is to be used only for forcing a desired join order that was not generated by default by the optimizer. It can be used as a
-workaround for query plans with inefficient join order.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Impact</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Because you are in effect forcing the optimizer to use a plan that joins the table in the order specified in the FROM clause,
-the plan generated may not be the optimal one.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Level</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Query</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Conflicts/Synergies</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Not applicable.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Addressing the Real Problem</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Not applicable.</p></td>
-</tr>
-</tbody>
-</table>
-</div>
-<div class="sect3">
-<h4 id="mdam_scan_method">10.3.2. MDAM_SCAN_METHOD</h4>
-<table class="tableblock frame-all grid-all spread">
-<colgroup>
-<col style="width: 25%;">
-<col style="width: 75%;">
-</colgroup>
-<tbody>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Category</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Influencing Query Plans</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Description</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Enables or disables the Multi-Dimensional Access Method.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Values</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">'ON'    MDAM is considered.<br>
-'OFF'   MDAM is disabled.<br>
-<br>
-The default value is 'ON'.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Usage</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">In certain situations, the optimizer might choose MDAM inappropriately, causing poor performance.
-In such situations you may want to turn MDAM OFF for the query it is effecting.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Production Usage</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Not applicable.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Impact</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Table scans with predicates on non-leading clustering key column(s) could benefit from MDAM access method if
-the leading column(s) has a small number of distinct values. Turning MDAM off results in a longer scan time for such queries.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Level</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Set this CQD at the query level when MDAM is not working efficiently for a specific query.
-However, there may be cases (usually a defect) where a larger set of queries is being negatively impacted by MDAM.
-In those cases you may want to set it at the service or system level.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Conflicts/Synergies</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Not applicable.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Addressing the Real Problem</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Not applicable.</p></td>
-</tr>
-</tbody>
-</table>
-</div>
-<div class="sect3">
-<h4 id="subquery_unnesting">10.3.3. SUBQUERY_UNNESTING</h4>
-<table class="tableblock frame-all grid-all spread">
-<colgroup>
-<col style="width: 25%;">
-<col style="width: 75%;">
-</colgroup>
-<tbody>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Category</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Influencing Query Plans</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Description</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Controls the optimizer&#8217;s ability to transform nested sub-queries into regular join trees.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Values</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">'ON'    Subquery un-nesting is considered.<br>
-'OFF'   Subquery un-nesting is disabled.<br>
-<br>
-The default value is 'ON'.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Usage</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Use this control to disable subquery un-nesting in the rare situation when un-nesting results in an inefficient query execution plan.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Production usage</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Not applicable.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Impact</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">In general, subquery un-nesting results in more efficient execution plans for queries with nested sub-queries.
-Use only as a workaround for observed problems due to un-nesting.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Level</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Query</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Conflicts/Synergies</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Not applicable.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Addressing the Real Problem</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Not applicable.</p></td>
-</tr>
-</tbody>
-</table>
-<div style="page-break-after: always;"></div>
-</div>
-</div>
-<div class="sect2">
-<h3 id="managing_schemas">10.4. Managing Schemas</h3>
-<div class="sect3">
-<h4 id="schema">10.4.1. SCHEMA</h4>
-<table class="tableblock frame-all grid-all spread">
-<colgroup>
-<col style="width: 25%;">
-<col style="width: 75%;">
-</colgroup>
-<tbody>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Category</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Schema controls</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Description</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Sets the default schema for the session.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Values</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">SQL identifier.<br>
-<br>
-The default is SEABASE.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Usage</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">A SET SCHEMA statement, or a CONTROL QUERY DEFAULT SCHEMA statement, can be used to override the default schema name.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Production Usage</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">It is a convenience so you do not have to type in two-part names.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Impact</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Not applicable.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Level</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Any.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Conflicts/Synergies</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Alternately you can use the SET SCHEMA statement.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Addressing the Real Problem</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Not applicable.</p></td>
-</tr>
-</tbody>
-</table>
-<div style="page-break-after: always;"></div>
-</div>
-</div>
-<div class="sect2">
-<h3 id="transaction_control_and_locking">10.5. Transaction Control and Locking</h3>
-<div class="sect3">
-<h4 id="block_to_prevent_halloween">10.5.1. BLOCK_TO_PREVENT_HALLOWEEN</h4>
-<table class="tableblock frame-all grid-all spread">
-<colgroup>
-<col style="width: 25%;">
-<col style="width: 75%;">
-</colgroup>
-<tbody>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Category</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Runtime controls</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Description</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">A self-referencing insert is one which inserts into a target table and
-also scans from the same target table as part of the query that produces
-rows to be inserted. Inconsistent results are produced by the insert
-statement if the statement scans rows which have been inserted by the
-same statement. This is sometimes called the "Halloween problem."
-Trafodion prevents the Halloween problem using one of two methods: 1)
-the blocking method uses a SORT operation to ensure all rows have been
-scanned before any are inserted, or 2) the disk process (ESAM) locks
-method tracks the rows which have already been inserted and the SCAN
-operator skips these rows.<br>
-<br>
-The compiler chooses the blocking method in cases in which static
-analysis of the plan indicates that the disk process locks method cannot
-be used. However, the compiler does not evaluate one condition that
-would prevent the use of the disk process locks method: the AUTOCOMMIT
-setting in which the statement is executed. Instead the compiler assumes
-that the statement is executed with the default setting for AUTOCOMMIT,
-'ON'. If AUTOCOMMIT is set to 'OFF' and self-referencing insert
-statement which uses the disk process locks method is executed, then a
-runtime error (SQLCODE 8107) is raised.<br>
-<br>
-This CQD is used to force the compiler to use the blocking method to
-prevent error 8107.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Values</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">'OFF'   The compiler is free to choose which method to use to prevent the Halloween problem.<br>
-'ON'    The compiler is forced to use the blocking method.<br>
-<br>
-The default value is 'ON'.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Usage</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Change this default to 'ON' if error 8107 is raised for a self-referencing insert statement which is
-executed in a session with AUTOCOMMIT set to 'OFF'.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Production Usage</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Not applicable.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Impact</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Using the 'ON' value in conditions that require it allows successful completion of the insert statement.
-Using the 'ON' value when not required can decrease performance of some self-referencing insert statements.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Level</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">If self-referencing insert statements which execute with AUTOCOMMIT 'OFF' can be restricted to a service level,
-then this default should be set to 'ON' only for that service level. Otherwise the setting should be made for the system.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Conflicts/Synergies</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Not applicable.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Addressing the Real Problem</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Not applicable.</p></td>
-</tr>
-</tbody>
-</table>
-<div style="page-break-after: always;"></div>
-</div>
-<div class="sect3">
-<h4 id="upd_ordered">10.5.2. UPD_ORDERED</h4>
-<table class="tableblock frame-all grid-all spread">
-<colgroup>
-<col style="width: 25%;">
-<col style="width: 75%;">
-</colgroup>
-<tbody>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Category</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Influencing Query Plans</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Description</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Controls whether rows should be inserted, updated, or deleted in clustering key order.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Values</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">'ON'    The optimizer generates and considers plans where the rows are inserted, updated, or deleted in clustering key order.<br>
-'OFF'   The optimizer does not generate plans where the rows must be inserted, updated, or deleted in clustering key order.
-<br>
-The default value is 'ON'.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Usage</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Inserting, updating or deleting rows in the clustering key order is most efficient and highly recommended. Turning this CQD OFF may result in
-saving the data sorting cost but at the expense of having less efficient random I/O Insert/Update/Delete operations.<br>
-<br>
-If you know that the data is already sorted in clustering key order, or is mostly in clustering key order,
-so that it would not result in random I/O, you could set this CQD to OFF.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Production Usage</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Not applicable.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Impact</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">If turned OFF, the system may perform large number of inefficient Random I/Os when performing Insert/Update/Delete operations.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Level</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Query</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Conflicts/Synergies</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Not applicable.</p></td>
-</tr>
-<tr>
-<th class="tableblock halign-left valign-top"><p class="tableblock">Addressing the Real Problem</p></th>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Not applicable.</p></td>
-</tr>
-</tbody>
-</table>
-</div>
+
 </div>
 </div>
 </div>
 <div class="sect1">
-<h2 id="limits">11. Limits</h2>
+<h2 id="limits">10. Limits</h2>
 <div class="sectionbody">
 <div class="paragraph">
 <p>This section lists limits for various parts of Trafodion SQL.</p>
@@ -42601,7 +41939,7 @@ or 256 bytes of UTF8 text, whichever is less.</p></td>
 <div id="footer">
 <div id="footer-text">
 Version 2.0.0<br>
-Last updated 2016-02-24 18:39:33 UTC
+Last updated 2016-03-15 20:19:02 UTC
 </div>
 </div>
 <script>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/2.0.0/sql_reference/integration.html
----------------------------------------------------------------------
diff --git a/docs/2.0.0/sql_reference/integration.html b/docs/2.0.0/sql_reference/integration.html
index 63e7060..d931b6b 100644
--- a/docs/2.0.0/sql_reference/integration.html
+++ b/docs/2.0.0/sql_reference/integration.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<!-- Generated by Apache Maven Doxia at Mar 3, 2016 -->
+<!-- Generated by Apache Maven Doxia at Mar 15, 2016 -->
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20160303" />
+    <meta name="Date-Revision-yyyymmdd" content="20160315" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
         
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2016-03-03</span>
+        <span id="publishDate">Last Published: 2016-03-15</span>
                   &nbsp;| <span id="projectVersion">Version: 2.0.0</span>
                       </div>
             <div class="xright">                    <a href="./" title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</a>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/2.0.0/sql_reference/issue-tracking.html
----------------------------------------------------------------------
diff --git a/docs/2.0.0/sql_reference/issue-tracking.html b/docs/2.0.0/sql_reference/issue-tracking.html
index 5bc0f03..43ce614 100644
--- a/docs/2.0.0/sql_reference/issue-tracking.html
+++ b/docs/2.0.0/sql_reference/issue-tracking.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<!-- Generated by Apache Maven Doxia at Mar 3, 2016 -->
+<!-- Generated by Apache Maven Doxia at Mar 15, 2016 -->
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20160303" />
+    <meta name="Date-Revision-yyyymmdd" content="20160315" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
         
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2016-03-03</span>
+        <span id="publishDate">Last Published: 2016-03-15</span>
                   &nbsp;| <span id="projectVersion">Version: 2.0.0</span>
                       </div>
             <div class="xright">                    <a href="./" title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</a>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/2.0.0/sql_reference/license.html
----------------------------------------------------------------------
diff --git a/docs/2.0.0/sql_reference/license.html b/docs/2.0.0/sql_reference/license.html
index 0201df7..c9de69f 100644
--- a/docs/2.0.0/sql_reference/license.html
+++ b/docs/2.0.0/sql_reference/license.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<!-- Generated by Apache Maven Doxia at Mar 3, 2016 -->
+<!-- Generated by Apache Maven Doxia at Mar 15, 2016 -->
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20160303" />
+    <meta name="Date-Revision-yyyymmdd" content="20160315" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
         
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2016-03-03</span>
+        <span id="publishDate">Last Published: 2016-03-15</span>
                   &nbsp;| <span id="projectVersion">Version: 2.0.0</span>
                       </div>
             <div class="xright">                    <a href="./" title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</a>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/2.0.0/sql_reference/mail-lists.html
----------------------------------------------------------------------
diff --git a/docs/2.0.0/sql_reference/mail-lists.html b/docs/2.0.0/sql_reference/mail-lists.html
index d4b55db..06c13b7 100644
--- a/docs/2.0.0/sql_reference/mail-lists.html
+++ b/docs/2.0.0/sql_reference/mail-lists.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<!-- Generated by Apache Maven Doxia at Mar 3, 2016 -->
+<!-- Generated by Apache Maven Doxia at Mar 15, 2016 -->
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20160303" />
+    <meta name="Date-Revision-yyyymmdd" content="20160315" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
         
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2016-03-03</span>
+        <span id="publishDate">Last Published: 2016-03-15</span>
                   &nbsp;| <span id="projectVersion">Version: 2.0.0</span>
                       </div>
             <div class="xright">                    <a href="./" title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</a>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/2.0.0/sql_reference/project-info.html
----------------------------------------------------------------------
diff --git a/docs/2.0.0/sql_reference/project-info.html b/docs/2.0.0/sql_reference/project-info.html
index 4ede807..d923239 100644
--- a/docs/2.0.0/sql_reference/project-info.html
+++ b/docs/2.0.0/sql_reference/project-info.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<!-- Generated by Apache Maven Doxia at Mar 3, 2016 -->
+<!-- Generated by Apache Maven Doxia at Mar 15, 2016 -->
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20160303" />
+    <meta name="Date-Revision-yyyymmdd" content="20160315" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
         
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2016-03-03</span>
+        <span id="publishDate">Last Published: 2016-03-15</span>
                   &nbsp;| <span id="projectVersion">Version: 2.0.0</span>
                       </div>
             <div class="xright">                    <a href="./" title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</a>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/2.0.0/sql_reference/project-summary.html
----------------------------------------------------------------------
diff --git a/docs/2.0.0/sql_reference/project-summary.html b/docs/2.0.0/sql_reference/project-summary.html
index 703141b..677aa03 100644
--- a/docs/2.0.0/sql_reference/project-summary.html
+++ b/docs/2.0.0/sql_reference/project-summary.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<!-- Generated by Apache Maven Doxia at Mar 3, 2016 -->
+<!-- Generated by Apache Maven Doxia at Mar 15, 2016 -->
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20160303" />
+    <meta name="Date-Revision-yyyymmdd" content="20160315" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
         
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2016-03-03</span>
+        <span id="publishDate">Last Published: 2016-03-15</span>
                   &nbsp;| <span id="projectVersion">Version: 2.0.0</span>
                       </div>
             <div class="xright">                    <a href="./" title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</a>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/2.0.0/sql_reference/source-repository.html
----------------------------------------------------------------------
diff --git a/docs/2.0.0/sql_reference/source-repository.html b/docs/2.0.0/sql_reference/source-repository.html
index 8b6ea88..ef6065d 100644
--- a/docs/2.0.0/sql_reference/source-repository.html
+++ b/docs/2.0.0/sql_reference/source-repository.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<!-- Generated by Apache Maven Doxia at Mar 3, 2016 -->
+<!-- Generated by Apache Maven Doxia at Mar 15, 2016 -->
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20160303" />
+    <meta name="Date-Revision-yyyymmdd" content="20160315" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
         
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2016-03-03</span>
+        <span id="publishDate">Last Published: 2016-03-15</span>
                   &nbsp;| <span id="projectVersion">Version: 2.0.0</span>
                       </div>
             <div class="xright">                    <a href="./" title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</a>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/2.0.0/sql_reference/team-list.html
----------------------------------------------------------------------
diff --git a/docs/2.0.0/sql_reference/team-list.html b/docs/2.0.0/sql_reference/team-list.html
index 154ddee..0e95862 100644
--- a/docs/2.0.0/sql_reference/team-list.html
+++ b/docs/2.0.0/sql_reference/team-list.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<!-- Generated by Apache Maven Doxia at Mar 3, 2016 -->
+<!-- Generated by Apache Maven Doxia at Mar 15, 2016 -->
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20160303" />
+    <meta name="Date-Revision-yyyymmdd" content="20160315" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
         
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2016-03-03</span>
+        <span id="publishDate">Last Published: 2016-03-15</span>
                   &nbsp;| <span id="projectVersion">Version: 2.0.0</span>
                       </div>
             <div class="xright">                    <a href="./" title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</a>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/client_install/Trafodion_Client_Installation_Guide.pdf
----------------------------------------------------------------------
diff --git a/docs/client_install/Trafodion_Client_Installation_Guide.pdf b/docs/client_install/Trafodion_Client_Installation_Guide.pdf
index c55d53c..a1448d8 100644
Binary files a/docs/client_install/Trafodion_Client_Installation_Guide.pdf and b/docs/client_install/Trafodion_Client_Installation_Guide.pdf differ

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/client_install/dependencies.html
----------------------------------------------------------------------
diff --git a/docs/client_install/dependencies.html b/docs/client_install/dependencies.html
index 55c0fd7..28b5f77 100644
--- a/docs/client_install/dependencies.html
+++ b/docs/client_install/dependencies.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<!-- Generated by Apache Maven Doxia at Mar 3, 2016 -->
+<!-- Generated by Apache Maven Doxia at Mar 15, 2016 -->
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20160303" />
+    <meta name="Date-Revision-yyyymmdd" content="20160315" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
         
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2016-03-03</span>
+        <span id="publishDate">Last Published: 2016-03-15</span>
                   &nbsp;| <span id="projectVersion">Version: 2.0.0</span>
                       </div>
             <div class="xright">                    <a href="./" title="Trafodion Client Installation Guide">Trafodion Client Installation Guide</a>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/client_install/index.html
----------------------------------------------------------------------
diff --git a/docs/client_install/index.html b/docs/client_install/index.html
index ead709e..fa5e07b 100644
--- a/docs/client_install/index.html
+++ b/docs/client_install/index.html
@@ -1050,7 +1050,7 @@ script files. For more information, see the <a href="http://trafodion.incubator.
 <div class="sect2">
 <h3 id="_installation_package">3.1. Installation Package</h3>
 <div class="paragraph">
-<p>The installer file for the Trafodion ODBC Driver for Windows is packaged within the Trafodion clients tar file, <code>clients-1.3.<strong><em>n</em></strong>.tar.gz</code>, on the
+<p>The installer file for the Trafodion ODBC Driver for Windows is packaged within the Trafodion clients tar file, <code>Trafodion Clients</code>, on the
 Trafodion downloads site <a href="http://trafodion.incubator.apache.org/download.html" class="bare">http://trafodion.incubator.apache.org/download.html</a>. Use this installer file to install the Trafodion ODBC Driver for Windows:</p>
 </div>
 <table class="tableblock frame-all grid-all spread">
@@ -1189,17 +1189,17 @@ To install the driver on your PC, you must be logged on with a user ID that has
 <p>Create a download folder on the client workstation.</p>
 </li>
 <li>
-<p>Open a Web browser and navigate to the Trafodion downloads site <a href="http://trafodion.incubator.apache.com/download.html" class="bare">http://trafodion.incubator.apache.com/download.html</a></p>
+<p>Open a Web browser and navigate to the Trafodion downloads site <a href="http://trafodion.incubator.apache.org/download.html" class="bare">http://trafodion.incubator.apache.org/download.html</a></p>
 </li>
 <li>
-<p>Click on the <code>clients-1.3.<strong><em>n</em></strong>.tar.gz</code> link to start downloading the Trafodion clients tar file to your workstation.</p>
+<p>Click on the <code>Trafodion Clients</code> link to start downloading the Trafodion clients tar file to your workstation.</p>
 </li>
 <li>
-<p>Place the <code>clients-1.3.<strong><em>n</em></strong>.tar.gz file</code> into the download folder.</p>
+<p>Place the <code>*.tar.gz file</code> into the download folder.</p>
 </li>
 <li>
-<p>Extract the contents of the <code>clients-1.3.<strong><em>n</em></strong>.tar.gz</code> file by using an extract tool like WinZip. The package file contains the
-<code>TFODBC64-1.3.<strong><em>n</em></strong>.msi</code> installer file, which is extracted to the clients sub-directory.</p>
+<p>Extract the contents of the <code><strong>.tar.gz</code> file by using an extract tool like WinZip. The package file contains the
+<code>TFODBC64-1.3.*<em>n</em></strong>.msi</code> installer file, which is extracted to the clients sub-directory.</p>
 </li>
 </ol>
 </div>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/client_install/integration.html
----------------------------------------------------------------------
diff --git a/docs/client_install/integration.html b/docs/client_install/integration.html
index 4cb2497..32bd0ae 100644
--- a/docs/client_install/integration.html
+++ b/docs/client_install/integration.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<!-- Generated by Apache Maven Doxia at Mar 3, 2016 -->
+<!-- Generated by Apache Maven Doxia at Mar 15, 2016 -->
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20160303" />
+    <meta name="Date-Revision-yyyymmdd" content="20160315" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
         
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2016-03-03</span>
+        <span id="publishDate">Last Published: 2016-03-15</span>
                   &nbsp;| <span id="projectVersion">Version: 2.0.0</span>
                       </div>
             <div class="xright">                    <a href="./" title="Trafodion Client Installation Guide">Trafodion Client Installation Guide</a>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/client_install/issue-tracking.html
----------------------------------------------------------------------
diff --git a/docs/client_install/issue-tracking.html b/docs/client_install/issue-tracking.html
index 3353fb0..b972091 100644
--- a/docs/client_install/issue-tracking.html
+++ b/docs/client_install/issue-tracking.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<!-- Generated by Apache Maven Doxia at Mar 3, 2016 -->
+<!-- Generated by Apache Maven Doxia at Mar 15, 2016 -->
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20160303" />
+    <meta name="Date-Revision-yyyymmdd" content="20160315" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
         
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2016-03-03</span>
+        <span id="publishDate">Last Published: 2016-03-15</span>
                   &nbsp;| <span id="projectVersion">Version: 2.0.0</span>
                       </div>
             <div class="xright">                    <a href="./" title="Trafodion Client Installation Guide">Trafodion Client Installation Guide</a>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/client_install/license.html
----------------------------------------------------------------------
diff --git a/docs/client_install/license.html b/docs/client_install/license.html
index b554304..f3ca931 100644
--- a/docs/client_install/license.html
+++ b/docs/client_install/license.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<!-- Generated by Apache Maven Doxia at Mar 3, 2016 -->
+<!-- Generated by Apache Maven Doxia at Mar 15, 2016 -->
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20160303" />
+    <meta name="Date-Revision-yyyymmdd" content="20160315" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
         
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2016-03-03</span>
+        <span id="publishDate">Last Published: 2016-03-15</span>
                   &nbsp;| <span id="projectVersion">Version: 2.0.0</span>
                       </div>
             <div class="xright">                    <a href="./" title="Trafodion Client Installation Guide">Trafodion Client Installation Guide</a>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/client_install/mail-lists.html
----------------------------------------------------------------------
diff --git a/docs/client_install/mail-lists.html b/docs/client_install/mail-lists.html
index f6c3b96..c12b30e 100644
--- a/docs/client_install/mail-lists.html
+++ b/docs/client_install/mail-lists.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<!-- Generated by Apache Maven Doxia at Mar 3, 2016 -->
+<!-- Generated by Apache Maven Doxia at Mar 15, 2016 -->
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20160303" />
+    <meta name="Date-Revision-yyyymmdd" content="20160315" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
         
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2016-03-03</span>
+        <span id="publishDate">Last Published: 2016-03-15</span>
                   &nbsp;| <span id="projectVersion">Version: 2.0.0</span>
                       </div>
             <div class="xright">                    <a href="./" title="Trafodion Client Installation Guide">Trafodion Client Installation Guide</a>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/client_install/project-info.html
----------------------------------------------------------------------
diff --git a/docs/client_install/project-info.html b/docs/client_install/project-info.html
index 4dac508..bb3ce4a 100644
--- a/docs/client_install/project-info.html
+++ b/docs/client_install/project-info.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<!-- Generated by Apache Maven Doxia at Mar 3, 2016 -->
+<!-- Generated by Apache Maven Doxia at Mar 15, 2016 -->
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20160303" />
+    <meta name="Date-Revision-yyyymmdd" content="20160315" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
         
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2016-03-03</span>
+        <span id="publishDate">Last Published: 2016-03-15</span>
                   &nbsp;| <span id="projectVersion">Version: 2.0.0</span>
                       </div>
             <div class="xright">                    <a href="./" title="Trafodion Client Installation Guide">Trafodion Client Installation Guide</a>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/client_install/project-summary.html
----------------------------------------------------------------------
diff --git a/docs/client_install/project-summary.html b/docs/client_install/project-summary.html
index 03ee9cf..163c823 100644
--- a/docs/client_install/project-summary.html
+++ b/docs/client_install/project-summary.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<!-- Generated by Apache Maven Doxia at Mar 3, 2016 -->
+<!-- Generated by Apache Maven Doxia at Mar 15, 2016 -->
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20160303" />
+    <meta name="Date-Revision-yyyymmdd" content="20160315" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
         
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2016-03-03</span>
+        <span id="publishDate">Last Published: 2016-03-15</span>
                   &nbsp;| <span id="projectVersion">Version: 2.0.0</span>
                       </div>
             <div class="xright">                    <a href="./" title="Trafodion Client Installation Guide">Trafodion Client Installation Guide</a>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/client_install/source-repository.html
----------------------------------------------------------------------
diff --git a/docs/client_install/source-repository.html b/docs/client_install/source-repository.html
index 3ad675d..e8f2b2d 100644
--- a/docs/client_install/source-repository.html
+++ b/docs/client_install/source-repository.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<!-- Generated by Apache Maven Doxia at Mar 3, 2016 -->
+<!-- Generated by Apache Maven Doxia at Mar 15, 2016 -->
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20160303" />
+    <meta name="Date-Revision-yyyymmdd" content="20160315" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
         
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2016-03-03</span>
+        <span id="publishDate">Last Published: 2016-03-15</span>
                   &nbsp;| <span id="projectVersion">Version: 2.0.0</span>
                       </div>
             <div class="xright">                    <a href="./" title="Trafodion Client Installation Guide">Trafodion Client Installation Guide</a>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/client_install/team-list.html
----------------------------------------------------------------------
diff --git a/docs/client_install/team-list.html b/docs/client_install/team-list.html
index 77b29b8..93606ac 100644
--- a/docs/client_install/team-list.html
+++ b/docs/client_install/team-list.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<!-- Generated by Apache Maven Doxia at Mar 3, 2016 -->
+<!-- Generated by Apache Maven Doxia at Mar 15, 2016 -->
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20160303" />
+    <meta name="Date-Revision-yyyymmdd" content="20160315" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
         
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2016-03-03</span>
+        <span id="publishDate">Last Published: 2016-03-15</span>
                   &nbsp;| <span id="projectVersion">Version: 2.0.0</span>
                       </div>
             <div class="xright">                    <a href="./" title="Trafodion Client Installation Guide">Trafodion Client Installation Guide</a>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/command_interface/Trafodion_Command_Interface_Guide.pdf
----------------------------------------------------------------------
diff --git a/docs/command_interface/Trafodion_Command_Interface_Guide.pdf b/docs/command_interface/Trafodion_Command_Interface_Guide.pdf
index 3e682b8..802026c 100644
Binary files a/docs/command_interface/Trafodion_Command_Interface_Guide.pdf and b/docs/command_interface/Trafodion_Command_Interface_Guide.pdf differ

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/command_interface/dependencies.html
----------------------------------------------------------------------
diff --git a/docs/command_interface/dependencies.html b/docs/command_interface/dependencies.html
index 05155a6..8ffdb2f 100644
--- a/docs/command_interface/dependencies.html
+++ b/docs/command_interface/dependencies.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<!-- Generated by Apache Maven Doxia at Mar 3, 2016 -->
+<!-- Generated by Apache Maven Doxia at Mar 15, 2016 -->
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20160303" />
+    <meta name="Date-Revision-yyyymmdd" content="20160315" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
         
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2016-03-03</span>
+        <span id="publishDate">Last Published: 2016-03-15</span>
                   &nbsp;| <span id="projectVersion">Version: 2.0.0</span>
                       </div>
             <div class="xright">                    <a href="./" title="Trafodion Command Interface Guide">Trafodion Command Interface Guide</a>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/f0969233/docs/command_interface/integration.html
----------------------------------------------------------------------
diff --git a/docs/command_interface/integration.html b/docs/command_interface/integration.html
index 4e2fb0f..344548c 100644
--- a/docs/command_interface/integration.html
+++ b/docs/command_interface/integration.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<!-- Generated by Apache Maven Doxia at Mar 3, 2016 -->
+<!-- Generated by Apache Maven Doxia at Mar 15, 2016 -->
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20160303" />
+    <meta name="Date-Revision-yyyymmdd" content="20160315" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
         
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2016-03-03</span>
+        <span id="publishDate">Last Published: 2016-03-15</span>
                   &nbsp;| <span id="projectVersion">Version: 2.0.0</span>
                       </div>
             <div class="xright">                    <a href="./" title="Trafodion Command Interface Guide">Trafodion Command Interface Guide</a>