http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/1c2f1961/docs/2.3.0/sql_reference/css/maven-base.css ---------------------------------------------------------------------- diff --git a/docs/2.3.0/sql_reference/css/maven-base.css b/docs/2.3.0/sql_reference/css/maven-base.css index 53153e9..584ba23 100644 --- a/docs/2.3.0/sql_reference/css/maven-base.css +++ b/docs/2.3.0/sql_reference/css/maven-base.css @@ -1,155 +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); -} -#navcolumn li.none { - text-indent: -1em; - margin-left: 1em; -} -#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; -} +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/trafodion-site/blob/1c2f1961/docs/2.3.0/sql_reference/css/print.css ---------------------------------------------------------------------- diff --git a/docs/2.3.0/sql_reference/css/print.css b/docs/2.3.0/sql_reference/css/print.css index f09d546..26ad7f0 100644 --- a/docs/2.3.0/sql_reference/css/print.css +++ b/docs/2.3.0/sql_reference/css/print.css @@ -1,7 +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 -} +#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/trafodion-site/blob/1c2f1961/docs/2.3.0/sql_reference/dependencies.html ---------------------------------------------------------------------- diff --git a/docs/2.3.0/sql_reference/dependencies.html b/docs/2.3.0/sql_reference/dependencies.html index 9a13cef..f3d010a 100644 --- a/docs/2.3.0/sql_reference/dependencies.html +++ b/docs/2.3.0/sql_reference/dependencies.html @@ -1,178 +1,95 @@ -<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> -<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-03-12 --> -<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>Trafodion SQL Reference Manual - 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="20180312" /> - <meta http-equiv="Content-Language" content="en" /> - - </head> - <body class="composite"> - <div id="banner"> - <div id="bannerLeft"> - Trafodion SQL Reference Manual - </div> - <div class="clear"> - <hr/> - </div> - </div> - <div id="breadcrumbs"> - - - <div class="xleft"> - <span id="publishDate">Last Published: 2018-03-12</span> - | <span id="projectVersion">Version: 2.3.0</span> - </div> - <div class="xright"> <a href="./" title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</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 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";>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"> +<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> +<!-- Generated by Apache Maven Doxia at Mar 18, 2018 --> +<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="20180318" /> + <meta http-equiv="Content-Language" content="en" /> + + </head> + <body class="composite"> + <div id="banner"> + <div id="bannerLeft"> + Trafodion SQL Reference Manual + </div> + <div class="clear"> + <hr/> + </div> + </div> + <div id="breadcrumbs"> + + + <div class="xleft"> + <span id="publishDate">Last Published: 2018-03-18</span> + | <span id="projectVersion">Version: 2.3.0</span> + </div> + <div class="xright"> <a href="./" title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</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 ); @@ -189,198 +106,24 @@ } } </script> -<a name="Dependency_Tree"></a> -<div class="section"> -<h3>Dependency Tree<a name="Dependency_Tree"></a></h3> -<ul> -<li>org.apache.trafodion:sql-reference-manual: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 SQL Reference Manual</th></tr> -<tr class="b"> -<td> -<p><b>Description: </b>This manual describes reference information about the syntax of SQL statements, +<a name="Dependency_Tree"></a><div class="section"><h3>Dependency Tree<a name="Dependency_Tree"></a></h3><ul><li>org.apache.trafodion:sql-reference-manual: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 SQL Reference Manual</th></tr><tr class="b"><td><p><b>Description: </b>This manual describes reference information about the syntax of SQL statements, functions, and other SQL language elements supported by the Trafodion project’s - database software.</p> -<p><b>URL: </b><a class="externalLink" href="http://trafodion.apache.org";>http://trafodion.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.gif" 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 Metrics 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 SQL Reference Manual</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> -<tr 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-2018 - <a href="http://www.apache.org";>Apache Software Foundation</a>. - All Rights Reserved. - - </div> - <div class="clear"> - <hr/> - </div> - </div> - </body> -</html> + database software.</p><p><b>URL: </b><a class="externalLink" href="http://trafodion.apache.org";>http://trafodion.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.gif" 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 Metrics 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/lic enses/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 Softw are 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 SQL Reference Manual</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</t d><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><tr 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-2018 + <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/trafodion-site/blob/1c2f1961/docs/2.3.0/sql_reference/index.html ---------------------------------------------------------------------- diff --git a/docs/2.3.0/sql_reference/index.html b/docs/2.3.0/sql_reference/index.html index 5766bf1..4e28037 100644 --- a/docs/2.3.0/sql_reference/index.html +++ b/docs/2.3.0/sql_reference/index.html @@ -1885,93 +1885,103 @@ table.CodeRay td.code>pre{padding:0} <li><a href="#examples_of_sum">7.122.2. Examples of SUM</a></li> </ul> </li> -<li><a href="#tan_function">7.123. TAN Function</a> +<li><a href="#sysdate_function">7.123. SYSDATE Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_tan">7.123.1. Examples of TAN</a></li> -<li><a href="#tanh_function">7.123.2. TANH Function</a></li> -<li><a href="#examples_of_tanh">7.123.3. Examples of TANH</a></li> +<li><a href="#examples_of_sysdate">7.123.1. Examples of SYSDATE</a></li> </ul> </li> -<li><a href="#this_function">7.124. THIS Function</a> +<li><a href="#systimestamp_function">7.124. SYSTIMESTAMP Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_this">7.124.1. Considerations for THIS</a></li> -<li><a href="#examples_of_this">7.124.2. Examples of THIS</a></li> +<li><a href="#examples_of_systimestamp">7.124.1. Examples of SYSTIMESTAMP</a></li> </ul> </li> -<li><a href="#timestampadd_function">7.125. TIMESTAMPADD Function</a> +<li><a href="#tan_function">7.125. TAN Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_timestampadd">7.125.1. Examples of TIMESTAMPADD</a></li> +<li><a href="#examples_of_tan">7.125.1. Examples of TAN</a></li> +<li><a href="#tanh_function">7.125.2. TANH Function</a></li> +<li><a href="#examples_of_tanh">7.125.3. Examples of TANH</a></li> </ul> </li> -<li><a href="#timestampdiff_function">7.126. TIMESTAMPDIFF Function</a> +<li><a href="#this_function">7.126. THIS Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_timestampdiff">7.126.1. Examples of TIMESTAMPDIFF</a></li> +<li><a href="#considerations_for_this">7.126.1. Considerations for THIS</a></li> +<li><a href="#examples_of_this">7.126.2. Examples of THIS</a></li> </ul> </li> -<li><a href="#to_char_function">7.127. TO_CHAR Function</a> +<li><a href="#timestampadd_function">7.127. TIMESTAMPADD Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_to_char">7.127.1. Considerations for TO_CHAR</a></li> -<li><a href="#examples_of_to_char">7.127.2. Examples of TO_CHAR</a></li> +<li><a href="#examples_of_timestampadd">7.127.1. Examples of TIMESTAMPADD</a></li> </ul> </li> -<li><a href="#to_date_function">7.128. TO_DATE Function</a> +<li><a href="#timestampdiff_function">7.128. TIMESTAMPDIFF Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_to_date">7.128.1. Considerations for TO_DATE</a></li> -<li><a href="#examples_of_to_date">7.128.2. Examples of TO_DATE</a></li> +<li><a href="#examples_of_timestampdiff">7.128.1. Examples of TIMESTAMPDIFF</a></li> </ul> </li> -<li><a href="#to_time_function">7.129. TO_TIME Function</a> +<li><a href="#to_char_function">7.129. TO_CHAR Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_to_time">7.129.1. Examples of TO_TIME</a></li> +<li><a href="#considerations_for_to_char">7.129.1. Considerations for TO_CHAR</a></li> +<li><a href="#examples_of_to_char">7.129.2. Examples of TO_CHAR</a></li> </ul> </li> -<li><a href="#to_timestamp_function">7.130. TO_TIMESTAMP Function</a> +<li><a href="#to_date_function">7.130. TO_DATE Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_to_timestamp">7.130.1. Example of TO_TIMESTAMP</a></li> +<li><a href="#considerations_for_to_date">7.130.1. Considerations for TO_DATE</a></li> +<li><a href="#examples_of_to_date">7.130.2. Examples of TO_DATE</a></li> </ul> </li> -<li><a href="#translate_function">7.131. TRANSLATE Function</a></li> -<li><a href="#trim_function">7.132. TRIM Function</a> +<li><a href="#to_time_function">7.131. TO_TIME Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_trim">7.132.1. Considerations for TRIM</a></li> -<li><a href="#examples_of_trim">7.132.2. Examples of TRIM</a></li> +<li><a href="#examples_of_to_time">7.131.1. Examples of TO_TIME</a></li> </ul> </li> -<li><a href="#ucase_function">7.133. UCASE Function</a> +<li><a href="#to_timestamp_function">7.132. TO_TIMESTAMP Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_ucase">7.133.1. Considerations for UCASE</a></li> -<li><a href="#examples_of_ucase">7.133.2. Examples of UCASE</a></li> -<li><a href="#upper_function">7.133.3. UPPER Function</a></li> -<li><a href="#examples_of_upper">7.133.4. Examples of UPPER</a></li> -<li><a href="#upshift_function">7.133.5. UPSHIFT Function</a></li> -<li><a href="#examples_of_upshift">7.133.6. Examples of UPSHIFT</a></li> +<li><a href="#examples_of_to_timestamp">7.132.1. Example of TO_TIMESTAMP</a></li> </ul> </li> -<li><a href="#user_function">7.134. USER Function</a> +<li><a href="#translate_function">7.133. TRANSLATE Function</a></li> +<li><a href="#trim_function">7.134. TRIM Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_user">7.134.1. Considerations for USER</a></li> -<li><a href="#examples_of_user">7.134.2. Examples of USER</a></li> +<li><a href="#considerations_for_trim">7.134.1. Considerations for TRIM</a></li> +<li><a href="#examples_of_trim">7.134.2. Examples of TRIM</a></li> </ul> </li> -<li><a href="#variance_function">7.135. VARIANCE Function</a> +<li><a href="#ucase_function">7.135. UCASE Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_variance">7.135.1. Considerations for VARIANCE</a></li> -<li><a href="#examples_of_variance">7.135.2. Examples of VARIANCE</a></li> +<li><a href="#considerations_for_ucase">7.135.1. Considerations for UCASE</a></li> +<li><a href="#examples_of_ucase">7.135.2. Examples of UCASE</a></li> +<li><a href="#upper_function">7.135.3. UPPER Function</a></li> +<li><a href="#examples_of_upper">7.135.4. Examples of UPPER</a></li> +<li><a href="#upshift_function">7.135.5. UPSHIFT Function</a></li> +<li><a href="#examples_of_upshift">7.135.6. Examples of UPSHIFT</a></li> </ul> </li> -<li><a href="#week_function">7.136. WEEK Function</a> +<li><a href="#user_function">7.136. USER Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_week">7.136.1. Examples of WEEK</a></li> +<li><a href="#considerations_for_user">7.136.1. Considerations for USER</a></li> +<li><a href="#examples_of_user">7.136.2. Examples of USER</a></li> </ul> </li> -<li><a href="#year_function">7.137. YEAR Function</a> +<li><a href="#variance_function">7.137. VARIANCE Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_year">7.137.1. Examples of YEAR</a></li> +<li><a href="#considerations_for_variance">7.137.1. Considerations for VARIANCE</a></li> +<li><a href="#examples_of_variance">7.137.2. Examples of VARIANCE</a></li> </ul> </li> -<li><a href="#zeroifnull_function">7.138. ZEROIFNULL Function</a> +<li><a href="#week_function">7.138. WEEK Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_zeroifnull">7.138.1. Examples of ZEROIFNULL</a></li> +<li><a href="#examples_of_week">7.138.1. Examples of WEEK</a></li> +</ul> +</li> +<li><a href="#year_function">7.139. YEAR Function</a> +<ul class="sectlevel3"> +<li><a href="#examples_of_year">7.139.1. Examples of YEAR</a></li> +</ul> +</li> +<li><a href="#zeroifnull_function">7.140. ZEROIFNULL Function</a> +<ul class="sectlevel3"> +<li><a href="#examples_of_zeroifnull">7.140.1. Examples of ZEROIFNULL</a></li> </ul> </li> </ul> @@ -8256,17 +8266,6 @@ the NOT NULL column constraints that exist for the source table with different c </div> </li> <li> -<p><code>WITH PARTITIONS</code></p> -<div class="paragraph"> -<p>directs Trafodion SQL to use partition definitions from <em>source-table</em>. Each new table partition resides on the same volume -as its original <em>source-table</em> counterpart. The new table partitions do not inherit partition names from the original table. -Instead, Trafodion SQL generates new names based on the physical file location.</p> -</div> -<div class="paragraph"> -<p>If you specify the LIKE clause and the SALT USING <em>num</em> PARTITIONS clause, you cannot specify WITH PARTITIONS.</p> -</div> -</li> -<li> <p><code>WITHOUT DIVISION</code></p> <div class="paragraph"> <p>directs Trafodion SQL to not use divisioning from <em>source-table</em>. If this clause is omitted, then @@ -40853,7 +40852,238 @@ SUM (PARTCOST * QTY_ORDERED)</code></pre> </div> </div> <div class="sect2"> -<h3 id="tan_function">7.123. TAN Function</h3> +<h3 id="sysdate_function">7.123. SYSDATE Function</h3> +<div class="paragraph"> +<p>The SYSDATE function, which is equivalent to the <code>CURRENT_DATE</code> function, retrieves the current date of the server rather than the session.</p> +</div> +<div class="paragraph"> +<p>The returned value is <code>DATE</code> and the default format is <code>YYYY-MM-DD</code>.</p> +</div> +<div class="paragraph"> +<p>For example, if you execute a query on your local machine located in Shanghai on 2018-03-14 06:00:00 (UTC+8) against a database server located in Berlin on 2018-03-13 23:00:00 (UTC+1), the result of <code>SELECT SYSDATE FROM DUAL;</code> is 2018-03-13 rather than 2018-03-14.</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SYSDATE</code></pre> +</div> +</div> +<div class="sect3"> +<h4 id="examples_of_sysdate">7.123.1. Examples of SYSDATE</h4> +<div class="ulist"> +<ul> +<li> +<p>This example returns the current date.</p> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SQL>SELECT SYSDATE FROM DUAL; + +(EXPR) +---------- +2018-03-15 + +--- 1 row(s) selected.</code></pre> +</div> +</div> +</li> +<li> +<p>This example returns the date of yesterday, today and tomorrow.</p> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SQL>SELECT SYSDATE -1 AS yesterday, +SYSDATE AS today, +SYSDATE +1 AS tomorrow FROM DUAL; + +YESTERDAY TODAY TOMORROW +---------- ---------- ---------- +2018-03-14 2018-03-15 2018-03-16 + +--- 1 row(s) selected.</code></pre> +</div> +</div> +</li> +<li> +<p>The following examples show that the values of <code>SYSDATE</code> can be converted to character values.</p> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SQL>SELECT TO_CHAR (SYSDATE, 'DD-MON-YYYY') FROM DUAL; + +(EXPR) +----------- +15-MAR-2018 + +--- 1 row(s) selected.</code></pre> +</div> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SQL>SELECT TO_CHAR (SYSDATE,'HH:MI:SS') FROM DUAL; + +*** ERROR[4072] The operand of function TO_CHAR must be a datetime containing a time. [2018-03-15 11:49:22]</code></pre> +</div> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SQL>SELECT TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') FROM DUAL; + +(EXPR) +------------------- +03/15/2018 00:00:00 + +--- 1 row(s) selected.</code></pre> +</div> +</div> +</li> +<li> +<p>This example converts days to minutes using <code>SYSDATE</code>.</p> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SQL>SELECT (SYSDATE-(SYSDATE-7))*1440 FROM DUAL; + +(EXPR) +----------------- + 10080 + +--- 1 row(s) selected.</code></pre> +</div> +</div> +</li> +<li> +<p>This example demonstrates how the SYSDATE function works in SQL statement.</p> +<div class="paragraph"> +<p>Suppose that we have the following table:</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SQL>SELECT * FROM orders; + +ORDERNUM ORDER_DATE DELIV_DATE SALESREP CUSTNUM +-------- ---------- ---------- -------- ------- + 100210 2018-03-02 2018-04-10 220 127 + 100250 2018-01-23 2018-06-16 220 123 + 101220 2018-02-21 2018-12-15 221 156 + 200300 2018-02-06 2018-07-15 222 126 + 200320 2018-03-08 2018-07-20 223 121 + 200490 2018-02-19 2018-11-01 226 123 + 300350 2018-03-03 2018-08-10 231 123 + 300380 2018-01-19 2018-08-15 226 156 + 400410 2018-01-27 2018-09-14 227 154 + 500450 2018-03-12 2018-09-16 220 124 + 600480 2018-02-12 2018-10-14 226 123 + 700510 2018-02-01 2018-10-16 220 143 + 800660 2018-01-09 2018-11-01 229 100 + +--- 13 row(s) selected.</code></pre> +</div> +</div> +<div class="paragraph"> +<p>The SYSDATE is 2018-03-15.</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SQL>SELECT SYSDATE FROM DUAL; + +(EXPR) +---------- +2018-03-15 + +--- 1 row(s) selected.</code></pre> +</div> +</div> +<div class="paragraph"> +<p>This statement returns qualified rows using <code>SYSDATE</code> function.</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SQL>SELECT * FROM orders +WHERE DAY(deliv_date) = DAY(sysdate+1) +AND ordernum <>100210 +AND salesrep=220 +ORDER BY order_date DESC; + +ORDERNUM ORDER_DATE DELIV_DATE SALESREP CUSTNUM +-------- ---------- ---------- -------- ------- + 500450 2018-03-12 2018-09-16 220 124 + 700510 2018-02-01 2018-10-16 220 143 + 100250 2018-01-23 2018-06-16 220 123 + +--- 3 row(s) selected.</code></pre> +</div> +</div> +</li> +</ul> +</div> +<div style="page-break-after: always;"></div> +</div> +</div> +<div class="sect2"> +<h3 id="systimestamp_function">7.124. SYSTIMESTAMP Function</h3> +<div class="paragraph"> +<p>The SYSTIMESTAMP function, which is equivalent to the <code>CURRENT_TIMESTAMP</code> function, provides much high granularity than the <code>SYSDATE</code> function and retrieves the current date and time (including fractional seconds with six-digit precision) of the server rather than the session.</p> +</div> +<div class="paragraph"> +<p>The returned value is <code>TIMESTAMP</code> and the default format is <code>YYYY-MM-DD HH:MM:SS.FFFFFF</code>.</p> +</div> +<div class="paragraph"> +<p>For example, if you execute a query on your local machine located in Shanghai on 2018-03-14 06:00:00 (UTC+8) against a database server located in Berlin on 2018-03-13 23:00:00 (UTC+1), the result of <code>SELECT SYSTIMESTAMP FROM DUAL;</code> is 2018-03-13 23:00:00 rather than 2018-03-14 06:00:00.</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SYSTIMESTAMP</code></pre> +</div> +</div> +<div class="sect3"> +<h4 id="examples_of_systimestamp">7.124.1. Examples of SYSTIMESTAMP</h4> +<div class="ulist"> +<ul> +<li> +<p>This example calculates the date and time of anniversary using SYSTIMESTAMP function.</p> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SELECT SYSTIMESTAMP AS today, SYSTIMESTAMP + INTERVAL '12' MONTH AS Annisversary FROM DUAL; + +TODAY ANNISVERSARY +-------------------------- -------------------------- +2018-03-15 11:19:42.400382 2019-03-15 11:19:42.400382 + +--- 1 row(s) selected.</code></pre> +</div> +</div> +</li> +<li> +<p>This example demonstrates how to insert the value of SYSTIMESTAMP into a column.</p> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SQL>CREATE TABLE test1 (C1 TIMESTAMP, C2 VARCHAR(40)); + +--- SQL operation complete.</code></pre> +</div> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SQL>INSERT INTO test1 VALUES (SYSTIMESTAMP, 'This is the time that I insert values'); + +--- 1 row(s) inserted.</code></pre> +</div> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SQL>SELECT * FROM test1; + +C1 C2 +-------------------------- ---------------------------------------- +2018-03-15 11:33:32.091057 This is the time that I insert values + +--- 1 row(s) selected.</code></pre> +</div> +</div> +</li> +</ul> +</div> +<div style="page-break-after: always;"></div> +</div> +</div> +<div class="sect2"> +<h3 id="tan_function">7.125. TAN Function</h3> <div class="paragraph"> <p>The TAN function returns the tangent of a numeric value expression, where the expression is an angle expressed in radians.</p> @@ -40879,7 +41109,7 @@ See <a href="#numeric_value_expressions">Numeric Value Expressions</a>.</p> </ul> </div> <div class="sect3"> -<h4 id="examples_of_tan">7.123.1. Examples of TAN</h4> +<h4 id="examples_of_tan">7.125.1. Examples of TAN</h4> <div class="ulist"> <ul> <li> @@ -40896,7 +41126,7 @@ approximately 0.3640, the tangent of 0.3491 (which is 20 degrees):</p> <div style="page-break-after: always;"></div> </div> <div class="sect3"> -<h4 id="tanh_function">7.123.2. TANH Function</h4> +<h4 id="tanh_function">7.125.2. TANH Function</h4> <div class="paragraph"> <p>The TANH function returns the hyperbolic tangent of a numeric value expression, where the expression is an angle expressed in radians.</p> @@ -40923,7 +41153,7 @@ function. See <a href="#numeric_value_expressions">Numeric Value Expressions</a> </div> </div> <div class="sect3"> -<h4 id="examples_of_tanh">7.123.3. Examples of TANH</h4> +<h4 id="examples_of_tanh">7.125.3. Examples of TANH</h4> <div class="ulist"> <ul> <li> @@ -40941,7 +41171,7 @@ approximately 0.8483, the hyperbolic tangent of 1.25:</p> </div> </div> <div class="sect2"> -<h3 id="this_function">7.124. THIS Function</h3> +<h3 id="this_function">7.126. THIS Function</h3> <div class="paragraph"> <p>The THIS function is a sequence function that is used in the ROWS SINCE function to distinguish between the value of the column in the current @@ -40969,7 +41199,7 @@ expression. If the value of the expression is null, THIS returns null.</p> </ul> </div> <div class="sect3"> -<h4 id="considerations_for_this">7.124.1. Considerations for THIS</h4> +<h4 id="considerations_for_this">7.126.1. Considerations for THIS</h4> <div class="sect4"> <h5 id="counting_the_rows">Counting the Rows</h5> <div class="paragraph"> @@ -41001,7 +41231,7 @@ THIS constant is reevaluated.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_this">7.124.2. Examples of THIS</h4> +<h4 id="examples_of_this">7.126.2. Examples of THIS</h4> <div class="ulist"> <ul> <li> @@ -41030,7 +41260,7 @@ rows_since_this </div> </div> <div class="sect2"> -<h3 id="timestampadd_function">7.125. TIMESTAMPADD Function</h3> +<h3 id="timestampadd_function">7.127. TIMESTAMPADD Function</h3> <div class="paragraph"> <p>The TIMESTAMPADD function adds the interval of time specified by <em>interval-ind</em> and <em>num_expr</em> to <em>datetime_expr</em>. If the specified @@ -41080,7 +41310,7 @@ returned.</p> </div> <div style="page-break-after: always;"></div> <div class="sect3"> -<h4 id="examples_of_timestampadd">7.125.1. Examples of TIMESTAMPADD</h4> +<h4 id="examples_of_timestampadd">7.127.1. Examples of TIMESTAMPADD</h4> <div class="ulist"> <ul> <li> @@ -41145,7 +41375,7 @@ returned.</p> </div> </div> <div class="sect2"> -<h3 id="timestampdiff_function">7.126. TIMESTAMPDIFF Function</h3> +<h3 id="timestampdiff_function">7.128. TIMESTAMPDIFF Function</h3> <div class="paragraph"> <p>The TIMESTAMPDIFF function returns the integer value for the number of <em>interval-ind</em> units of time between <em>startdate</em> and <em>enddate</em>. If @@ -41210,7 +41440,7 @@ January 7 of the year 0001.</p> </div> <div style="page-break-after: always;"></div> <div class="sect3"> -<h4 id="examples_of_timestampdiff">7.126.1. Examples of TIMESTAMPDIFF</h4> +<h4 id="examples_of_timestampdiff">7.128.1. Examples of TIMESTAMPDIFF</h4> <div class="ulist"> <ul> <li> @@ -41274,7 +41504,7 @@ crossed:</p> </div> </div> <div class="sect2"> -<h3 id="to_char_function">7.127. TO_CHAR Function</h3> +<h3 id="to_char_function">7.129. TO_CHAR Function</h3> <div class="paragraph"> <p>The TO_CHAR function converts a datetime value to a character value. The optional second argument describes the format of the character value.</p> @@ -41393,7 +41623,7 @@ will appear in upper case.</p> default for date and timestamp values, and 'HH:MI:SS' is used for time values.</p> </div> <div class="sect3"> -<h4 id="considerations_for_to_char">7.127.1. Considerations for TO_CHAR</h4> +<h4 id="considerations_for_to_char">7.129.1. Considerations for TO_CHAR</h4> <div class="paragraph"> <p>If the <em>format-string</em> contains only hour, minute or seconds fields, the input data type must be time or timestamp.</p> </div> @@ -41405,7 +41635,7 @@ default for date and timestamp values, and 'HH:MI:SS' is used for time values.</ </div> </div> <div class="sect3"> -<h4 id="examples_of_to_char">7.127.2. Examples of TO_CHAR</h4> +<h4 id="examples_of_to_char">7.129.2. Examples of TO_CHAR</h4> <div class="ulist"> <ul> <li> @@ -41446,7 +41676,7 @@ default for date and timestamp values, and 'HH:MI:SS' is used for time values.</ </div> </div> <div class="sect2"> -<h3 id="to_date_function">7.128. TO_DATE Function</h3> +<h3 id="to_date_function">7.130. TO_DATE Function</h3> <div class="paragraph"> <p>The TO_DATE function converts a character value to a date. The optional second argument describes the format of the character value.</p> @@ -41558,14 +41788,14 @@ a three-letter abbreviation for month ('JAN', 'FEB', 'MAR', 'APR', 'MAY', 'JUN', default.</p> </div> <div class="sect3"> -<h4 id="considerations_for_to_date">7.128.1. Considerations for TO_DATE</h4> +<h4 id="considerations_for_to_date">7.130.1. Considerations for TO_DATE</h4> <div class="paragraph"> <p>If the <em>format-string</em> contains hour, minute or seconds fields, the output data type is timestamp. Otherwise, the output data type is date.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_to_date">7.128.2. Examples of TO_DATE</h4> +<h4 id="examples_of_to_date">7.130.2. Examples of TO_DATE</h4> <div class="ulist"> <ul> <li> @@ -41606,7 +41836,7 @@ the output data type is date.</p> </div> </div> <div class="sect2"> -<h3 id="to_time_function">7.129. TO_TIME Function</h3> +<h3 id="to_time_function">7.131. TO_TIME Function</h3> <div class="paragraph"> <p>The TO_TIME function converts a character value to a time. The second argument describes the format of the character value.</p> @@ -41646,7 +41876,7 @@ second argument describes the format of the character value.</p> <p>Here, HH and HH24 refer to a 2-digit hour field. MI refers to a two-digit minutes field. SS refers to a 2-digit seconds field.</p> </div> <div class="sect3"> -<h4 id="examples_of_to_time">7.129.1. Examples of TO_TIME</h4> +<h4 id="examples_of_to_time">7.131.1. Examples of TO_TIME</h4> <div class="ulist"> <ul> <li> @@ -41663,7 +41893,7 @@ second argument describes the format of the character value.</p> </div> </div> <div class="sect2"> -<h3 id="to_timestamp_function">7.130. TO_TIMESTAMP Function</h3> +<h3 id="to_timestamp_function">7.132. TO_TIMESTAMP Function</h3> <div class="paragraph"> <p>The TO_TIMESTAMP function converts a character value to a timestamp.</p> </div> @@ -41685,7 +41915,7 @@ minutes field, SS is a two-digit seconds field and FFFFFF is an optional microse </ul> </div> <div class="sect3"> -<h4 id="examples_of_to_timestamp">7.130.1. Example of TO_TIMESTAMP</h4> +<h4 id="examples_of_to_timestamp">7.132.1. Example of TO_TIMESTAMP</h4> <div class="ulist"> <ul> <li> @@ -41702,7 +41932,7 @@ minutes field, SS is a two-digit seconds field and FFFFFF is an optional microse </div> </div> <div class="sect2"> -<h3 id="translate_function">7.131. TRANSLATE Function</h3> +<h3 id="translate_function">7.133. TRANSLATE Function</h3> <div class="paragraph"> <p>The TRANSLATE function translates a character string from a source character set to a target character set. The TRANSLATE function changes @@ -41787,7 +42017,7 @@ Trafodion SQL returns an error.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="trim_function">7.132. TRIM Function</h3> +<h3 id="trim_function">7.134. TRIM Function</h3> <div class="paragraph"> <p>The TRIM function removes leading and trailing characters from a character string. Every character, including multi-byte characters, is @@ -41834,7 +42064,7 @@ to trim characters. See <a href="#character_value_expressions">Character Value E </ul> </div> <div class="sect3"> -<h4 id="considerations_for_trim">7.132.1. Considerations for TRIM</h4> +<h4 id="considerations_for_trim">7.134.1. Considerations for TRIM</h4> <div class="sect4"> <h5 id="result_of_trim">Result of TRIM</h5> <div class="paragraph"> @@ -41847,7 +42077,7 @@ result is an up-shifts VARCHAR type.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_trim">7.132.2. Examples of TRIM</h4> +<h4 id="examples_of_trim">7.134.2. Examples of TRIM</h4> <div class="ulist"> <ul> <li> @@ -41874,7 +42104,7 @@ CHAR(20). This expression uses the TRIM function to return the value </div> </div> <div class="sect2"> -<h3 id="ucase_function">7.133. UCASE Function</h3> +<h3 id="ucase_function">7.135. UCASE Function</h3> <div class="paragraph"> <p>The UCASE function up-shifts alphanumeric characters. For non-alphanumeric characters, UCASE returns the same character. UCASE can @@ -41909,7 +42139,7 @@ characters to upshift. See <a href="#character_value_expressions">Character Valu </ul> </div> <div class="sect3"> -<h4 id="considerations_for_ucase">7.133.1. Considerations for UCASE</h4> +<h4 id="considerations_for_ucase">7.135.1. Considerations for UCASE</h4> <div class="paragraph"> <p>For a UTF8 character_expression, the UCASE function up-shifts all lowercase or title case characters to uppercase and returns a character @@ -41928,7 +42158,7 @@ name includes <em>title</em>.</p> <div style="page-break-after: always;"></div> </div> <div class="sect3"> -<h4 id="examples_of_ucase">7.133.2. Examples of UCASE</h4> +<h4 id="examples_of_ucase">7.135.2. Examples of UCASE</h4> <div class="ulist"> <ul> <li> @@ -41956,7 +42186,7 @@ Hotel Oregon HOTEL OREGON hotel oregon <div style="page-break-after: always;"></div> </div> <div class="sect3"> -<h4 id="upper_function">7.133.3. UPPER Function</h4> +<h4 id="upper_function">7.135.3. UPPER Function</h4> <div class="paragraph"> <p>The UPPER function up-shifts alphanumeric characters. For non-alphanumeric characters, UCASE returns the same character. UPPER can @@ -41989,7 +42219,7 @@ See <a href="#character_value_expressions">Character Value Expressions</a>.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_upper">7.133.4. Examples of UPPER</h4> +<h4 id="examples_of_upper">7.135.4. Examples of UPPER</h4> <div class="ulist"> <ul> <li> @@ -42021,7 +42251,7 @@ see <a href="#upshift_function">UPSHIFT Function</a>.</p> <div style="page-break-after: always;"></div> </div> <div class="sect3"> -<h4 id="upshift_function">7.133.5. UPSHIFT Function</h4> +<h4 id="upshift_function">7.135.5. UPSHIFT Function</h4> <div class="paragraph"> <p>The UPSHIFT function up-shifts alphanumeric characters. For non-alphanumeric characters, UCASE returns the same character. UPSHIFT @@ -42058,7 +42288,7 @@ characters to upshift. See </div> </div> <div class="sect3"> -<h4 id="examples_of_upshift">7.133.6. Examples of UPSHIFT</h4> +<h4 id="examples_of_upshift">7.135.6. Examples of UPSHIFT</h4> <div class="ulist"> <ul> <li> @@ -42121,7 +42351,7 @@ WHERE UPSHIFT(D1.deptname) = UPSHIFT(D2.deptname);</code></pre> </div> </div> <div class="sect2"> -<h3 id="user_function">7.134. USER Function</h3> +<h3 id="user_function">7.136. USER Function</h3> <div class="paragraph"> <p>The USER function returns either the database user name associated with the specified user ID number or the database user name of the current @@ -42152,7 +42382,7 @@ and the <a href="#current_user_function">CURRENT USER Function</a>.</p> </ul> </div> <div class="sect3"> -<h4 id="considerations_for_user">7.134.1. Considerations for USER</h4> +<h4 id="considerations_for_user">7.136.1. Considerations for USER</h4> <div class="ulist"> <ul> <li> @@ -42165,7 +42395,7 @@ and the <a href="#current_user_function">CURRENT USER Function</a>.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_user">7.134.2. Examples of USER</h4> +<h4 id="examples_of_user">7.136.2. Examples of USER</h4> <div class="ulist"> <ul> <li> @@ -42208,7 +42438,7 @@ DB ROOT </div> </div> <div class="sect2"> -<h3 id="variance_function">7.135. VARIANCE Function</h3> +<h3 id="variance_function">7.137. VARIANCE Function</h3> <div class="paragraph"> <p>VARIANCE is an aggregate function that returns the statistical variance of a set of numbers. VARIANCE is a Trafodion SQL extension.</p> @@ -42254,7 +42484,7 @@ as <em>expression</em>. The one-column table derived from the evaluation of </ul> </div> <div class="sect3"> -<h4 id="considerations_for_variance">7.135.1. Considerations for VARIANCE</h4> +<h4 id="considerations_for_variance">7.137.1. Considerations for VARIANCE</h4> <div class="sect4"> <h5 id="definition_of_variance">Definition of VARIANCE</h5> <div class="paragraph"> @@ -42348,7 +42578,7 @@ the computation of VARIANCE(x), then a numeric overflow occurs.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_variance">7.135.2. Examples of VARIANCE</h4> +<h4 id="examples_of_variance">7.137.2. Examples of VARIANCE</h4> <div class="ulist"> <ul> <li> @@ -42385,7 +42615,7 @@ VARIANCE_SALARY </div> </div> <div class="sect2"> -<h3 id="week_function">7.136. WEEK Function</h3> +<h3 id="week_function">7.138. WEEK Function</h3> <div class="paragraph"> <p>The WEEK function converts a DATE or TIMESTAMP expression into an INTEGER value in the range 1 through 54 that represents the @@ -42417,7 +42647,7 @@ TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressions< </ul> </div> <div class="sect3"> -<h4 id="examples_of_week">7.136.1. Examples of WEEK</h4> +<h4 id="examples_of_week">7.138.1. Examples of WEEK</h4> <div class="ulist"> <ul> <li> @@ -42441,7 +42671,7 @@ Start/Date Time/Shipped (EXPR) </div> </div> <div class="sect2"> -<h3 id="year_function">7.137. YEAR Function</h3> +<h3 id="year_function">7.139. YEAR Function</h3> <div class="paragraph"> <p>The YEAR function converts a DATE or TIMESTAMP expression into an INTEGER value that represents the year.</p> @@ -42466,7 +42696,7 @@ TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressions< </ul> </div> <div class="sect3"> -<h4 id="examples_of_year">7.137.1. Examples of YEAR</h4> +<h4 id="examples_of_year">7.139.1. Examples of YEAR</h4> <div class="ulist"> <ul> <li> @@ -42490,7 +42720,7 @@ Start/Date Time/Shipped (EXPR) </div> </div> <div class="sect2"> -<h3 id="zeroifnull_function">7.138. ZEROIFNULL Function</h3> +<h3 id="zeroifnull_function">7.140. ZEROIFNULL Function</h3> <div class="paragraph"> <p>The ZEROIFNULL function returns a value of zero if the expression if NULL. Otherwise, it returns the value of the expression.</p> @@ -42511,7 +42741,7 @@ NULL. Otherwise, it returns the value of the expression.</p> </ul> </div> <div class="sect3"> -<h4 id="examples_of_zeroifnull">7.138.1. Examples of ZEROIFNULL</h4> +<h4 id="examples_of_zeroifnull">7.140.1. Examples of ZEROIFNULL</h4> <div class="ulist"> <ul> <li> @@ -47083,7 +47313,7 @@ or 256 bytes of UTF8 text, whichever is less.</p></td> <div id="footer"> <div id="footer-text"> Version 2.3.0<br> -Last updated 2018-03-12 18:50:29 UTC +Last updated 2018-01-03 21:27:09 UTC </div> </div> <script> http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/1c2f1961/docs/2.3.0/sql_reference/integration.html ---------------------------------------------------------------------- diff --git a/docs/2.3.0/sql_reference/integration.html b/docs/2.3.0/sql_reference/integration.html index 5aaecf9..1512b44 100644 --- a/docs/2.3.0/sql_reference/integration.html +++ b/docs/2.3.0/sql_reference/integration.html @@ -1,120 +1,110 @@ -<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> -<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-03-12 --> -<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>Trafodion SQL Reference Manual - Continuous Integration</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="20180312" /> - <meta http-equiv="Content-Language" content="en" /> - - </head> - <body class="composite"> - <div id="banner"> - <div id="bannerLeft"> - Trafodion SQL Reference Manual - </div> - <div class="clear"> - <hr/> - </div> - </div> - <div id="breadcrumbs"> - - - <div class="xleft"> - <span id="publishDate">Last Published: 2018-03-12</span> - | <span id="projectVersion">Version: 2.3.0</span> - </div> - <div class="xright"> <a href="./" title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</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"> - <strong>Continuous Integration</strong> - </li> - <li class="none"> - <a href="dependencies.html" title="Dependencies">Dependencies</a> - </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"> - <div class="section"> -<h2>Overview<a name="Overview"></a></h2><a name="Overview"></a> -<p>This project uses <a class="externalLink" href="http://jenkins-ci.org/";>Jenkins</a>.</p></div> -<div class="section"> -<h2>Access<a name="Access"></a></h2><a name="Access"></a> -<p>The following is a link to the continuous integration system used by the project:</p> -<div class="source"> -<pre><a class="externalLink" href="https://jenkins.esgyn.com";>https://jenkins.esgyn.com</a></pre></div></div> -<div class="section"> -<h2>Notifiers<a name="Notifiers"></a></h2><a name="Notifiers"></a> -<p>No notifiers are defined. Please check back at a later date.</p></div> - </div> - </div> - <div class="clear"> - <hr/> - </div> - <div id="footer"> - <div class="xright"> - Copyright © 2015-2018 - <a href="http://www.apache.org";>Apache Software Foundation</a>. - All Rights Reserved. - - </div> - <div class="clear"> - <hr/> - </div> - </div> - </body> -</html> +<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> +<!-- Generated by Apache Maven Doxia at Mar 18, 2018 --> +<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>Continuous Integration</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="20180318" /> + <meta http-equiv="Content-Language" content="en" /> + + </head> + <body class="composite"> + <div id="banner"> + <div id="bannerLeft"> + Trafodion SQL Reference Manual + </div> + <div class="clear"> + <hr/> + </div> + </div> + <div id="breadcrumbs"> + + + <div class="xleft"> + <span id="publishDate">Last Published: 2018-03-18</span> + | <span id="projectVersion">Version: 2.3.0</span> + </div> + <div class="xright"> <a href="./" title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</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"> + <strong>Continuous Integration</strong> + </li> + <li class="none"> + <a href="dependencies.html" title="Dependencies">Dependencies</a> + </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"> + <div class="section"><h2>Overview<a name="Overview"></a></h2><a name="Overview"></a><p>This project uses <a class="externalLink" href="http://jenkins-ci.org/";>Jenkins</a>.</p></div><div class="section"><h2>Access<a name="Access"></a></h2><a name="Access"></a><p>The following is a link to the continuous integration system used by the project:</p><div class="source"><pre><a class="externalLink" href="https://jenkins.esgyn.com";>https://jenkins.esgyn.com</a></pre></div></div><div class="section"><h2>Notifiers<a name="Notifiers"></a></h2><a name="Notifiers"></a><p>No notifiers are defined. Please check back at a later date.</p></div> + </div> + </div> + <div class="clear"> + <hr/> + </div> + <div id="footer"> + <div class="xright"> + Copyright © 2015-2018 + <a href="http://www.apache.org";>Apache Software Foundation</a>. + All Rights Reserved. + + </div> + <div class="clear"> + <hr/> + </div> + </div> + </body> +</html>
