You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by gt...@apache.org on 2016/11/03 06:27:04 UTC
[12/23] incubator-trafodion-site git commit: TRAFODION-2323:
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/09afbad7/docs/2.1.0/sql_reference/index.html
----------------------------------------------------------------------
diff --git a/docs/2.1.0/sql_reference/index.html b/docs/2.1.0/sql_reference/index.html
index 02f1b79..28a2d06 100644
--- a/docs/2.1.0/sql_reference/index.html
+++ b/docs/2.1.0/sql_reference/index.html
@@ -1966,9 +1966,9 @@ specific language governing permissions and limitations under the License.</p>
the Apache Incubator PMC. Incubation is required of all newly accepted projects until a further review indicates that
the infrastructure, communications, and decision making process have stabilized in a manner consistent with other
successful ASF projects. While incubation status is not necessarily a reflection of the completeness or stability of the code,
-it does indicate that the project has yet to be fully endorsed by the ASF.</em>
-<<<</p>
+it does indicate that the project has yet to be fully endorsed by the ASF.</em></p>
</div>
+<div style="page-break-after: always;"></div>
<div class="paragraph">
<p><strong>Acknowledgements</strong></p>
</div>
@@ -4302,15 +4302,15 @@ connecting to the database.</p>
<p>specifies the new name of the user in the directory service.</p>
</div>
</li>
-</ul>
-</div>
-</li>
<li>
-<p><em>directory-service-username</em> is a regular or delimited case-insensitive
+<p><code><em>directory-service-username</em></code> is a regular or delimited case-insensitive
identifier. See <a href="#Case_Insensitive_Delimited_Identifiers">Case-Insensitive Delimited Identifiers</a>.</p>
</li>
+</ul>
+</div>
+</li>
<li>
-<p>SET { ONLINE | OFFLINE }</p>
+<p><code>SET { ONLINE | OFFLINE }</code></p>
<div class="paragraph">
<p>changes the attribute that controls whether the user is allowed to connect to the database.<br></p>
</div>
@@ -4421,7 +4421,8 @@ INSERT INTO sales.odetail VALUES (125, 4102, 25000, 2);
--- 1 row(s) inserted.
-UPDATE invent.partloc SET qty_on_hand = qty_on_hand - 2 WHERE partnum = 4102 AND loc_code = 'G45';
+UPDATE invent.partloc SET qty_on_hand = qty_on_hand - 2
+ WHERE partnum = 4102 AND loc_code = 'G45';
--- 1 row(s) updated.
@@ -9224,7 +9225,7 @@ DROP ROLE clerks;
<div class="sect2">
<h3 id="drop_schema_statement">3.23. DROP SCHEMA Statement</h3>
<div class="paragraph">
-<p>The DROP SCHEMA statement drops a schema from the database. See<a href="#schemas">Schemas</a>.</p>
+<p>The DROP SCHEMA statement drops a schema from the database. See <a href="#schemas">Schemas</a>.</p>
</div>
<div class="admonitionblock note">
<table>
@@ -9242,7 +9243,7 @@ AUTOCOMMIT must be turned ON (the default) for the session.
</div>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">DROP SCHEMA schema-name [IF EXISTS] [RESTRICT|CASCADE]</code></pre>
+<pre class="CodeRay highlight"><code data-lang="text">DROP SCHEMA [IF EXISTS] schema-name [RESTRICT|CASCADE]</code></pre>
</div>
</div>
<div class="sect3">
@@ -9723,7 +9724,7 @@ execute other SQL statements (for example, SELECT). For more information on the
</div>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">EXPLAIN [OPTIONS {'f'}] {FOR QID query-text | prepared-stmt-name}</code></pre>
+<pre class="CodeRay highlight"><code data-lang="text">EXPLAIN [OPTIONS {'f'}] { FOR QID query-id | FOR QID CURRENT | prepared-stmt-name }</code></pre>
</div>
</div>
<div class="paragraph">
@@ -9742,9 +9743,15 @@ See <a href="#explain_formatted_considerations">Formatted [OPTIONS 'f'] Consider
</div>
</li>
<li>
-<p><code><em>query-text</em></code></p>
+<p><code><em>CURRENT</em></code></p>
+<div class="paragraph">
+<p>provide information for the latest compiled query.</p>
+</div>
+</li>
+<li>
+<p><code><em>query-id</em></code></p>
<div class="paragraph">
-<p>a DML statement such as <code>SELECT * FROM T3</code>.</p>
+<p>specifies the query ID of an executing query, which is a unique identifier generated by the SQL compiler.</p>
</div>
</li>
<li>
@@ -9878,13 +9885,14 @@ operators and their order within the query execution plan.</p>
</div>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">>>explain options 'f' select * from region;
+<pre class="CodeRay highlight"><code data-lang="text">>>explain options 'f' for qid MXID11002015016212343685134956677000000000206U3333300_652_XX;
-LC RC OP OPERATOR OPT DESCRIPTION CARD
----- ---- ---- -------------------- -------- -------------------- ---------
-1 . 2 root 1.00E+002
-. . 1 trafodion_scan REGION 1.00E+002
+LC RC OP OPERATOR OPT DESCRIPTION CARD
+---- ---- ---- -------------------- -------- -------------------- ---------
+
+1 . 2 root 1.00E+000
+. . 1 hbase_aggr 1.00E+000
--- SQL operation complete.</code></pre>
</div>
@@ -12701,7 +12709,7 @@ grantee is:
</div>
</li>
<li>
-<p>[ RESTRICT | CASCADE ]</p>
+<p><code>[ RESTRICT | CASCADE ]</code></p>
<div class="paragraph">
<p>If you specify RESTRICT, the REVOKE ROLE operation fails if any privileges were granted to
the role or any objects were created based upon those privileges.</p>
@@ -14027,7 +14035,9 @@ with numbers less than or equal to 3000, displaying the results in ascending ord
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">SELECT jobcode, deptnum, first_name, last_name, salary
FROM persnl.employee
-WHERE jobcode > 500 AND deptnum <= 3000 ORDER BY jobcode;
+WHERE jobcode > 500
+ AND deptnum <= 3000
+ORDER BY jobcode;
DEPTNUM FIRST_NAME LAST_NAME SALARY
------- --------------- ----------- ----------
@@ -14043,8 +14053,11 @@ DEPTNUM FIRST_NAME LAST_NAME SALARY
<p>Display selected rows grouped by job code in ascending order:</p>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">SELECT jobcode, AVG(salary) FROM persnl.employee
-WHERE jobcode > 500 AND deptnum <= 3000 GROUP BY jobcode
+<pre class="CodeRay highlight"><code data-lang="text">SELECT jobcode, AVG(salary)
+FROM persnl.employee
+WHERE jobcode > 500
+ AND deptnum <= 3000
+GROUP BY jobcode
ORDER BY jobcode;
JOBCODE EXPR
@@ -14072,7 +14085,8 @@ condition for selecting rows of the result in the WHERE clause:</p>
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">SELECT jobdesc, first_name, last_name, salary
FROM persnl.employee E, persnl.job J
-WHERE E.jobcode = J.jobcode AND E.jobcode IN (900, 300, 420);
+WHERE E.jobcode = J.jobcode
+ AND E.jobcode IN (900, 300, 420);
JOBDESC FIRST_NAME LAST_NAME SALARY
------------ ------------ --------------- -----------
@@ -14389,9 +14403,11 @@ groups by the maximum salary of each group:</p>
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">SELECT E.jobcode, E.deptnum, MIN (salary), MAX (salary)
FROM persnl.employee E, persnl.dept D, persnl.job J
-WHERE E.deptnum = D.deptnum AND E.jobcode = J.jobcode
- AND E.jobcode IN (900, 300, 420)
-GROUP BY E.jobcode, E.deptnum ORDER BY 4;
+WHERE E.deptnum = D.deptnum
+ AND E.jobcode = J.jobcode
+ AND E.jobcode IN (900, 300, 420)
+GROUP BY E.jobcode, E.deptnum
+ORDER BY 4;
JOBCODE DEPTNUM (EXPR) (EXPR)
------- ------- ----------- -----------
@@ -15365,10 +15381,10 @@ keyword is selected:</p>
Histogram data for Table CAT.SCH.A Table ID: 341261536378386
Hist ID # Ints Rowcount UEC Colname(s)
========== ====== =========== ==============================
-623327638 1 11 10 ABC, DEF, GHI
-623327633 10 11 10 ABC
-623327628 9 11 9 DEF
-623327623 10 11 10 GHI
+ 623327638 1 11 10 ABC, DEF, GHI
+ 623327633 10 11 10 ABC
+ 623327628 9 11 9 DEF
+ 623327623 10 11 10 GHI
--- SQL operation complete.
@@ -15377,7 +15393,7 @@ Hist ID # Ints Rowcount UEC Colname(s)
Histogram data for Table CAT.SCH.A Table ID: 341261536378386
Hist ID # Ints Rowcount UEC Colname(s)
========== ====== =========== ==============================
- 623327633 10 11 10 ABC
+ 623327633 10 11 10 ABC
--- SQL operation complete.
@@ -16431,7 +16447,7 @@ data and generates an error when it detects duplicates.</p>
</div>
</li>
<li>
-<p>`NO OUTPUT</p>
+<p><code>NO OUTPUT</code></p>
<div class="paragraph">
<p>prevents the LOAD statement from displaying status messages. By default,
the LOAD statement prints status messages listing the steps that the
@@ -18711,7 +18727,7 @@ INSERT INTO T VALUES (1.1234, 2.1234);
(EXPR)
--------------
-3.246</code></pre>
+ 3.246</code></pre>
</div>
</div>
<div class="paragraph">
@@ -18736,7 +18752,7 @@ INSERT INTO T VALUES (1.1234, 2.1234);
(EXPR)
------------
-3.2468</code></pre>
+ 3.2468</code></pre>
</div>
</div>
<div class="paragraph">
@@ -23709,7 +23725,7 @@ For example, this query has one level of nesting:</p>
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">SELECT * FROM table1
WHERE A = (SELECT P FROM table2 WHERE q = 1)
-AND b = (SELECT x FROM table3 WHERE y = 2);</code></pre>
+ AND b = (SELECT x FROM table3 WHERE y = 2);</code></pre>
</div>
</div>
<div class="paragraph">
@@ -23719,9 +23735,9 @@ level, however, so this query has two levels of nesting:</p>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">SELECT * FROM table1
-WHERE a = (SELECT p FROM table2
-WHERE q = (SELECT x FROM table3
-WHERE y = 2))</code></pre>
+ WHERE a = (SELECT p FROM table2
+ WHERE q = (SELECT x FROM table3
+ WHERE y = 2))</code></pre>
</div>
</div>
<div class="paragraph">
@@ -24870,7 +24886,7 @@ BALANCE
WHEN sex = 'female' THEN 15 ROWS
END
ORDER BY age;
-+
+
AGE SEX SALARY
----------- ------ -----------
22 male 28000.00
@@ -41929,7 +41945,7 @@ or 256 bytes of UTF8 text, whichever is less.</p></td>
<div id="footer">
<div id="footer-text">
Version 2.1.0<br>
-Last updated 2016-07-18 16:17:03 UTC
+Last updated 2016-11-03 05:29:06 UTC
</div>
</div>
<script>
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/09afbad7/docs/2.1.0/sql_reference/integration.html
----------------------------------------------------------------------
diff --git a/docs/2.1.0/sql_reference/integration.html b/docs/2.1.0/sql_reference/integration.html
index 224b1db..180ecf4 100644
--- a/docs/2.1.0/sql_reference/integration.html
+++ b/docs/2.1.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 Oct 20, 2016 -->
+<!-- Generated by Apache Maven Doxia at Nov 3, 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="20161020" />
+ <meta name="Date-Revision-yyyymmdd" content="20161103" />
<meta http-equiv="Content-Language" content="en" />
</head>
@@ -27,7 +27,7 @@
<div class="xleft">
- <span id="publishDate">Last Published: 2016-10-20</span>
+ <span id="publishDate">Last Published: 2016-11-03</span>
| <span id="projectVersion">Version: 2.1.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/09afbad7/docs/2.1.0/sql_reference/issue-tracking.html
----------------------------------------------------------------------
diff --git a/docs/2.1.0/sql_reference/issue-tracking.html b/docs/2.1.0/sql_reference/issue-tracking.html
index 4ad01cf..7c7d5b7 100644
--- a/docs/2.1.0/sql_reference/issue-tracking.html
+++ b/docs/2.1.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 Oct 20, 2016 -->
+<!-- Generated by Apache Maven Doxia at Nov 3, 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="20161020" />
+ <meta name="Date-Revision-yyyymmdd" content="20161103" />
<meta http-equiv="Content-Language" content="en" />
</head>
@@ -27,7 +27,7 @@
<div class="xleft">
- <span id="publishDate">Last Published: 2016-10-20</span>
+ <span id="publishDate">Last Published: 2016-11-03</span>
| <span id="projectVersion">Version: 2.1.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/09afbad7/docs/2.1.0/sql_reference/license.html
----------------------------------------------------------------------
diff --git a/docs/2.1.0/sql_reference/license.html b/docs/2.1.0/sql_reference/license.html
index acd925c..c9ca198 100644
--- a/docs/2.1.0/sql_reference/license.html
+++ b/docs/2.1.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 Oct 20, 2016 -->
+<!-- Generated by Apache Maven Doxia at Nov 3, 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="20161020" />
+ <meta name="Date-Revision-yyyymmdd" content="20161103" />
<meta http-equiv="Content-Language" content="en" />
</head>
@@ -27,7 +27,7 @@
<div class="xleft">
- <span id="publishDate">Last Published: 2016-10-20</span>
+ <span id="publishDate">Last Published: 2016-11-03</span>
| <span id="projectVersion">Version: 2.1.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/09afbad7/docs/2.1.0/sql_reference/mail-lists.html
----------------------------------------------------------------------
diff --git a/docs/2.1.0/sql_reference/mail-lists.html b/docs/2.1.0/sql_reference/mail-lists.html
index 4a3cdf5..853eb79 100644
--- a/docs/2.1.0/sql_reference/mail-lists.html
+++ b/docs/2.1.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 Oct 20, 2016 -->
+<!-- Generated by Apache Maven Doxia at Nov 3, 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="20161020" />
+ <meta name="Date-Revision-yyyymmdd" content="20161103" />
<meta http-equiv="Content-Language" content="en" />
</head>
@@ -27,7 +27,7 @@
<div class="xleft">
- <span id="publishDate">Last Published: 2016-10-20</span>
+ <span id="publishDate">Last Published: 2016-11-03</span>
| <span id="projectVersion">Version: 2.1.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/09afbad7/docs/2.1.0/sql_reference/project-info.html
----------------------------------------------------------------------
diff --git a/docs/2.1.0/sql_reference/project-info.html b/docs/2.1.0/sql_reference/project-info.html
index 263a34e..8400d01 100644
--- a/docs/2.1.0/sql_reference/project-info.html
+++ b/docs/2.1.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 Oct 20, 2016 -->
+<!-- Generated by Apache Maven Doxia at Nov 3, 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="20161020" />
+ <meta name="Date-Revision-yyyymmdd" content="20161103" />
<meta http-equiv="Content-Language" content="en" />
</head>
@@ -27,7 +27,7 @@
<div class="xleft">
- <span id="publishDate">Last Published: 2016-10-20</span>
+ <span id="publishDate">Last Published: 2016-11-03</span>
| <span id="projectVersion">Version: 2.1.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/09afbad7/docs/2.1.0/sql_reference/project-summary.html
----------------------------------------------------------------------
diff --git a/docs/2.1.0/sql_reference/project-summary.html b/docs/2.1.0/sql_reference/project-summary.html
index ba5c216..efaff49 100644
--- a/docs/2.1.0/sql_reference/project-summary.html
+++ b/docs/2.1.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 Oct 20, 2016 -->
+<!-- Generated by Apache Maven Doxia at Nov 3, 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="20161020" />
+ <meta name="Date-Revision-yyyymmdd" content="20161103" />
<meta http-equiv="Content-Language" content="en" />
</head>
@@ -27,7 +27,7 @@
<div class="xleft">
- <span id="publishDate">Last Published: 2016-10-20</span>
+ <span id="publishDate">Last Published: 2016-11-03</span>
| <span id="projectVersion">Version: 2.1.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/09afbad7/docs/2.1.0/sql_reference/source-repository.html
----------------------------------------------------------------------
diff --git a/docs/2.1.0/sql_reference/source-repository.html b/docs/2.1.0/sql_reference/source-repository.html
index 9194d2f..373084e 100644
--- a/docs/2.1.0/sql_reference/source-repository.html
+++ b/docs/2.1.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 Oct 20, 2016 -->
+<!-- Generated by Apache Maven Doxia at Nov 3, 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="20161020" />
+ <meta name="Date-Revision-yyyymmdd" content="20161103" />
<meta http-equiv="Content-Language" content="en" />
</head>
@@ -27,7 +27,7 @@
<div class="xleft">
- <span id="publishDate">Last Published: 2016-10-20</span>
+ <span id="publishDate">Last Published: 2016-11-03</span>
| <span id="projectVersion">Version: 2.1.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/09afbad7/docs/2.1.0/sql_reference/team-list.html
----------------------------------------------------------------------
diff --git a/docs/2.1.0/sql_reference/team-list.html b/docs/2.1.0/sql_reference/team-list.html
index 823fe2b..b0ab8f8 100644
--- a/docs/2.1.0/sql_reference/team-list.html
+++ b/docs/2.1.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 Oct 20, 2016 -->
+<!-- Generated by Apache Maven Doxia at Nov 3, 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="20161020" />
+ <meta name="Date-Revision-yyyymmdd" content="20161103" />
<meta http-equiv="Content-Language" content="en" />
</head>
@@ -27,7 +27,7 @@
<div class="xleft">
- <span id="publishDate">Last Published: 2016-10-20</span>
+ <span id="publishDate">Last Published: 2016-11-03</span>
| <span id="projectVersion">Version: 2.1.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/09afbad7/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 d9dd4a9..1809170 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/09afbad7/docs/client_install/dependencies.html
----------------------------------------------------------------------
diff --git a/docs/client_install/dependencies.html b/docs/client_install/dependencies.html
index d3f3697..d71f8f6 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 Oct 20, 2016 -->
+<!-- Generated by Apache Maven Doxia at Nov 3, 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="20161020" />
+ <meta name="Date-Revision-yyyymmdd" content="20161103" />
<meta http-equiv="Content-Language" content="en" />
</head>
@@ -27,7 +27,7 @@
<div class="xleft">
- <span id="publishDate">Last Published: 2016-10-20</span>
+ <span id="publishDate">Last Published: 2016-11-03</span>
| <span id="projectVersion">Version: 2.1.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/09afbad7/docs/client_install/images/Database_Connection_in_DbVisualizer.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/images/Database_Connection_in_DbVisualizer.jpg b/docs/client_install/images/Database_Connection_in_DbVisualizer.jpg
index 5cd345c..4dc5931 100644
Binary files a/docs/client_install/images/Database_Connection_in_DbVisualizer.jpg and b/docs/client_install/images/Database_Connection_in_DbVisualizer.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/09afbad7/docs/client_install/images/DbVisualizer_Driver_Manager.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/images/DbVisualizer_Driver_Manager.jpg b/docs/client_install/images/DbVisualizer_Driver_Manager.jpg
index 535d96f..617bbad 100644
Binary files a/docs/client_install/images/DbVisualizer_Driver_Manager.jpg and b/docs/client_install/images/DbVisualizer_Driver_Manager.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/09afbad7/docs/client_install/images/Extracted_Files.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/images/Extracted_Files.jpg b/docs/client_install/images/Extracted_Files.jpg
index b272015..f905b30 100644
Binary files a/docs/client_install/images/Extracted_Files.jpg and b/docs/client_install/images/Extracted_Files.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/09afbad7/docs/client_install/images/InstallComplete.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/images/InstallComplete.jpg b/docs/client_install/images/InstallComplete.jpg
index a565be3..20d88c6 100644
Binary files a/docs/client_install/images/InstallComplete.jpg and b/docs/client_install/images/InstallComplete.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/09afbad7/docs/client_install/images/Physical_Connection.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/images/Physical_Connection.jpg b/docs/client_install/images/Physical_Connection.jpg
index b5d3475..257c44b 100644
Binary files a/docs/client_install/images/Physical_Connection.jpg and b/docs/client_install/images/Physical_Connection.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/09afbad7/docs/client_install/images/SQuirrel_Add_Alias.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/images/SQuirrel_Add_Alias.jpg b/docs/client_install/images/SQuirrel_Add_Alias.jpg
new file mode 100644
index 0000000..35fd141
Binary files /dev/null and b/docs/client_install/images/SQuirrel_Add_Alias.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/09afbad7/docs/client_install/images/SQuirrel_Extra_Class_Path.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/images/SQuirrel_Extra_Class_Path.jpg b/docs/client_install/images/SQuirrel_Extra_Class_Path.jpg
new file mode 100644
index 0000000..ccdbf27
Binary files /dev/null and b/docs/client_install/images/SQuirrel_Extra_Class_Path.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/09afbad7/docs/client_install/images/SQuirrel_New_Driver.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/images/SQuirrel_New_Driver.jpg b/docs/client_install/images/SQuirrel_New_Driver.jpg
new file mode 100644
index 0000000..a881bd8
Binary files /dev/null and b/docs/client_install/images/SQuirrel_New_Driver.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/09afbad7/docs/client_install/images/tableau_connect.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/images/tableau_connect.jpg b/docs/client_install/images/tableau_connect.jpg
new file mode 100644
index 0000000..dcc7062
Binary files /dev/null and b/docs/client_install/images/tableau_connect.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/09afbad7/docs/client_install/images/trafci_Installation_Choices.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/images/trafci_Installation_Choices.jpg b/docs/client_install/images/trafci_Installation_Choices.jpg
new file mode 100644
index 0000000..4a98b6b
Binary files /dev/null and b/docs/client_install/images/trafci_Installation_Choices.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/09afbad7/docs/client_install/images/winodbc_admin_add.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/images/winodbc_admin_add.jpg b/docs/client_install/images/winodbc_admin_add.jpg
new file mode 100644
index 0000000..da4413f
Binary files /dev/null and b/docs/client_install/images/winodbc_admin_add.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/09afbad7/docs/client_install/images/winodbc_admin_add_general.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/images/winodbc_admin_add_general.jpg b/docs/client_install/images/winodbc_admin_add_general.jpg
new file mode 100644
index 0000000..ab90336
Binary files /dev/null and b/docs/client_install/images/winodbc_admin_add_general.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/09afbad7/docs/client_install/images/winodbc_admin_add_general_edited.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/images/winodbc_admin_add_general_edited.jpg b/docs/client_install/images/winodbc_admin_add_general_edited.jpg
new file mode 100644
index 0000000..7e1bd93
Binary files /dev/null and b/docs/client_install/images/winodbc_admin_add_general_edited.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/09afbad7/docs/client_install/images/winodbc_admin_add_network.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/images/winodbc_admin_add_network.jpg b/docs/client_install/images/winodbc_admin_add_network.jpg
new file mode 100644
index 0000000..a540734
Binary files /dev/null and b/docs/client_install/images/winodbc_admin_add_network.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/09afbad7/docs/client_install/images/winodbc_admin_add_schema.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/images/winodbc_admin_add_schema.jpg b/docs/client_install/images/winodbc_admin_add_schema.jpg
new file mode 100644
index 0000000..fbdfa7a
Binary files /dev/null and b/docs/client_install/images/winodbc_admin_add_schema.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/09afbad7/docs/client_install/images/winodbc_admin_add_test_connection.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/images/winodbc_admin_add_test_connection.jpg b/docs/client_install/images/winodbc_admin_add_test_connection.jpg
new file mode 100644
index 0000000..93a4f9f
Binary files /dev/null and b/docs/client_install/images/winodbc_admin_add_test_connection.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/09afbad7/docs/client_install/images/winodbc_admin_add_tested_connection.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/images/winodbc_admin_add_tested_connection.jpg b/docs/client_install/images/winodbc_admin_add_tested_connection.jpg
new file mode 100644
index 0000000..b9dbf65
Binary files /dev/null and b/docs/client_install/images/winodbc_admin_add_tested_connection.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/09afbad7/docs/client_install/images/winodbc_admin_add_translate_dll.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/images/winodbc_admin_add_translate_dll.jpg b/docs/client_install/images/winodbc_admin_add_translate_dll.jpg
new file mode 100644
index 0000000..8af9875
Binary files /dev/null and b/docs/client_install/images/winodbc_admin_add_translate_dll.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/09afbad7/docs/client_install/images/winodbc_admin_intro.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/images/winodbc_admin_intro.jpg b/docs/client_install/images/winodbc_admin_intro.jpg
new file mode 100644
index 0000000..e1c206f
Binary files /dev/null and b/docs/client_install/images/winodbc_admin_intro.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/09afbad7/docs/client_install/images/winodbc_destination.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/images/winodbc_destination.jpg b/docs/client_install/images/winodbc_destination.jpg
new file mode 100644
index 0000000..e31e275
Binary files /dev/null and b/docs/client_install/images/winodbc_destination.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/09afbad7/docs/client_install/images/winodbc_install_finished.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/images/winodbc_install_finished.jpg b/docs/client_install/images/winodbc_install_finished.jpg
new file mode 100644
index 0000000..5260f3d
Binary files /dev/null and b/docs/client_install/images/winodbc_install_finished.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/09afbad7/docs/client_install/images/winodbc_license.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/images/winodbc_license.jpg b/docs/client_install/images/winodbc_license.jpg
new file mode 100644
index 0000000..3ca6bb6
Binary files /dev/null and b/docs/client_install/images/winodbc_license.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/09afbad7/docs/client_install/images/winodbc_ready_to_install.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/images/winodbc_ready_to_install.jpg b/docs/client_install/images/winodbc_ready_to_install.jpg
new file mode 100644
index 0000000..7f672f1
Binary files /dev/null and b/docs/client_install/images/winodbc_ready_to_install.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/09afbad7/docs/client_install/images/winodbc_welcome.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/images/winodbc_welcome.jpg b/docs/client_install/images/winodbc_welcome.jpg
new file mode 100644
index 0000000..9b6d2fd
Binary files /dev/null and b/docs/client_install/images/winodbc_welcome.jpg differ