http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.2.0/sql_reference/dependencies.html ---------------------------------------------------------------------- diff --git a/docs/2.2.0/sql_reference/dependencies.html b/docs/2.2.0/sql_reference/dependencies.html index d21c2d6..53650a0 100644 --- a/docs/2.2.0/sql_reference/dependencies.html +++ b/docs/2.2.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 Jun 23, 2017 --> +<!-- Generated by Apache Maven Doxia at May 3, 2017 --> <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="20170623" /> + <meta name="Date-Revision-yyyymmdd" content="20170503" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2017-06-23</span> + <span id="publishDate">Last Published: 2017-05-03</span> | <span id="projectVersion">Version: 2.2.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/c9ae8c27/docs/2.2.0/sql_reference/index.html ---------------------------------------------------------------------- diff --git a/docs/2.2.0/sql_reference/index.html b/docs/2.2.0/sql_reference/index.html index eb489fe..e9ef5e0 100644 --- a/docs/2.2.0/sql_reference/index.html +++ b/docs/2.2.0/sql_reference/index.html @@ -2139,12 +2139,8 @@ with the furnishing, performance, or use of this material.</p> </thead> <tbody> <tr> -<td class="tableblock halign-left valign-top"><p class="tableblock">2.2.0</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">TBD</p></td> -</tr> -<tr> <td class="tableblock halign-left valign-top"><p class="tableblock">2.1.0</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">May 1, 2017</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">TBD</p></td> </tr> <tr> <td class="tableblock halign-left valign-top"><p class="tableblock">2.0.1</p></td> @@ -2888,10 +2884,6 @@ select * from hive.hive.t; -- explicit table name</code></pre> <tbody> <tr> <td class="tableblock halign-left valign-top"><p class="tableblock"><code>tinyint</code></p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock"><code>tinyint</code></p></td> -</tr> -<tr> -<td class="tableblock halign-left valign-top"><p class="tableblock"><code>tinyint</code></p></td> <td class="tableblock halign-left valign-top"><p class="tableblock"><code>smallint</code></p></td> </tr> <tr> @@ -2911,33 +2903,16 @@ select * from hive.hive.t; -- explicit table name</code></pre> <td class="tableblock halign-left valign-top"><p class="tableblock"><code>varchar(<em>n</em> bytes) character set utf8</code><sup>1</sup></p></td> </tr> <tr> -<td class="tableblock halign-left valign-top"><p class="tableblock"><code>varchar</code></p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock"><code>varchar</code></p></td> -</tr> -<tr> -<td class="tableblock halign-left valign-top"><p class="tableblock"><code>char</code></p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock"><code>char</code></p></td> -</tr> -<tr> <td class="tableblock halign-left valign-top"><p class="tableblock"><code>float</code></p></td> <td class="tableblock halign-left valign-top"><p class="tableblock"><code>real</code></p></td> </tr> <tr> -<td class="tableblock halign-left valign-top"><p class="tableblock"><code>decimal (precision, scale)</code></p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock"><code>decimal (precision, scale)</code><sup>2</sup><br> -<code>numeric (precision, scale)</code><sup>3</sup></p></td> -</tr> -<tr> <td class="tableblock halign-left valign-top"><p class="tableblock"><code>double</code></p></td> <td class="tableblock halign-left valign-top"><p class="tableblock"><code>float(54)</code></p></td> </tr> <tr> <td class="tableblock halign-left valign-top"><p class="tableblock"><code>timestamp</code></p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock"><code>timestamp(6)</code><sup>4</sup></p></td> -</tr> -<tr> -<td class="tableblock halign-left valign-top"><p class="tableblock"><code>date</code></p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock"><code>date</code></p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock"><code>timestamp(6)</code><sup>2</sup></p></td> </tr> </tbody> </table> @@ -2948,12 +2923,6 @@ select * from hive.hive.t; -- explicit table name</code></pre> <a href="http://trafodion.incubator.apache.org/docs/cqd_reference/index.hmtl";>Trafodion Control Query Default (CQD) Reference Guide</a>.</p> </li> <li> -<p>If p is less than or equal to 18, decimal (precision, scale) is mapped to decimal (precision, scale).</p> -</li> -<li> -<p>If p is greater than 18, decimal (precision, scale) is mapped to numeric (precision, scale).</p> -</li> -<li> <p>Hive supports timestamps with nanosecond resolution (precision of 9). Trafodion SQL supports only microsecond resolution (precision 6).</p> </li> </ol> @@ -18792,7 +18761,7 @@ establish existing columns.</p> <p>The NECESSARY COLUMN[S] keyword generates statistics for histograms that the optimizer has requested but do not exist. Update statistics automation must be enabled for NECESSARY COLUMN[S] to generate -statistics.</p> +statistics. To enable automation, see <a href="#update_statistics_automating_update_statistics">Automating Update Statistics</a>.</p> </div> </li> </ul> @@ -19133,6 +19102,50 @@ of the columns being joined) help the optimizer choose a better plan.</p> </div> </div> <div class="sect4"> +<h5 id="update_statistics_automating_update_statistics">Automating Update Statistics</h5> +<div class="paragraph"> +<p>To enable update statistics automation, set the Control Query Default +(CQD) attribute, USTAT_AUTOMATION_INTERVAL, in a session where you will +run update statistics operations. For example:</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">control query default USTAT_AUTOMATION_INTERVAL '1440';</code></pre> +</div> +</div> +<div class="paragraph"> +<p>The value of USTAT_AUTOMATION_INTERVAL is intended to be an automation +interval (in minutes), but, in Trafodion Release 1.0, this value does +not act as a timing interval. Instead, any value greater than zero +enables update statistics automation.</p> +</div> +<div class="paragraph"> +<p>After enabling update statistics automation, prepare each of the queries +that you want to optimize. For example:</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">prepare s from select...;</code></pre> +</div> +</div> +<div class="paragraph"> +<p>The PREPARE statement causes the Trafodion SQL compiler to compile and +optimize a query without executing it. When preparing queries with +update statistic automation enabled, any histograms needed by the +optimizer that are not present will cause those columns to be marked as +needing histograms.</p> +</div> +<div class="paragraph"> +<p>Next, run this UPDATE STATISTICS statement against each table, using ON +NECESSARY COLUMN[S] to generate the needed histograms:</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">update statistics for table _table-name_ on necessary columns sample;</code></pre> +</div> +</div> +</div> +<div class="sect4"> <h5 id="update_statistics_incremental_update_statistics">Incremental Update Statistics</h5> <div class="paragraph"> <p>UPDATE STATISTICS processing time can be lengthy for very large tables. @@ -19700,15 +19713,13 @@ more information, see <a href="#cast_expression">CAST Expression</a>.</p> </div> <table class="tableblock frame-all grid-all spread"> <colgroup> -<col style="width: 14%;"> -<col style="width: 14%;"> -<col style="width: 24%;"> -<col style="width: 24%;"> -<col style="width: 24%;"> +<col style="width: 13%;"> +<col style="width: 28.9999%;"> +<col style="width: 28.9999%;"> +<col style="width: 29.0002%;"> </colgroup> <thead> <tr> -<th class="tableblock halign-left valign-top">Category</th> <th class="tableblock halign-left valign-top">Type</th> <th class="tableblock halign-left valign-top">SQL Designation</th> <th class="tableblock halign-left valign-top">Description</th> @@ -19717,140 +19728,76 @@ more information, see <a href="#cast_expression">CAST Expression</a>.</p> </thead> <tbody> <tr> -<td class="tableblock halign-left valign-top" rowspan="7"><p class="tableblock">Character String Data Type</p></td> -<td class="tableblock halign-left valign-top" rowspan="3"><p class="tableblock">Fixed-length character</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Fixed-length character</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">CHAR[ACTER]</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">Fixed-length character data</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">1 to 200000 characters<sup>2</sup> <sup>8</sup></p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">1 to 32707 characters<sup>2</sup></p></td> </tr> <tr> +<td class="tableblock halign-left valign-top"></td> <td class="tableblock halign-left valign-top"><p class="tableblock">NCHAR</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">Fixed-length character data in predefined national character set</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">1 to 200000 bytes<sup>3</sup> <sup>7</sup> <sup>9</sup></p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">1 to 32707 bytes<sup>3</sup> <sup>7</sup></p></td> </tr> <tr> +<td class="tableblock halign-left valign-top"></td> <td class="tableblock halign-left valign-top"><p class="tableblock">NATIONAL CHAR[ACTER]</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">Fixed-length character data in predefined national character set</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">1 to 200000 bytes<sup>3</sup> <sup>7</sup> <sup>9</sup></p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">1 to 32707 bytes<sup>3</sup> <sup>7</sup></p></td> </tr> <tr> -<td class="tableblock halign-left valign-top" rowspan="4"><p class="tableblock">Variable-length character</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Variable-length character</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">VARCHAR</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">Variable-length ASCII character string</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">1 to 200000 characters<sup>4</sup> <sup>8</sup></p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">1 to 32703 characters<sup>4</sup></p></td> </tr> <tr> +<td class="tableblock halign-left valign-top"></td> <td class="tableblock halign-left valign-top"><p class="tableblock">CHAR[ACTER] VARYING</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">Variable-length ASCII character string</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">1 to 200000 characters<sup>4</sup> <sup>8</sup></p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">1 to 32703 characters<sup>4</sup></p></td> </tr> <tr> +<td class="tableblock halign-left valign-top"></td> <td class="tableblock halign-left valign-top"><p class="tableblock">NCHAR VARYING</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">Variable-length ASCII character string</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">1 to 200000 bytes<sup>4</sup> <sup>7</sup> <sup>9</sup></p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">1 to 32703 bytes<sup>4</sup> <sup>8</sup></p></td> </tr> <tr> +<td class="tableblock halign-left valign-top"></td> <td class="tableblock halign-left valign-top"><p class="tableblock">NATIONAL CHAR[ACTER] VARYING</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">Variable-length ASCII character string</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">1 to 200000 characters<sup>4</sup> <sup>7</sup> <sup>8</sup></p></td> -</tr> -<tr> -<td class="tableblock halign-left valign-top" rowspan="6"><p class="tableblock">Datetime Data Types</p></td> -<td class="tableblock halign-left valign-top" rowspan="6"><p class="tableblock">Date-Time</p></td> -<td class="tableblock halign-left valign-top"></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">Point in time, using the Gregorian calendar and a 24 hour clock system. The five supported designations are listed below.</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">YEAR 0001-9999<br> -MONTH 1-12<br> -DAY 1-31<br> -DAY constrained by MONTH and YEAR<br> -<br> -HOUR 0-23<br> -MINUTE 0-59<br> -SECOND 0-59<br> -FRACTION(n) 0-999999<br> -in which n is the number of significant digits, from 1 to 6 -(default is 6; minimum is 1; maximum is 6).<br> -<br> -Actual database storage is incremental, as follows: -YEAR in 2 bytes<br> -MONTH in 1 byte<br> -DAY in 1 byte<br> -HOUR in 1 byte<br> -MINUTE in 1 -byte SECOND in 1 byte<br> -FRACTION in 4 bytes<br></p></td> -</tr> -<tr> -<td class="tableblock halign-left valign-top"><p class="tableblock">DATE</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">Date</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">Format as YYYY-MM-DD; actual database storage size is 4 bytes</p></td> -</tr> -<tr> -<td class="tableblock halign-left valign-top"><p class="tableblock">TIME</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">Time of day, 24 hour clock, no time precision.</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">Format as HH:MM:SS; actual database storage size is 3 bytes</p></td> -</tr> -<tr> -<td class="tableblock halign-left valign-top"><p class="tableblock">TIME (with time precision)</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">Time of day, 24 hour clock, with time precision</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">Format as HH:MM:SS.FFFFFF; actual database storage size is 7 bytes</p></td> -</tr> -<tr> -<td class="tableblock halign-left valign-top"><p class="tableblock">TIMESTAMP</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">Point in time, no time precision</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">Format as YYYY-MM-DD HH:MM:SS.FFFFFF; actual database storage size is 11 bytes</p></td> -</tr> -<tr> -<td class="tableblock halign-left valign-top"><p class="tableblock">TIMESTAMP (with time precision)</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">Point in time, with time precision</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">Format as YYYY-MM-DD HH:MM:SS.FFFFFF; actual database storage size is 1 byte</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">1 to 32703 characters<sup>4</sup> <sup>8</sup></p></td> </tr> <tr> -<td class="tableblock halign-left valign-top"><p class="tableblock">Interval Data Types</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">Interval</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">INTERVAL</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">Duration of time; value is in the YEAR/MONTH range or the DAY/HOUR/MINUTE/YEAR/SECOND/FRACTION range</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">YEAR no constraint<sup>5</sup><br> -MONTH 0-11<br> -DAY no constraint<br> -HOUR 0-23<br> -MINUTE 0-59<br> -SECOND 0-59<br> -FRACTION(n) 0-999999<br> -in which n is the number of significant digits (default is 6; minimum is 1; maximum is 6);<br> -stored in 2, 4, or 8 bytes depending on number of digits<sup>2</sup></p></td> -</tr> -<tr> -<td class="tableblock halign-left valign-top" rowspan="10"><p class="tableblock">Numeric Data Types</p></td> -<td class="tableblock halign-left valign-top" rowspan="5"><p class="tableblock">Numeric</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">NUMERIC (1,<em>scale</em>) to + NUMERIC (128,<em>scale</em>)</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Numeric</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">NUMERIC (1,<em>scale</em>) to<br> +NUMERIC (128,<em>scale</em>)</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">Binary number with optional scale; signed or unsigned for 1 to 9 digits</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">1 to 128 digits;<br> -stored:<br> +<td class="tableblock halign-left valign-top"><p class="tableblock">1 to 128 digits; stored:<br> 1 to 4 digits in 2 bytes<br> +<br> 5 to 9 digits in 4 bytes<br> -10 to 128 digits in 8-64 bytes<br> -depending on precision</p></td> -</tr> -<tr> -<td class="tableblock halign-left valign-top"><p class="tableblock">TINYINT</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">Binary integer; signed or unsigned</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">0 to 255 unsigned, -128 to +127 signed; stored in 1 byte</p></td> +<br> +10 to 128 digits in 8-64 bytes, depending on precision</p></td> </tr> <tr> +<td class="tableblock halign-left valign-top"></td> <td class="tableblock halign-left valign-top"><p class="tableblock">SMALLINT</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">Binary integer; signed or unsigned</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">0 to 65535 unsigned, -32768 to +32767 signed; stored in 2 bytes</p></td> </tr> <tr> +<td class="tableblock halign-left valign-top"></td> <td class="tableblock halign-left valign-top"><p class="tableblock">INTEGER</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">Binary integer; signed or unsigned</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">0 to 4294967295 unsigned, -2147483648 to +2147483647 signed; stored in 4 bytes</p></td> </tr> <tr> +<td class="tableblock halign-left valign-top"></td> <td class="tableblock halign-left valign-top"><p class="tableblock">LARGEINT</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">Binary integer; signed only</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">-2<sup>63</sup> to +(2<sup>63</sup>)-1; stored in 8 bytes</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">-2<strong>63 to +(2</strong>63)-1; stored in 8 bytes</p></td> </tr> <tr> <td class="tableblock halign-left valign-top"><p class="tableblock">Numeric (extended numeric precision)</p></td> @@ -19860,20 +19807,22 @@ depending on precision</p></td> length of 8 bytes.</p></td> </tr> <tr> -<td class="tableblock halign-left valign-top" rowspan="3"><p class="tableblock">Floating point number</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Floating point number</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">FLOAT[(<em>precision</em>)]</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">Floating point number; precision designates from 1 through 52 bits of precision</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">+/- 2.2250738585072014e-308 through +/-1.7976931348623157e+308; stored in 8 bytes</p></td> </tr> <tr> +<td class="tableblock halign-left valign-top"></td> <td class="tableblock halign-left valign-top"><p class="tableblock">REAL</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">Floating point number (32 bits)</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">+/- 1.17549435e-38 through +/ 3.40282347e+38; stored in 4 bytes</p></td> </tr> <tr> +<td class="tableblock halign-left valign-top"></td> <td class="tableblock halign-left valign-top"><p class="tableblock">DOUBLE PRECISION</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">Floating-point numbers (64 bits) with 1 through 52 bits of precision (52 bits of binary precision and 1 bits of exponent)</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">+/- 2.2250738585072014e-308 through +/-1.7976931348623157e+308; stored in 8 bytes</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">+/- 2.2250738585072014e-308 through +/-1.7976931348623157e+308; stored in 8 byte</p></td> </tr> <tr> <td class="tableblock halign-left valign-top"><p class="tableblock">Decimal number</p></td> @@ -19881,6 +19830,63 @@ length of 8 bytes.</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">Decimal number with optional scale; stored as ASCII characters; signed or unsigned for 1 to 9 digits; signed required for 10 or more digits</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">1 to 18 digits. Byte length equals the number of digits. Sign is stored as the first bit of the leftmost byte.</p></td> </tr> +<tr> +<td class="tableblock halign-left valign-top"></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Date-Time</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Point in time, using the Gregorian calendar and a 24 hour clock system. The five supported designations are listed below.</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">YEAR 0001-9999<br> +MONTH 1-12<br> +DAY 1-31<br> +<br> +DAY constrained by MONTH and YEAR<br> +<br> +HOUR 0-23<br> +MINUTE 0-59<br> +SECOND 0-59<br> +FRACTION(n) 0-999999<br> +<br> +in which n is the number of significant digits, from 1 to 6 +(default is 6; minimum is 1; maximum is 6). Actual database storage is +incremental, as follows: +<br> +YEAR in 2 bytes<br> +MONTH in 1 byte<br> +DAY in 1 byte<br> +HOUR in 1 byte<br> +MINUTE in 1 +byte SECOND in 1 byte<br> +FRACTION in 4 bytes<br></p></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">DATE</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Date</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Format as YYYY-MM-DD; actual database storage size is 4 bytes</p></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">TIME</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Time of day, 24 hour clock, no time precision. Format as HH:MM:SS; actual database storage size is 3 bytes</p></td> +<td class="tableblock halign-left valign-top"></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">TIME (with time precision)</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Time of day, 24 hour clock, with time precision</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Format as HH:MM:SS.FFFFFF; actual database storage size is 7 bytes</p></td> +<td class="tableblock halign-left valign-top"></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">TIMESTAMP</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Point in time, no time precision</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Format as YYYY-MM-DD HH:MM:SS; actual database storage size is 7 bytes</p></td> +<td class="tableblock halign-left valign-top"></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">TIMESTAMP (with time precision) Point in time, with time precision</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Format as YYYY-MM-DD HH:MM:SS.FFFFFF; actual database storage size is 1 byte</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Interval</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">INTERVAL</p></td> +</tr> </tbody> </table> <div class="ulist"> @@ -19918,12 +19924,6 @@ The maximum is 16353 if the national character set was specified at installation <p>The maximum is 32703 if the national character set was specified at installation time to be ISO88591. The maximum is 16351 if the national character set was specified at installation time as UTF8.</p> </li> -<li> -<p>It defaults to 200000 characters and can be declared explicitly by using the TRAF_MAX_CHARACTER_COL_LENGTH CQD.</p> -</li> -<li> -<p>It defaults to 200000 bytes and can be declared explicitly by using the TRAF_MAX_CHARACTER_COL_LENGTH CQD.</p> -</li> </ol> </div> </li> @@ -20208,35 +20208,14 @@ numeric, datetime, or interval data.</p> <p><code><em>character-type</em></code> is:</p> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">CHAR[ACTER] [(length [unit])] [char-set] [UPSHIFT] [[NOT]CASESPECIFIC] -| CHAR[ACTER] VARYING(length [unit]) [char-set] [UPSHIFT] [[NOT]CASESPECIFIC] -| VARCHAR(length [unit]) [CHARACTERS] [char-set] [UPSHIFT] [[NOT]CASESPECIFIC] -| NCHAR [(length)] [UPSHIFT] [[NOT]CASESPECIFIC] -| NCHAR VARYING (length) [UPSHIFT] [[NOT]CASESPECIFIC] -| NATIONAL CHAR[ACTER] [(length)] [UPSHIFT] [[NOT]CASESPECIFIC] -| NATIONAL CHAR[ACTER] VARYING (length) [UPSHIFT] [[NOT]CASESPECIFIC]</code></pre> -</div> -</div> -<div class="paragraph"> -<p>CHAR, NCHAR, and NATIONAL CHAR are fixed-length character types. CHAR -VARYING, VARCHAR, NCHAR VARYING and NATIONAL CHAR VARYING are -varying-length character types.</p> +<pre class="CodeRay highlight"><code data-lang="text">CHAR[ACTER] [(_length_ [CHARACTERS])] [_char-set_] [UPSHIFT] [[NOT]CASESPECIFIC] +| CHAR[ACTER] VARYING(_length_) [CHARACTERS][_char-set_] [UPSHIFT] [[NOT]CASESPECIFIC] +| VARCHAR(_length_) [CHARACTERS] [_char-set_] [UPSHIFT] [[NOT]CASESPECIFIC] +| NCHAR [(_length_)] [CHARACTERS] [UPSHIFT] [[NOT]CASESPECIFIC] +| NCHAR VARYING (_length_) [CHARACTERS] [UPSHIFT] [[NOT]CASESPECIFIC] +| NATIONAL CHAR[ACTER] [(_length_)] [CHARACTERS] [UPSHIFT] [[NOT]CASESPECIFIC] +| NATIONAL CHAR[ACTER] VARYING (_length_) [CHARACTERS] [UPSHIFT] [[NOT]CASESPECIFIC]</code></pre> </div> -</li> -<li> -<p><code><em>length</em></code></p> -<div class="paragraph"> -<p>is a positive integer that specifies the number of characters (or bytes, see below) allowed in -the column. You must specify a value for <em>length</em>.</p> -</div> -</li> -<li> -<p><code><em>unit</em></code></p> -<div class="paragraph"> -<p>is an optional unit of either CHAR[ACTER[S]] or BYTE[S]. The default is CHAR[ACTER[S]]. This unit is meaningful only for UTF8 characters. -A UTF8 character is one to four bytes in length, therefore the storage length of a CHAR column that can hold <em>n</em> UTF8 characters is 4*<em>n</em> bytes. -The same applies to the maximum length of a VARCHAR column. -Specifying the length of UTF8 columns in bytes can lead to significant savings in space and resources.</p> </div> </li> <li> @@ -20246,39 +20225,37 @@ Specifying the length of UTF8 columns in bytes can lead to significant savings i <pre class="CodeRay highlight"><code data-lang="text">CHARACTER SET char-set-name</code></pre> </div> </div> -<div class="ulist"> -<ul> -<li> -<p><code><em>char-set-name</em></code></p> +</li> +</ul> +</div> <div class="paragraph"> -<p>is the character set name, which can be ISO88591, UTF8 or UCS2.</p> +<p>CHAR, NCHAR, and NATIONAL CHAR are fixed-length character types. CHAR +VARYING, VARCHAR, NCHAR VARYING and NATIONAL CHAR VARYING are +varying-length character types.</p> </div> <div class="ulist"> <ul> <li> -<p>ISO88591 (ISO 8859-1) is a single-byte character set for US ASCII and Western European language characters.</p> -</li> -<li> -<p>UTF8 (UTF-8) is a variable-length (1 to 4 bytes) encoding of Unicode characters including those in supplementary planes. It is compatible with the US-ASCII character set.</p> -</li> -<li> -<p>UCS2 (UCS-2) is a fixed-length, 2 byte encoding of Unicode characters of the Basic Multilingual Plane (BMP). -Note that, while not strictly part of UCS2, Trafodion also tolerates UTF-16 surrogate pairs in UCS2 columns, but such surrogate pairs are interpreted as two separate characters.</p> -</li> -</ul> +<p><code><em>length</em></code></p> +<div class="paragraph"> +<p>is a positive integer that specifies the number of characters allowed in +the column. You must specify a value for <em>length</em>.</p> </div> </li> -</ul> +<li> +<p><code><em>char-set-name</em></code></p> +<div class="paragraph"> +<p>is the character set name, which can be ISO88591 or UTF8.</p> </div> </li> <li> -<p><code>CHAR[ACTER] [(<em>length</em> [<em>unit</em>])] [<em>char-set</em>] [UPSHIFT] [[NOT]CASESPECIFIC]</code></p> +<p><code>CHAR[ACTER] [(<em>length</em> [CHARACTERS])] [<em>char-set</em>] [UPSHIFT] [[NOT]CASESPECIFIC]</code></p> <div class="paragraph"> <p>specifies a column with fixed-length character data.</p> </div> </li> <li> -<p><code>CHAR[ACTER] VARYING (<em>length</em> [<em>unit</em>]) [<em>char-set</em>] [UPSHIFT] [[NOT]CASESPECIFIC]</code></p> +<p><code>CHAR[ACTER] VARYING (<em>length</em>) [CHARACTERS] [<em>char-set</em>] [UPSHIFT] [[NOT]CASESPECIFIC]</code></p> <div class="paragraph"> <p>specifies a column with varying-length character data. VARYING specifies that the number of characters stored in the column can be fewer than the @@ -20293,7 +20270,7 @@ an equivalent column that is not VARYING.</p> </div> </li> <li> -<p><code>VARCHAR (<em>length</em> [<em>unit</em>]) [<em>char-set</em>] [UPSHIFT] [[NOT]CASESPECIFIC]</code></p> +<p><code>VARCHAR (<em>length</em>) [<em>char-set</em>] [UPSHIFT] [[NOT]CASESPECIFIC]</code></p> <div class="paragraph"> <p>specifies a column with varying-length character data. VARCHAR is equivalent to data type CHAR[ACTER] VARYING.</p> @@ -20302,13 +20279,13 @@ equivalent to data type CHAR[ACTER] VARYING.</p> <li> <p><code>NCHAR [(<em>length</em>)] [UPSHIFT] [[NOT]CASESPECIFIC], NATIONAL CHAR[ACTER] [(<em>length</em>)] [UPSHIFT] [[NOT]CASESPECIFIC]</code></p> <div class="paragraph"> -<p>specifies a column with data in the predefined national character set (UCS2).</p> +<p>specifies a column with data in the predefined national character set.</p> </div> </li> <li> <p><code>NCHAR VARYING [(<em>length</em>)] [UPSHIFT] [[NOT]CASESPECIFIC], NATIONAL CHAR[ACTER] VARYING (<em>length</em>) [UPSHIFT] [[NOT]CASESPECIFIC]</code></p> <div class="paragraph"> -<p>specifies a column with varying-length data in the predefined national character set (UCS2).</p> +<p>specifies a column with varying-length data in the predefined national character set.</p> </div> </li> </ul> @@ -20399,8 +20376,8 @@ SQL extension.</p> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text"> DATE -| TIME [(time-precision)] -| TIMESTAMP [(timestamp-precision)]</code></pre> +| TIME [(_time-precision_)] +| TIMESTAMP [(_timestamp-precision_)]</code></pre> </div> </div> </li> @@ -20513,7 +20490,7 @@ seconds, and fractions of a second).</p> </div> </li> <li> -<p><code><em>end-field</em> is:</code></p> +<p>`<em>end-field</em> is:</p> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">YEAR | MONTH | DAY | HOUR | MINUTE | SECOND [(_fractional-precision_)]</code></pre> @@ -20687,12 +20664,11 @@ datetime, or interval data types.</p> <p><code><em>exact-numeric-type</em></code> is:</p> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text"> NUMERIC [(precision [,scale])] [SIGNED|UNSIGNED] -| TINYINT [SIGNED|UNSIGNED] +<pre class="CodeRay highlight"><code data-lang="text"> NUMERIC [(_precision_ [,_scale_])] [SIGNED|UNSIGNED] | SMALLINT [SIGNED|UNSIGNED] | INT[EGER] [SIGNED|UNSIGNED] | LARGEINT -| DEC[IMAL] [(precision [,scale])] [SIGNED|UNSIGNED]</code></pre> +| DEC[IMAL] [(_precision_ [,_scale_])] [SIGNED|UNSIGNED]</code></pre> </div> </div> </li> @@ -20700,7 +20676,7 @@ datetime, or interval data types.</p> <p><code><em>approximate-numeric-type</em></code> is:</p> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text"> FLOAT [(precision)] +<pre class="CodeRay highlight"><code data-lang="text"> FLOAT [(_precision_)] | REAL | DOUBLE PRECISION</code></pre> </div> @@ -20737,14 +20713,6 @@ number of digits to the right of the decimal point.</p> </div> </li> <li> -<p><code>TINYINT [SIGNED|UNSIGNED]</code></p> -<div class="paragraph"> -<p>specifies an exact numeric columnâa one-byte binary integer, SIGNED or -UNSIGNED. The column stores integers in the range unsigned 0 to 255 or signed --128 to +127. The default is SIGNED.</p> -</div> -</li> -<li> <p><code>SMALLINT [SIGNED|UNSIGNED]</code></p> <div class="paragraph"> <p>specifies an exact numeric columnâa two-byte binary integer, SIGNED or @@ -28252,7 +28220,8 @@ corresponding second of the minute.</p></td> </tr> <tr> <td class="tableblock halign-left valign-top"><p class="tableblock"><a href="#timestampdiff_function">TIMESTAMPDIFF Function</a></p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">Returns the integer value for the number of <em>interval-ind_units of time between _startdate</em> and <em>enddate</em>.</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Returns the integer value for the number of <em>interval-ind</em> +units of time between <em>startdate</em> and <em>enddate</em>.</p></td> </tr> <tr> <td class="tableblock halign-left valign-top"><p class="tableblock"><a href="#to_char_function">TO_CHAR Function</a></p></td> @@ -44496,7 +44465,7 @@ or 256 bytes of UTF8 text, whichever is less.</p></td> <div id="footer"> <div id="footer-text"> Version 2.2.0<br> -Last updated 2017-03-07 20:31:35 UTC +Last updated 2016-11-03 22:36:05 UTC </div> </div> <script> http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.2.0/sql_reference/integration.html ---------------------------------------------------------------------- diff --git a/docs/2.2.0/sql_reference/integration.html b/docs/2.2.0/sql_reference/integration.html index bad6db0..8c75e30 100644 --- a/docs/2.2.0/sql_reference/integration.html +++ b/docs/2.2.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 Jun 23, 2017 --> +<!-- Generated by Apache Maven Doxia at May 3, 2017 --> <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="20170623" /> + <meta name="Date-Revision-yyyymmdd" content="20170503" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2017-06-23</span> + <span id="publishDate">Last Published: 2017-05-03</span> | <span id="projectVersion">Version: 2.2.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/c9ae8c27/docs/2.2.0/sql_reference/issue-tracking.html ---------------------------------------------------------------------- diff --git a/docs/2.2.0/sql_reference/issue-tracking.html b/docs/2.2.0/sql_reference/issue-tracking.html index 78bd59a..03d6b6d 100644 --- a/docs/2.2.0/sql_reference/issue-tracking.html +++ b/docs/2.2.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 Jun 23, 2017 --> +<!-- Generated by Apache Maven Doxia at May 3, 2017 --> <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="20170623" /> + <meta name="Date-Revision-yyyymmdd" content="20170503" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2017-06-23</span> + <span id="publishDate">Last Published: 2017-05-03</span> | <span id="projectVersion">Version: 2.2.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/c9ae8c27/docs/2.2.0/sql_reference/license.html ---------------------------------------------------------------------- diff --git a/docs/2.2.0/sql_reference/license.html b/docs/2.2.0/sql_reference/license.html index e44a5aa..b7c2728 100644 --- a/docs/2.2.0/sql_reference/license.html +++ b/docs/2.2.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 Jun 23, 2017 --> +<!-- Generated by Apache Maven Doxia at May 3, 2017 --> <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="20170623" /> + <meta name="Date-Revision-yyyymmdd" content="20170503" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2017-06-23</span> + <span id="publishDate">Last Published: 2017-05-03</span> | <span id="projectVersion">Version: 2.2.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/c9ae8c27/docs/2.2.0/sql_reference/mail-lists.html ---------------------------------------------------------------------- diff --git a/docs/2.2.0/sql_reference/mail-lists.html b/docs/2.2.0/sql_reference/mail-lists.html index 2b2bf7f..d0b5a7f 100644 --- a/docs/2.2.0/sql_reference/mail-lists.html +++ b/docs/2.2.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 Jun 23, 2017 --> +<!-- Generated by Apache Maven Doxia at May 3, 2017 --> <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="20170623" /> + <meta name="Date-Revision-yyyymmdd" content="20170503" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2017-06-23</span> + <span id="publishDate">Last Published: 2017-05-03</span> | <span id="projectVersion">Version: 2.2.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/c9ae8c27/docs/2.2.0/sql_reference/project-info.html ---------------------------------------------------------------------- diff --git a/docs/2.2.0/sql_reference/project-info.html b/docs/2.2.0/sql_reference/project-info.html index 6f49a89..aeb9290 100644 --- a/docs/2.2.0/sql_reference/project-info.html +++ b/docs/2.2.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 Jun 23, 2017 --> +<!-- Generated by Apache Maven Doxia at May 3, 2017 --> <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="20170623" /> + <meta name="Date-Revision-yyyymmdd" content="20170503" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2017-06-23</span> + <span id="publishDate">Last Published: 2017-05-03</span> | <span id="projectVersion">Version: 2.2.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/c9ae8c27/docs/2.2.0/sql_reference/project-summary.html ---------------------------------------------------------------------- diff --git a/docs/2.2.0/sql_reference/project-summary.html b/docs/2.2.0/sql_reference/project-summary.html index 7046163..a8eb2aa 100644 --- a/docs/2.2.0/sql_reference/project-summary.html +++ b/docs/2.2.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 Jun 23, 2017 --> +<!-- Generated by Apache Maven Doxia at May 3, 2017 --> <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="20170623" /> + <meta name="Date-Revision-yyyymmdd" content="20170503" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2017-06-23</span> + <span id="publishDate">Last Published: 2017-05-03</span> | <span id="projectVersion">Version: 2.2.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/c9ae8c27/docs/2.2.0/sql_reference/source-repository.html ---------------------------------------------------------------------- diff --git a/docs/2.2.0/sql_reference/source-repository.html b/docs/2.2.0/sql_reference/source-repository.html index ed2edfa..211382e 100644 --- a/docs/2.2.0/sql_reference/source-repository.html +++ b/docs/2.2.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 Jun 23, 2017 --> +<!-- Generated by Apache Maven Doxia at May 3, 2017 --> <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="20170623" /> + <meta name="Date-Revision-yyyymmdd" content="20170503" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2017-06-23</span> + <span id="publishDate">Last Published: 2017-05-03</span> | <span id="projectVersion">Version: 2.2.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/c9ae8c27/docs/2.2.0/sql_reference/team-list.html ---------------------------------------------------------------------- diff --git a/docs/2.2.0/sql_reference/team-list.html b/docs/2.2.0/sql_reference/team-list.html index f932e2b..f65e0ec 100644 --- a/docs/2.2.0/sql_reference/team-list.html +++ b/docs/2.2.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 Jun 23, 2017 --> +<!-- Generated by Apache Maven Doxia at May 3, 2017 --> <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="20170623" /> + <meta name="Date-Revision-yyyymmdd" content="20170503" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2017-06-23</span> + <span id="publishDate">Last Published: 2017-05-03</span> | <span id="projectVersion">Version: 2.2.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/c9ae8c27/docs/2.3.0/client_install/Trafodion_Client_Installation_Guide.pdf ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/Trafodion_Client_Installation_Guide.pdf b/docs/2.3.0/client_install/Trafodion_Client_Installation_Guide.pdf new file mode 100644 index 0000000..290e739 Binary files /dev/null and b/docs/2.3.0/client_install/Trafodion_Client_Installation_Guide.pdf differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/css/maven-base.css ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/css/maven-base.css b/docs/2.3.0/client_install/css/maven-base.css new file mode 100644 index 0000000..584ba23 --- /dev/null +++ b/docs/2.3.0/client_install/css/maven-base.css @@ -0,0 +1,151 @@ +body { + margin: 0px; + padding: 0px; +} +img { + border:none; +} +table { + padding:0px; + width: 100%; + margin-left: -2px; + margin-right: -2px; +} +acronym { + cursor: help; + border-bottom: 1px dotted #feb; +} +table.bodyTable th, table.bodyTable td { + padding: 2px 4px 2px 4px; + vertical-align: top; +} +div.clear{ + clear:both; + visibility: hidden; +} +div.clear hr{ + display: none; +} +#bannerLeft, #bannerRight { + font-size: xx-large; + font-weight: bold; +} +#bannerLeft img, #bannerRight img { + margin: 0px; +} +.xleft, #bannerLeft img { + float:left; +} +.xright, #bannerRight { + float:right; +} +#banner { + padding: 0px; +} +#banner img { + border: none; +} +#breadcrumbs { + padding: 3px 10px 3px 10px; +} +#leftColumn { + width: 170px; + float:left; + overflow: auto; +} +#bodyColumn { + margin-right: 1.5em; + margin-left: 197px; +} +#legend { + padding: 8px 0 8px 0; +} +#navcolumn { + padding: 8px 4px 0 8px; +} +#navcolumn h5 { + margin: 0; + padding: 0; + font-size: small; +} +#navcolumn ul { + margin: 0; + padding: 0; + font-size: small; +} +#navcolumn li { + list-style-type: none; + background-image: none; + background-repeat: no-repeat; + background-position: 0 0.4em; + padding-left: 16px; + list-style-position: outside; + line-height: 1.2em; + font-size: smaller; +} +#navcolumn li.expanded { + background-image: url(../images/expanded.gif); +} +#navcolumn li.collapsed { + background-image: url(../images/collapsed.gif); +} +#poweredBy { + text-align: center; +} +#navcolumn img { + margin-top: 10px; + margin-bottom: 3px; +} +#poweredBy img { + display:block; + margin: 20px 0 20px 17px; +} +#search img { + margin: 0px; + display: block; +} +#search #q, #search #btnG { + border: 1px solid #999; + margin-bottom:10px; +} +#search form { + margin: 0px; +} +#lastPublished { + font-size: x-small; +} +.navSection { + margin-bottom: 2px; + padding: 8px; +} +.navSectionHead { + font-weight: bold; + font-size: x-small; +} +.section { + padding: 4px; +} +#footer { + padding: 3px 10px 3px 10px; + font-size: x-small; +} +#breadcrumbs { + font-size: x-small; + margin: 0pt; +} +.source { + padding: 12px; + margin: 1em 7px 1em 7px; +} +.source pre { + margin: 0px; + padding: 0px; +} +#navcolumn img.imageLink, .imageLink { + padding-left: 0px; + padding-bottom: 0px; + padding-top: 0px; + padding-right: 2px; + border: 0px; + margin: 0px; +} http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/css/maven-theme.css ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/css/maven-theme.css b/docs/2.3.0/client_install/css/maven-theme.css new file mode 100644 index 0000000..c982168 --- /dev/null +++ b/docs/2.3.0/client_install/css/maven-theme.css @@ -0,0 +1,141 @@ +body { + padding: 0px 0px 10px 0px; +} +body, td, select, input, li{ + font-family: Verdana, Helvetica, Arial, sans-serif; + font-size: 13px; +} +code{ + font-family: Courier, monospace; + font-size: 13px; +} +a { + text-decoration: none; +} +a:link { + color:#36a; +} +a:visited { + color:#47a; +} +a:active, a:hover { + color:#69c; +} +#legend li.externalLink { + background: url(../images/external.png) left top no-repeat; + padding-left: 18px; +} +a.externalLink, a.externalLink:link, a.externalLink:visited, a.externalLink:active, a.externalLink:hover { + background: url(../images/external.png) right center no-repeat; + padding-right: 18px; +} +#legend li.newWindow { + background: url(../images/newwindow.png) left top no-repeat; + padding-left: 18px; +} +a.newWindow, a.newWindow:link, a.newWindow:visited, a.newWindow:active, a.newWindow:hover { + background: url(../images/newwindow.png) right center no-repeat; + padding-right: 18px; +} +h2 { + padding: 4px 4px 4px 6px; + border: 1px solid #999; + color: #900; + background-color: #ddd; + font-weight:900; + font-size: x-large; +} +h3 { + padding: 4px 4px 4px 6px; + border: 1px solid #aaa; + color: #900; + background-color: #eee; + font-weight: normal; + font-size: large; +} +h4 { + padding: 4px 4px 4px 6px; + border: 1px solid #bbb; + color: #900; + background-color: #fff; + font-weight: normal; + font-size: large; +} +h5 { + padding: 4px 4px 4px 6px; + color: #900; + font-size: normal; +} +p { + line-height: 1.3em; + font-size: small; +} +#breadcrumbs { + border-top: 1px solid #aaa; + border-bottom: 1px solid #aaa; + background-color: #ccc; +} +#leftColumn { + margin: 10px 0 0 5px; + border: 1px solid #999; + background-color: #eee; +} +#navcolumn h5 { + font-size: smaller; + border-bottom: 1px solid #aaaaaa; + padding-top: 2px; + color: #000; +} + +table.bodyTable th { + color: white; + background-color: #bbb; + text-align: left; + font-weight: bold; +} + +table.bodyTable th, table.bodyTable td { + font-size: 1em; +} + +table.bodyTable tr.a { + background-color: #ddd; +} + +table.bodyTable tr.b { + background-color: #eee; +} + +.source { + border: 1px solid #999; +} +dl { + padding: 4px 4px 4px 6px; + border: 1px solid #aaa; + background-color: #ffc; +} +dt { + color: #900; +} +#organizationLogo img, #projectLogo img, #projectLogo span{ + margin: 8px; +} +#banner { + border-bottom: 1px solid #fff; +} +.errormark, .warningmark, .donemark, .infomark { + background: url(../images/icon_error_sml.gif) no-repeat; +} + +.warningmark { + background-image: url(../images/icon_warning_sml.gif); +} + +.donemark { + background-image: url(../images/icon_success_sml.gif); +} + +.infomark { + background-image: url(../images/icon_info_sml.gif); +} + http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/css/print.css ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/css/print.css b/docs/2.3.0/client_install/css/print.css new file mode 100644 index 0000000..26ad7f0 --- /dev/null +++ b/docs/2.3.0/client_install/css/print.css @@ -0,0 +1,7 @@ +#banner, #footer, #leftcol, #breadcrumbs, .docs #toc, .docs .courtesylinks, #leftColumn, #navColumn { + display: none !important; +} +#bodyColumn, body.docs div.docs { + margin: 0 !important; + border: none !important +} http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/css/site.css ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/css/site.css b/docs/2.3.0/client_install/css/site.css new file mode 100644 index 0000000..055e7e2 --- /dev/null +++ b/docs/2.3.0/client_install/css/site.css @@ -0,0 +1 @@ +/* You can override this file with your own styles */ \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/dependencies.html ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/dependencies.html b/docs/2.3.0/client_install/dependencies.html new file mode 100644 index 0000000..1e494f6 --- /dev/null +++ b/docs/2.3.0/client_install/dependencies.html @@ -0,0 +1,127 @@ +<!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 Sep 27, 2017 --> +<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" /> + <title>Project Dependencies</title> + <style type="text/css" media="all"> + @import url("./css/maven-base.css"); + @import url("./css/maven-theme.css"); + @import url("./css/site.css"); + </style> + <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" /> + <meta name="Date-Revision-yyyymmdd" content="20170927" /> + <meta http-equiv="Content-Language" content="en" /> + + </head> + <body class="composite"> + <div id="banner"> + <div id="bannerLeft"> + Trafodion Client Installation Guide + </div> + <div class="clear"> + <hr/> + </div> + </div> + <div id="breadcrumbs"> + + + <div class="xleft"> + <span id="publishDate">Last Published: 2017-09-27</span> + | <span id="projectVersion">Version: 2.3.0</span> + </div> + <div class="xright"> <a href="./" title="Trafodion Client Installation Guide">Trafodion Client Installation Guide</a> + + + </div> + <div class="clear"> + <hr/> + </div> + </div> + <div id="leftColumn"> + <div id="navcolumn"> + + + <h5>Parent Project</h5> + <ul> + <li class="none"> + <a href="index.html" title="Apache Trafodion">Apache Trafodion</a> + </li> + </ul> + <h5>Project Documentation</h5> + <ul> + <li class="expanded"> + <a href="project-info.html" title="Project Information">Project Information</a> + <ul> + <li class="none"> + <a href="team-list.html" title="Project Team">Project Team</a> + </li> + <li class="none"> + <a href="mail-lists.html" title="Mailing Lists">Mailing Lists</a> + </li> + <li class="none"> + <a href="issue-tracking.html" title="Issue Tracking">Issue Tracking</a> + </li> + <li class="none"> + <a href="license.html" title="Project License">Project License</a> + </li> + <li class="none"> + <a href="project-summary.html" title="Project Summary">Project Summary</a> + </li> + <li class="none"> + <a href="source-repository.html" title="Source Repository">Source Repository</a> + </li> + <li class="none"> + <a href="integration.html" title="Continuous Integration">Continuous Integration</a> + </li> + <li class="none"> + <strong>Dependencies</strong> + </li> + </ul> + </li> + </ul> + <a href="http://maven.apache.org/"; title="Built by Maven" class="poweredBy"> + <img class="poweredBy" alt="Built by Maven" src="./images/logos/maven-feather.png" /> + </a> + + + </div> + </div> + <div id="bodyColumn"> + <div id="contentBox"> + <a name="Project_Dependencies"></a><div class="section"><h2>Project Dependencies<a name="Project_Dependencies"></a></h2><a name="Project_Dependencies_compile"></a><div class="section"><h3>compile<a name="compile"></a></h3><p>The following is a list of compile dependencies for this project. These dependencies are required to compile and run the application:</p><table border="0" class="bodyTable"><tr class="a"><th>GroupId</th><th>ArtifactId</th><th>Version</th><th>Type</th><th>License</th></tr><tr class="b"><td>org.asciidoctor</td><td><a class="externalLink" href="https://github.com/asciidoctor/asciidoctorj";>asciidoctorj</a></td><td>1.5.4</td><td>jar</td><td><a class="externalLink" href="http://www.apache.org/licenses/LICENSE-2.0.txt";>The Apache Software License, Version 2.0</a></td></tr><tr class="a"><td>org.jruby</td><td><a class="externalLink" href="https://github.com/jruby/jruby/jruby-artifacts/jruby-complete";>jruby-complete</a></td><td>9.0.4.0</td><td>jar</td><td><a class ="externalLink" href="http://www.gnu.org/licenses/gpl-3.0-standalone.html";>GPL 3</a>-<a class="externalLink" href="http://www.gnu.org/licenses/lgpl-3.0-standalone.html";>LGPL 3</a>-<a class="externalLink" href="http://www.eclipse.org/legal/epl-v10.html";>EPL</a></td></tr></table></div><a name="Project_Dependencies_provided"></a><div class="section"><h3>provided<a name="provided"></a></h3><p>The following is a list of provided dependencies for this project. These dependencies are required to compile the application, but should be provided by default when using the library:</p><table border="0" class="bodyTable"><tr class="a"><th>GroupId</th><th>ArtifactId</th><th>Version</th><th>Type</th><th>License</th></tr><tr class="b"><td>rubygems</td><td><a class="externalLink" href="http://prawn.majesticseacreature.com";>prawn</a></td><td>2.0.2</td><td>gem</td><td>-</td></tr></table></div></div><a name="Project_Transitive_Dependencies"></a><div class="section"><h2>Project Transitive Dependencies<a name="Project_Transitive_Dependencies"></a></h2><p>The following is a list of transitive dependencies for this project. Transitive dependencies are the dependencies of the project dependencies.</p><a name="Project_Transitive_Dependencies_runtime"></a><div class="section"><h3>runtime<a name="runtime"></a></h3><p>The following is a list of runtime dependencies for this project. These dependencies are required to run the application:</p><table border="0" class="bodyTable"><tr class="a"><th>GroupId</th><th>ArtifactId</th><th>Version</th><th>Type</th><th>License</th></tr><tr class="b"><td>com.beust</td><td><a class="externalLink" href="http://beust.com/jcommander";>jcommander</a></td><td>1.35</td><td>jar</td><td><a class="externalLink" href="http://www.apache.org/licenses/LICENSE-2.0.txt";>The Apache Software License, Version 2.0</a></td></tr></table></div><a name="Project_Transitive_Dependencies_provided"></a><div class="section"><h3>provided<a name="provided"></a></h3><p>The following i s a list of provided dependencies for this project. These dependencies are required to compile the application, but should be provided by default when using the library:</p><table border="0" class="bodyTable"><tr class="a"><th>GroupId</th><th>ArtifactId</th><th>Version</th><th>Type</th><th>License</th></tr><tr class="b"><td>rubygems</td><td><a class="externalLink" href="http://prawn.majesticseacreature.com";>pdf-core</a></td><td>0.6.1</td><td>gem</td><td>-</td></tr><tr class="a"><td>rubygems</td><td>ttfunk</td><td>1.4.0</td><td>gem</td><td>-</td></tr></table></div></div><a name="Project_Dependency_Graph"></a><div class="section"><h2>Project Dependency Graph<a name="Project_Dependency_Graph"></a></h2><script language="javascript" type="text/javascript"> + function toggleDependencyDetail( divId, imgId ) + { + var div = document.getElementById( divId ); + var img = document.getElementById( imgId ); + if( div.style.display == '' ) + { + div.style.display = 'none'; + img.src='./images/icon_info_sml.gif'; + } + else + { + div.style.display = ''; + img.src='./images/close.gif'; + } + } +</script> +<a name="Dependency_Tree"></a><div class="section"><h3>Dependency Tree<a name="Dependency_Tree"></a></h3><ul><li>org.apache.trafodion:client-install-guide:pom:2.3.0 <img id="_img1" src="./images/icon_info_sml.gif" alt="Information" onclick="toggleDependencyDetail( '_dep0', '_img1' );" style="cursor: pointer;vertical-align:text-bottom;"></img><div id="_dep0" style="display:none"><table border="0" class="bodyTable"><tr class="a"><th>Trafodion Client Installation Guide</th></tr><tr class="b"><td><p><b>Description: </b>This guide describes how to install different Trafodion client applications.</p><p><b>URL: </b><a class="externalLink" href="http://trafodion.incubator.apache.org";>http://trafodion.incubator.apache.org</a></p><p><b>Project License: </b><a class="externalLink" href="http://www.apache.org/licenses/LICENSE-2.0.txt";>The Apache Software License, Version 2.0</a></p></td></tr></table></div><ul><li>rubygems:prawn:gem:2.0.2 (provided) <img id="_img3" src="./images/icon_info_sml.gi f" alt="Information" onclick="toggleDependencyDetail( '_dep2', '_img3' );" style="cursor: pointer;vertical-align:text-bottom;"></img><div id="_dep2" style="display:none"><table border="0" class="bodyTable"><tr class="a"><th>A fast and nimble PDF generator for Ruby</th></tr><tr class="b"><td><p><b>Description: </b>Prawn is a fast, tiny, and nimble PDF generator for Ruby</p><p><b>URL: </b><a class="externalLink" href="http://prawn.majesticseacreature.com";>http://prawn.majesticseacreature.com</a></p><p><b>Project License: </b>No license is defined for this project.</p></td></tr></table></div><ul><li>rubygems:ttfunk:gem:1.4.0 (provided) <img id="_img5" src="./images/icon_info_sml.gif" alt="Information" onclick="toggleDependencyDetail( '_dep4', '_img5' );" style="cursor: pointer;vertical-align:text-bottom;"></img><div id="_dep4" style="display:none"><table border="0" class="bodyTable"><tr class="a"><th>TrueType Font Metrics Parser</th></tr><tr class="b"><td><p><b>Description: </b>Font Me trics Parser for the Prawn PDF generator</p><p><b>Project License: </b>No license is defined for this project.</p></td></tr></table></div></li><li>rubygems:pdf-core:gem:0.6.1 (provided) <img id="_img7" src="./images/icon_info_sml.gif" alt="Information" onclick="toggleDependencyDetail( '_dep6', '_img7' );" style="cursor: pointer;vertical-align:text-bottom;"></img><div id="_dep6" style="display:none"><table border="0" class="bodyTable"><tr class="a"><th>PDF::Core is used by Prawn to render PDF documents</th></tr><tr class="b"><td><p><b>Description: </b>PDF::Core is used by Prawn to render PDF documents</p><p><b>URL: </b><a class="externalLink" href="http://prawn.majesticseacreature.com";>http://prawn.majesticseacreature.com</a></p><p><b>Project License: </b>No license is defined for this project.</p></td></tr></table></div></li></ul></li><li>org.jruby:jruby-complete:jar:9.0.4.0 (compile) <img id="_img9" src="./images/icon_info_sml.gif" alt="Information" onclick="toggleDependencyDetail( '_dep8', '_img9' );" style="cursor: pointer;vertical-align:text-bottom;"></img><div id="_dep8" style="display:none"><table border="0" class="bodyTable"><tr class="a"><th>JRuby Complete</th></tr><tr class="b"><td><p><b>Description: </b>JRuby is the effort to recreate the Ruby (http://www.ruby-lang.org) interpreter in Java.</p><p><b>URL: </b><a class="externalLink" href="https://github.com/jruby/jruby/jruby-artifacts/jruby-complete";>https://github.com/jruby/jruby/jruby-artifacts/jruby-complete</a></p><p><b>Project License: </b><a class="externalLink" href="http://www.gnu.org/licenses/gpl-3.0-standalone.html";>GPL 3</a>, <a class="externalLink" href="http://www.gnu.org/licenses/lgpl-3.0-standalone.html";>LGPL 3</a>, <a class="externalLink" href="http://www.eclipse.org/legal/epl-v10.html";>EPL</a></p></td></tr></table></div></li><li>org.asciidoctor:asciidoctorj:jar:1.5.4 (compile) <img id="_img11" src="./images/icon_info_sml.gif" alt="Information" onclick="toggleDependencyDetail( '_dep10' , '_img11' );" style="cursor: pointer;vertical-align:text-bottom;"></img><div id="_dep10" style="display:none"><table border="0" class="bodyTable"><tr class="a"><th>AsciidoctorJ</th></tr><tr class="b"><td><p><b>Description: </b>AsciidoctorJ provides Java bindings for the Asciidoctor RubyGem (asciidoctor) using JRuby.</p><p><b>URL: </b><a class="externalLink" href="https://github.com/asciidoctor/asciidoctorj";>https://github.com/asciidoctor/asciidoctorj</a></p><p><b>Project License: </b><a class="externalLink" href="http://www.apache.org/licenses/LICENSE-2.0.txt";>The Apache Software License, Version 2.0</a></p></td></tr></table></div><ul><li>com.beust:jcommander:jar:1.35 (runtime) <img id="_img13" src="./images/icon_info_sml.gif" alt="Information" onclick="toggleDependencyDetail( '_dep12', '_img13' );" style="cursor: pointer;vertical-align:text-bottom;"></img><div id="_dep12" style="display:none"><table border="0" class="bodyTable"><tr class="a"><th>JCommander</th></tr><tr class="b">< td><p><b>Description: </b>A Java framework to parse command line options with annotations.</p><p><b>URL: </b><a class="externalLink" href="http://beust.com/jcommander";>http://beust.com/jcommander</a></p><p><b>Project License: </b><a class="externalLink" href="http://www.apache.org/licenses/LICENSE-2.0.txt";>The Apache Software License, Version 2.0</a></p></td></tr></table></div></li></ul></li></ul></li></ul></div></div><a name="Licenses"></a><div class="section"><h2>Licenses<a name="Licenses"></a></h2><p><b>Unknown: </b>A fast and nimble PDF generator for Ruby, PDF::Core is used by Prawn to render PDF documents, TrueType Font Metrics Parser</p><p><b>GPL 3: </b>JRuby Complete</p><p><b>EPL: </b>JRuby Complete</p><p><b>The Apache Software License, Version 2.0: </b>AsciidoctorJ, JCommander, Trafodion Client Installation Guide</p><p><b>LGPL 3: </b>JRuby Complete</p></div><a name="Dependency_File_Details"></a><div class="section"><h2>Dependency File Details<a name="Dependency_File_Details" ></a></h2><table border="0" class="bodyTable"><tr >class="a"><th>Filename</th><th>Size</th><th>Entries</th><th>Classes</th><th>Packages</th><th>Java > Version</th><th title="Indicates whether these dependencies have been >compiled with debug information.">Debug Information</th></tr><tr >class="b"><td>jcommander-1.35.jar</td><td>60.55 >kB</td><td>64</td><td>50</td><td>5</td><td>1.5</td><td>Yes</td></tr><tr >class="a"><td>asciidoctorj-1.5.4.jar</td><td>707.33 >kB</td><td>480</td><td>78</td><td>10</td><td>1.6</td><td>Yes</td></tr><tr >class="b"><td>jruby-complete-9.0.4.0.jar</td><td>20.68 >MB</td><td>12122</td><td>8414</td><td>212</td><td>1.6</td><td>Yes</td></tr><tr > class="a"><td>pdf-core-0.6.1.gem</td><td>43.01 >kB</td><td>-</td><td>-</td><td>-</td><td>-</td><td>-</td></tr><tr >class="b"><td>prawn-2.0.2.gem</td><td>912.90 >kB</td><td>-</td><td>-</td><td>-</td><td>-</td><td>-</td></tr><tr >class="a"><td>ttfunk-1.4.0.gem</td><td>370.18 >kB</td><td>-</td><td>-</td><td>-</td><td>-</td><td>-</td></tr><t r class="b"><th>Total</th><th>Size</th><th>Entries</th><th>Classes</th><th>Packages</th><th>Java Version</th><th>Debug Information</th></tr><tr class="a"><td>6</td><td>22.78 MB</td><td>12666</td><td>8542</td><td>227</td><td>1.6</td><td>3</td></tr><tr class="b"><td>compile: 2</td><td>compile: 21.39 MB</td><td>compile: 12602</td><td>compile: 8492</td><td>compile: 222</td><td>-</td><td>compile: 2</td></tr><tr class="a"><td>runtime: 1</td><td>runtime: 60.55 kB</td><td>runtime: 64</td><td>runtime: 50</td><td>runtime: 5</td><td>-</td><td>runtime: 1</td></tr><tr class="b"><td>provided: 3</td><td>provided: 1.33 MB</td><td>-</td><td>-</td><td>-</td><td>-</td><td>-</td></tr></table></div> + </div> + </div> + <div class="clear"> + <hr/> + </div> + <div id="footer"> + <div class="xright"> + Copyright © 2015-2017 + <a href="http://www.apache.org";>Apache Software Foundation</a>. + All Rights Reserved. + + </div> + <div class="clear"> + <hr/> + </div> + </div> + </body> +</html> http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/Add_Alias_SQuirreL.jpg ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/Add_Alias_SQuirreL.jpg b/docs/2.3.0/client_install/images/Add_Alias_SQuirreL.jpg new file mode 100644 index 0000000..0e2d483 Binary files /dev/null and b/docs/2.3.0/client_install/images/Add_Alias_SQuirreL.jpg differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/Add_Driver_SQuirreL.jpg ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/Add_Driver_SQuirreL.jpg b/docs/2.3.0/client_install/images/Add_Driver_SQuirreL.jpg new file mode 100644 index 0000000..6dd3244 Binary files /dev/null and b/docs/2.3.0/client_install/images/Add_Driver_SQuirreL.jpg differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/Database_Connection_in_DbVisualizer.jpg ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/Database_Connection_in_DbVisualizer.jpg b/docs/2.3.0/client_install/images/Database_Connection_in_DbVisualizer.jpg new file mode 100644 index 0000000..4dc5931 Binary files /dev/null and b/docs/2.3.0/client_install/images/Database_Connection_in_DbVisualizer.jpg differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/DbVisualizer_Driver_Manager.jpg ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/DbVisualizer_Driver_Manager.jpg b/docs/2.3.0/client_install/images/DbVisualizer_Driver_Manager.jpg new file mode 100644 index 0000000..617bbad Binary files /dev/null and b/docs/2.3.0/client_install/images/DbVisualizer_Driver_Manager.jpg differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/Extracted_Files.jpg ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/Extracted_Files.jpg b/docs/2.3.0/client_install/images/Extracted_Files.jpg new file mode 100644 index 0000000..f905b30 Binary files /dev/null and b/docs/2.3.0/client_install/images/Extracted_Files.jpg differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/InstallComplete.jpg ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/InstallComplete.jpg b/docs/2.3.0/client_install/images/InstallComplete.jpg new file mode 100644 index 0000000..20d88c6 Binary files /dev/null and b/docs/2.3.0/client_install/images/InstallComplete.jpg differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/InstallerWizardPaths.jpg ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/InstallerWizardPaths.jpg b/docs/2.3.0/client_install/images/InstallerWizardPaths.jpg new file mode 100644 index 0000000..b13e61d Binary files /dev/null and b/docs/2.3.0/client_install/images/InstallerWizardPaths.jpg differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/InstallerWizardWelcome.jpg ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/InstallerWizardWelcome.jpg b/docs/2.3.0/client_install/images/InstallerWizardWelcome.jpg new file mode 100644 index 0000000..a87437e Binary files /dev/null and b/docs/2.3.0/client_install/images/InstallerWizardWelcome.jpg differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/JDBC_JAR_Path.jpg ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/JDBC_JAR_Path.jpg b/docs/2.3.0/client_install/images/JDBC_JAR_Path.jpg new file mode 100644 index 0000000..ebae592 Binary files /dev/null and b/docs/2.3.0/client_install/images/JDBC_JAR_Path.jpg differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/OptionalComponents.jpg ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/OptionalComponents.jpg b/docs/2.3.0/client_install/images/OptionalComponents.jpg new file mode 100644 index 0000000..b95dff2 Binary files /dev/null and b/docs/2.3.0/client_install/images/OptionalComponents.jpg differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/PerlJavaServerURL.jpg ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/PerlJavaServerURL.jpg b/docs/2.3.0/client_install/images/PerlJavaServerURL.jpg new file mode 100644 index 0000000..c78b55b Binary files /dev/null and b/docs/2.3.0/client_install/images/PerlJavaServerURL.jpg differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/Physical_Connection.jpg ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/Physical_Connection.jpg b/docs/2.3.0/client_install/images/Physical_Connection.jpg new file mode 100644 index 0000000..257c44b Binary files /dev/null and b/docs/2.3.0/client_install/images/Physical_Connection.jpg differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/Properties_for_Alias_SQuirreL.jpg ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/Properties_for_Alias_SQuirreL.jpg b/docs/2.3.0/client_install/images/Properties_for_Alias_SQuirreL.jpg new file mode 100644 index 0000000..51bc3e3 Binary files /dev/null and b/docs/2.3.0/client_install/images/Properties_for_Alias_SQuirreL.jpg differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/ProxySettings.jpg ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/ProxySettings.jpg b/docs/2.3.0/client_install/images/ProxySettings.jpg new file mode 100644 index 0000000..1d4596c Binary files /dev/null and b/docs/2.3.0/client_install/images/ProxySettings.jpg differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/SQuirrel_Add_Alias.jpg ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/SQuirrel_Add_Alias.jpg b/docs/2.3.0/client_install/images/SQuirrel_Add_Alias.jpg new file mode 100644 index 0000000..35fd141 Binary files /dev/null and b/docs/2.3.0/client_install/images/SQuirrel_Add_Alias.jpg differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/SQuirrel_Extra_Class_Path.jpg ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/SQuirrel_Extra_Class_Path.jpg b/docs/2.3.0/client_install/images/SQuirrel_Extra_Class_Path.jpg new file mode 100644 index 0000000..ccdbf27 Binary files /dev/null and b/docs/2.3.0/client_install/images/SQuirrel_Extra_Class_Path.jpg differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/SQuirrel_New_Driver.jpg ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/SQuirrel_New_Driver.jpg b/docs/2.3.0/client_install/images/SQuirrel_New_Driver.jpg new file mode 100644 index 0000000..a881bd8 Binary files /dev/null and b/docs/2.3.0/client_install/images/SQuirrel_New_Driver.jpg differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/TQW_control_options.jpg ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/TQW_control_options.jpg b/docs/2.3.0/client_install/images/TQW_control_options.jpg new file mode 100644 index 0000000..af6df88 Binary files /dev/null and b/docs/2.3.0/client_install/images/TQW_control_options.jpg differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/TQW_login.jpg ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/TQW_login.jpg b/docs/2.3.0/client_install/images/TQW_login.jpg new file mode 100644 index 0000000..0fa92da Binary files /dev/null and b/docs/2.3.0/client_install/images/TQW_login.jpg differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/TQW_logout.jpg ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/TQW_logout.jpg b/docs/2.3.0/client_install/images/TQW_logout.jpg new file mode 100644 index 0000000..b1f5c91 Binary files /dev/null and b/docs/2.3.0/client_install/images/TQW_logout.jpg differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/TQW_query_plan.jpg ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/TQW_query_plan.jpg b/docs/2.3.0/client_install/images/TQW_query_plan.jpg new file mode 100644 index 0000000..0a3efd4 Binary files /dev/null and b/docs/2.3.0/client_install/images/TQW_query_plan.jpg differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/TQW_session.jpg ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/TQW_session.jpg b/docs/2.3.0/client_install/images/TQW_session.jpg new file mode 100644 index 0000000..51c23eb Binary files /dev/null and b/docs/2.3.0/client_install/images/TQW_session.jpg differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/TQW_whiteboard.jpg ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/TQW_whiteboard.jpg b/docs/2.3.0/client_install/images/TQW_whiteboard.jpg new file mode 100644 index 0000000..f60efc3 Binary files /dev/null and b/docs/2.3.0/client_install/images/TQW_whiteboard.jpg differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/close.gif ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/close.gif b/docs/2.3.0/client_install/images/close.gif new file mode 100644 index 0000000..1c26bbc Binary files /dev/null and b/docs/2.3.0/client_install/images/close.gif differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/collapsed.gif ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/collapsed.gif b/docs/2.3.0/client_install/images/collapsed.gif new file mode 100644 index 0000000..6e71084 Binary files /dev/null and b/docs/2.3.0/client_install/images/collapsed.gif differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/expanded.gif ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/expanded.gif b/docs/2.3.0/client_install/images/expanded.gif new file mode 100644 index 0000000..0fef3d8 Binary files /dev/null and b/docs/2.3.0/client_install/images/expanded.gif differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/external.png ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/external.png b/docs/2.3.0/client_install/images/external.png new file mode 100644 index 0000000..3f999fc Binary files /dev/null and b/docs/2.3.0/client_install/images/external.png differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/icon_error_sml.gif ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/icon_error_sml.gif b/docs/2.3.0/client_install/images/icon_error_sml.gif new file mode 100644 index 0000000..61132ef Binary files /dev/null and b/docs/2.3.0/client_install/images/icon_error_sml.gif differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/icon_info_sml.gif ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/icon_info_sml.gif b/docs/2.3.0/client_install/images/icon_info_sml.gif new file mode 100644 index 0000000..c6cb9ad Binary files /dev/null and b/docs/2.3.0/client_install/images/icon_info_sml.gif differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/icon_success_sml.gif ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/icon_success_sml.gif b/docs/2.3.0/client_install/images/icon_success_sml.gif new file mode 100644 index 0000000..52e85a4 Binary files /dev/null and b/docs/2.3.0/client_install/images/icon_success_sml.gif differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/icon_warning_sml.gif ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/icon_warning_sml.gif b/docs/2.3.0/client_install/images/icon_warning_sml.gif new file mode 100644 index 0000000..873bbb5 Binary files /dev/null and b/docs/2.3.0/client_install/images/icon_warning_sml.gif differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/logos/build-by-maven-black.png ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/logos/build-by-maven-black.png b/docs/2.3.0/client_install/images/logos/build-by-maven-black.png new file mode 100644 index 0000000..919fd0f Binary files /dev/null and b/docs/2.3.0/client_install/images/logos/build-by-maven-black.png differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/logos/build-by-maven-white.png ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/logos/build-by-maven-white.png b/docs/2.3.0/client_install/images/logos/build-by-maven-white.png new file mode 100644 index 0000000..7d44c9c Binary files /dev/null and b/docs/2.3.0/client_install/images/logos/build-by-maven-white.png differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/logos/maven-feather.png ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/logos/maven-feather.png b/docs/2.3.0/client_install/images/logos/maven-feather.png new file mode 100644 index 0000000..b5ada83 Binary files /dev/null and b/docs/2.3.0/client_install/images/logos/maven-feather.png differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.3.0/client_install/images/newwindow.png ---------------------------------------------------------------------- diff --git a/docs/2.3.0/client_install/images/newwindow.png b/docs/2.3.0/client_install/images/newwindow.png new file mode 100644 index 0000000..6287f72 Binary files /dev/null and b/docs/2.3.0/client_install/images/newwindow.png differ
