You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by db...@apache.org on 2016/04/12 00:53:14 UTC
[20/33] incubator-trafodion-site git commit: [TRAFODION-1905] PR 424
Fix document build problem
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/11567d60/docs/2.0.0/spj_guide/integration.html
----------------------------------------------------------------------
diff --git a/docs/2.0.0/spj_guide/integration.html b/docs/2.0.0/spj_guide/integration.html
new file mode 100644
index 0000000..ea70a8b
--- /dev/null
+++ b/docs/2.0.0/spj_guide/integration.html
@@ -0,0 +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 at Apr 11, 2016 -->
+<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
+ <head>
+ <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
+ <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="20160411" />
+ <meta http-equiv="Content-Language" content="en" />
+
+ </head>
+ <body class="composite">
+ <div id="banner">
+ <div id="bannerLeft">
+ Trafodion SPJ Guide
+ </div>
+ <div class="clear">
+ <hr/>
+ </div>
+ </div>
+ <div id="breadcrumbs">
+
+
+ <div class="xleft">
+ <span id="publishDate">Last Published: 2016-04-11</span>
+ | <span id="projectVersion">Version: 2.0.0</span>
+ </div>
+ <div class="xright"> <a href="./" title="Trafodion SPJ Guide">Trafodion SPJ 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">
+ <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-2016
+ <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/11567d60/docs/2.0.0/spj_guide/issue-tracking.html
----------------------------------------------------------------------
diff --git a/docs/2.0.0/spj_guide/issue-tracking.html b/docs/2.0.0/spj_guide/issue-tracking.html
new file mode 100644
index 0000000..01eb926
--- /dev/null
+++ b/docs/2.0.0/spj_guide/issue-tracking.html
@@ -0,0 +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 at Apr 11, 2016 -->
+<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
+ <head>
+ <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
+ <title>Issue Tracking</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="20160411" />
+ <meta http-equiv="Content-Language" content="en" />
+
+ </head>
+ <body class="composite">
+ <div id="banner">
+ <div id="bannerLeft">
+ Trafodion SPJ Guide
+ </div>
+ <div class="clear">
+ <hr/>
+ </div>
+ </div>
+ <div id="breadcrumbs">
+
+
+ <div class="xleft">
+ <span id="publishDate">Last Published: 2016-04-11</span>
+ | <span id="projectVersion">Version: 2.0.0</span>
+ </div>
+ <div class="xright"> <a href="./" title="Trafodion SPJ Guide">Trafodion SPJ 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">
+ <strong>Issue Tracking</strong>
+ </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">
+ <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://www.atlassian.com/software/jira">JIRA</a>.</p></div><div class="section"><h2>Issue Tracking<a name="Issue_Tracking"></a></h2><a name="Issue_Tracking"></a><p>Issues, bugs, and feature requests should be submitted to the following issue tracking system for this project.</p><div class="source"><pre><a class="externalLink" href="http://issues.apache.org/jira/browse/TRAFODION">http://issues.apache.org/jira/browse/TRAFODION</a></pre></div></div>
+ </div>
+ </div>
+ <div class="clear">
+ <hr/>
+ </div>
+ <div id="footer">
+ <div class="xright">
+ Copyright © 2015-2016
+ <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/11567d60/docs/2.0.0/spj_guide/license.html
----------------------------------------------------------------------
diff --git a/docs/2.0.0/spj_guide/license.html b/docs/2.0.0/spj_guide/license.html
new file mode 100644
index 0000000..8078f76
--- /dev/null
+++ b/docs/2.0.0/spj_guide/license.html
@@ -0,0 +1,312 @@
+<!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 Apr 11, 2016 -->
+<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
+ <head>
+ <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
+ <title>Project License</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="20160411" />
+ <meta http-equiv="Content-Language" content="en" />
+
+ </head>
+ <body class="composite">
+ <div id="banner">
+ <div id="bannerLeft">
+ Trafodion SPJ Guide
+ </div>
+ <div class="clear">
+ <hr/>
+ </div>
+ </div>
+ <div id="breadcrumbs">
+
+
+ <div class="xleft">
+ <span id="publishDate">Last Published: 2016-04-11</span>
+ | <span id="projectVersion">Version: 2.0.0</span>
+ </div>
+ <div class="xright"> <a href="./" title="Trafodion SPJ Guide">Trafodion SPJ 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">
+ <strong>Project License</strong>
+ </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">
+ <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>Typically the licenses listed for the project are that of the project itself, and not of dependencies.</p></div><div class="section"><h2>Project License<a name="Project_License"></a></h2><a name="Project_License"></a><div class="section"><h3>The Apache Software License, Version 2.0<a name="The_Apache_Software_License_Version_2.0"></a></h3><a name="The_Apache_Software_License_Version_2.0"></a><p>A business-friendly OSS license</p><div class="source"><pre>
+ Apache License
+ Version 2.0, January 2004
+ http://www.apache.org/licenses/
+
+ TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION
+
+ 1. Definitions.
+
+ "License" shall mean the terms and conditions for use, reproduction,
+ and distribution as defined by Sections 1 through 9 of this document.
+
+ "Licensor" shall mean the copyright owner or entity authorized by
+ the copyright owner that is granting the License.
+
+ "Legal Entity" shall mean the union of the acting entity and all
+ other entities that control, are controlled by, or are under common
+ control with that entity. For the purposes of this definition,
+ "control" means (i) the power, direct or indirect, to cause the
+ direction or management of such entity, whether by contract or
+ otherwise, or (ii) ownership of fifty percent (50%) or more of the
+ outstanding shares, or (iii) beneficial ownership of such entity.
+
+ "You" (or "Your") shall mean an individual or Legal Entity
+ exercising permissions granted by this License.
+
+ "Source" form shall mean the preferred form for making modifications,
+ including but not limited to software source code, documentation
+ source, and configuration files.
+
+ "Object" form shall mean any form resulting from mechanical
+ transformation or translation of a Source form, including but
+ not limited to compiled object code, generated documentation,
+ and conversions to other media types.
+
+ "Work" shall mean the work of authorship, whether in Source or
+ Object form, made available under the License, as indicated by a
+ copyright notice that is included in or attached to the work
+ (an example is provided in the Appendix below).
+
+ "Derivative Works" shall mean any work, whether in Source or Object
+ form, that is based on (or derived from) the Work and for which the
+ editorial revisions, annotations, elaborations, or other modifications
+ represent, as a whole, an original work of authorship. For the purposes
+ of this License, Derivative Works shall not include works that remain
+ separable from, or merely link (or bind by name) to the interfaces of,
+ the Work and Derivative Works thereof.
+
+ "Contribution" shall mean any work of authorship, including
+ the original version of the Work and any modifications or additions
+ to that Work or Derivative Works thereof, that is intentionally
+ submitted to Licensor for inclusion in the Work by the copyright owner
+ or by an individual or Legal Entity authorized to submit on behalf of
+ the copyright owner. For the purposes of this definition, "submitted"
+ means any form of electronic, verbal, or written communication sent
+ to the Licensor or its representatives, including but not limited to
+ communication on electronic mailing lists, source code control systems,
+ and issue tracking systems that are managed by, or on behalf of, the
+ Licensor for the purpose of discussing and improving the Work, but
+ excluding communication that is conspicuously marked or otherwise
+ designated in writing by the copyright owner as "Not a Contribution."
+
+ "Contributor" shall mean Licensor and any individual or Legal Entity
+ on behalf of whom a Contribution has been received by Licensor and
+ subsequently incorporated within the Work.
+
+ 2. Grant of Copyright License. Subject to the terms and conditions of
+ this License, each Contributor hereby grants to You a perpetual,
+ worldwide, non-exclusive, no-charge, royalty-free, irrevocable
+ copyright license to reproduce, prepare Derivative Works of,
+ publicly display, publicly perform, sublicense, and distribute the
+ Work and such Derivative Works in Source or Object form.
+
+ 3. Grant of Patent License. Subject to the terms and conditions of
+ this License, each Contributor hereby grants to You a perpetual,
+ worldwide, non-exclusive, no-charge, royalty-free, irrevocable
+ (except as stated in this section) patent license to make, have made,
+ use, offer to sell, sell, import, and otherwise transfer the Work,
+ where such license applies only to those patent claims licensable
+ by such Contributor that are necessarily infringed by their
+ Contribution(s) alone or by combination of their Contribution(s)
+ with the Work to which such Contribution(s) was submitted. If You
+ institute patent litigation against any entity (including a
+ cross-claim or counterclaim in a lawsuit) alleging that the Work
+ or a Contribution incorporated within the Work constitutes direct
+ or contributory patent infringement, then any patent licenses
+ granted to You under this License for that Work shall terminate
+ as of the date such litigation is filed.
+
+ 4. Redistribution. You may reproduce and distribute copies of the
+ Work or Derivative Works thereof in any medium, with or without
+ modifications, and in Source or Object form, provided that You
+ meet the following conditions:
+
+ (a) You must give any other recipients of the Work or
+ Derivative Works a copy of this License; and
+
+ (b) You must cause any modified files to carry prominent notices
+ stating that You changed the files; and
+
+ (c) You must retain, in the Source form of any Derivative Works
+ that You distribute, all copyright, patent, trademark, and
+ attribution notices from the Source form of the Work,
+ excluding those notices that do not pertain to any part of
+ the Derivative Works; and
+
+ (d) If the Work includes a "NOTICE" text file as part of its
+ distribution, then any Derivative Works that You distribute must
+ include a readable copy of the attribution notices contained
+ within such NOTICE file, excluding those notices that do not
+ pertain to any part of the Derivative Works, in at least one
+ of the following places: within a NOTICE text file distributed
+ as part of the Derivative Works; within the Source form or
+ documentation, if provided along with the Derivative Works; or,
+ within a display generated by the Derivative Works, if and
+ wherever such third-party notices normally appear. The contents
+ of the NOTICE file are for informational purposes only and
+ do not modify the License. You may add Your own attribution
+ notices within Derivative Works that You distribute, alongside
+ or as an addendum to the NOTICE text from the Work, provided
+ that such additional attribution notices cannot be construed
+ as modifying the License.
+
+ You may add Your own copyright statement to Your modifications and
+ may provide additional or different license terms and conditions
+ for use, reproduction, or distribution of Your modifications, or
+ for any such Derivative Works as a whole, provided Your use,
+ reproduction, and distribution of the Work otherwise complies with
+ the conditions stated in this License.
+
+ 5. Submission of Contributions. Unless You explicitly state otherwise,
+ any Contribution intentionally submitted for inclusion in the Work
+ by You to the Licensor shall be under the terms and conditions of
+ this License, without any additional terms or conditions.
+ Notwithstanding the above, nothing herein shall supersede or modify
+ the terms of any separate license agreement you may have executed
+ with Licensor regarding such Contributions.
+
+ 6. Trademarks. This License does not grant permission to use the trade
+ names, trademarks, service marks, or product names of the Licensor,
+ except as required for reasonable and customary use in describing the
+ origin of the Work and reproducing the content of the NOTICE file.
+
+ 7. Disclaimer of Warranty. Unless required by applicable law or
+ agreed to in writing, Licensor provides the Work (and each
+ Contributor provides its Contributions) on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or
+ implied, including, without limitation, any warranties or conditions
+ of TITLE, NON-INFRINGEMENT, MERCHANTABILITY, or FITNESS FOR A
+ PARTICULAR PURPOSE. You are solely responsible for determining the
+ appropriateness of using or redistributing the Work and assume any
+ risks associated with Your exercise of permissions under this License.
+
+ 8. Limitation of Liability. In no event and under no legal theory,
+ whether in tort (including negligence), contract, or otherwise,
+ unless required by applicable law (such as deliberate and grossly
+ negligent acts) or agreed to in writing, shall any Contributor be
+ liable to You for damages, including any direct, indirect, special,
+ incidental, or consequential damages of any character arising as a
+ result of this License or out of the use or inability to use the
+ Work (including but not limited to damages for loss of goodwill,
+ work stoppage, computer failure or malfunction, or any and all
+ other commercial damages or losses), even if such Contributor
+ has been advised of the possibility of such damages.
+
+ 9. Accepting Warranty or Additional Liability. While redistributing
+ the Work or Derivative Works thereof, You may choose to offer,
+ and charge a fee for, acceptance of support, warranty, indemnity,
+ or other liability obligations and/or rights consistent with this
+ License. However, in accepting such obligations, You may act only
+ on Your own behalf and on Your sole responsibility, not on behalf
+ of any other Contributor, and only if You agree to indemnify,
+ defend, and hold each Contributor harmless for any liability
+ incurred by, or claims asserted against, such Contributor by reason
+ of your accepting any such warranty or additional liability.
+
+ END OF TERMS AND CONDITIONS
+
+ APPENDIX: How to apply the Apache License to your work.
+
+ To apply the Apache License to your work, attach the following
+ boilerplate notice, with the fields enclosed by brackets "[]"
+ replaced with your own identifying information. (Don't include
+ the brackets!) The text should be enclosed in the appropriate
+ comment syntax for the file format. We also recommend that a
+ file or class name and description of purpose be included on the
+ same "printed page" as the copyright notice for easier
+ identification within third-party archives.
+
+ Copyright [yyyy] [name of copyright owner]
+
+ Licensed under the Apache License, Version 2.0 (the "License");
+ you may not use this file except in compliance with the License.
+ You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+</pre></div></div></div>
+ </div>
+ </div>
+ <div class="clear">
+ <hr/>
+ </div>
+ <div id="footer">
+ <div class="xright">
+ Copyright © 2015-2016
+ <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/11567d60/docs/2.0.0/spj_guide/mail-lists.html
----------------------------------------------------------------------
diff --git a/docs/2.0.0/spj_guide/mail-lists.html b/docs/2.0.0/spj_guide/mail-lists.html
new file mode 100644
index 0000000..ddc3b9c
--- /dev/null
+++ b/docs/2.0.0/spj_guide/mail-lists.html
@@ -0,0 +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 at Apr 11, 2016 -->
+<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
+ <head>
+ <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
+ <title>Project Mailing Lists</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="20160411" />
+ <meta http-equiv="Content-Language" content="en" />
+
+ </head>
+ <body class="composite">
+ <div id="banner">
+ <div id="bannerLeft">
+ Trafodion SPJ Guide
+ </div>
+ <div class="clear">
+ <hr/>
+ </div>
+ </div>
+ <div id="breadcrumbs">
+
+
+ <div class="xleft">
+ <span id="publishDate">Last Published: 2016-04-11</span>
+ | <span id="projectVersion">Version: 2.0.0</span>
+ </div>
+ <div class="xright"> <a href="./" title="Trafodion SPJ Guide">Trafodion SPJ 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">
+ <strong>Mailing Lists</strong>
+ </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">
+ <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>Project Mailing Lists<a name="Project_Mailing_Lists"></a></h2><a name="Project_Mailing_Lists"></a><p>These are the mailing lists that have been established for this project. For each list, there is a subscribe, unsubscribe, and an archive link.</p><table border="0" class="bodyTable"><tr class="a"><th>Name</th><th>Subscribe</th><th>Unsubscribe</th><th>Post</th><th>Archive</th></tr><tr class="b"><td>User List</td><td><a class="externalLink" href="mailto:user-subscribe@trafodion.incubator.apache.org">Subscribe</a></td><td><a class="externalLink" href="mailto:user-unsubscribe@trafodion.incubator.apache.org">Unsubscribe</a></td><td><a class="externalLink" href="mailto:user@trafodion.incubator.apache.org">Post</a></td><td><a class="externalLink" href="http://mail-archives.apache.org/mod_mbox/incubator-trafodion-user/">mail-archives.apache.org</a></td></tr><tr class="a"><td>Developer List</td><td><a class="externalLink" href="mailto:dev-subscribe@trafodion.
incubator.apache.org">Subscribe</a></td><td><a class="externalLink" href="mailto:dev-unsubscribe@trafodion.incubator.apache.org">Unsubscribe</a></td><td><a class="externalLink" href="mailto:dev@trafodion.incubator.apache.org">Post</a></td><td><a class="externalLink" href="http://mail-archives.apache.org/mod_mbox/incubator-trafodion-dev/">mail-archives.apache.org</a></td></tr><tr class="b"><td>GitHub Codereview List</td><td><a class="externalLink" href="mailto:codereview-subscribe@trafodion.incubator.apache.org">Subscribe</a></td><td><a class="externalLink" href="mailto:codereview-unsubscribe@trafodion.incubator.apache.org">Unsubscribe</a></td><td>-</td><td><a class="externalLink" href="http://mail-archives.apache.org/mod_mbox/incubator-trafodion-codereview/">mail-archives.apache.org</a></td></tr><tr class="a"><td>Commits List</td><td><a class="externalLink" href="mailto:commits-subscribe@trafodion.incubator.apache.org">Subscribe</a></td><td><a class="externalLink" href="mailto:commi
ts-unsubscribe@trafodion.incubator.apache.org">Unsubscribe</a></td><td>-</td><td><a class="externalLink" href="http://mail-archives.apache.org/mod_mbox/incubator-trafodion-commits/">mail-archives.apache.org</a></td></tr><tr class="b"><td>Issues List</td><td><a class="externalLink" href="mailto:issues-subscribe@trafodion.incubator.apache.org">Subscribe</a></td><td><a class="externalLink" href="mailto:issues-unsubscribe@trafodion.incubator.apache.org">Unsubscribe</a></td><td>-</td><td><a class="externalLink" href="http://mail-archives.apache.org/mod_mbox/incubator-trafodion-issues/">mail-archives.apache.org</a></td></tr></table></div>
+ </div>
+ </div>
+ <div class="clear">
+ <hr/>
+ </div>
+ <div id="footer">
+ <div class="xright">
+ Copyright © 2015-2016
+ <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/11567d60/docs/2.0.0/spj_guide/project-info.html
----------------------------------------------------------------------
diff --git a/docs/2.0.0/spj_guide/project-info.html b/docs/2.0.0/spj_guide/project-info.html
new file mode 100644
index 0000000..7b346ff
--- /dev/null
+++ b/docs/2.0.0/spj_guide/project-info.html
@@ -0,0 +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 at Apr 11, 2016 -->
+<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
+ <head>
+ <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
+ <title>Project Information</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="20160411" />
+ <meta http-equiv="Content-Language" content="en" />
+
+ </head>
+ <body class="composite">
+ <div id="banner">
+ <div id="bannerLeft">
+ Trafodion SPJ Guide
+ </div>
+ <div class="clear">
+ <hr/>
+ </div>
+ </div>
+ <div id="breadcrumbs">
+
+
+ <div class="xleft">
+ <span id="publishDate">Last Published: 2016-04-11</span>
+ | <span id="projectVersion">Version: 2.0.0</span>
+ </div>
+ <div class="xright"> <a href="./" title="Trafodion SPJ Guide">Trafodion SPJ 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">
+ <strong>Project Information</strong>
+ <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">
+ <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>Project Information<a name="Project_Information"></a></h2><p>This document provides an overview of the various documents and links that are part of this project's general information. All of this content is automatically generated by <a class="externalLink" href="http://maven.apache.org">Maven</a> on behalf of the project.</p><div class="section"><h3>Overview<a name="Overview"></a></h3><table border="0" class="bodyTable"><tr class="a"><th>Document</th><th>Description</th></tr><tr class="b"><td><a href="team-list.html">Project Team</a></td><td>This document provides information on the members of this project. These are the individuals who have contributed to the project in one form or another.</td></tr><tr class="a"><td><a href="mail-lists.html">Mailing Lists</a></td><td>This document provides subscription and archive information for this project's mailing lists.</td></tr><tr class="b"><td><a href="issue-tracking.html">Issue Tracking</a></td><td>This
document provides information on the issue management system used in this project.</td></tr><tr class="a"><td><a href="license.html">Project License</a></td><td>This document lists the project license(s).</td></tr><tr class="b"><td><a href="project-summary.html">Project Summary</a></td><td>This document lists other related information of this project</td></tr><tr class="a"><td><a href="source-repository.html">Source Repository</a></td><td>This document lists ways to access the online source repository.</td></tr><tr class="b"><td><a href="integration.html">Continuous Integration</a></td><td>This is a link to the definitions of all continuous integration processes that builds and tests code on a frequent, regular basis.</td></tr><tr class="a"><td><a href="dependencies.html">Dependencies</a></td><td>This document lists the project's dependencies and provides information on each dependency.</td></tr></table></div></div>
+ </div>
+ </div>
+ <div class="clear">
+ <hr/>
+ </div>
+ <div id="footer">
+ <div class="xright">
+ Copyright © 2015-2016
+ <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/11567d60/docs/2.0.0/spj_guide/project-summary.html
----------------------------------------------------------------------
diff --git a/docs/2.0.0/spj_guide/project-summary.html b/docs/2.0.0/spj_guide/project-summary.html
new file mode 100644
index 0000000..5162965
--- /dev/null
+++ b/docs/2.0.0/spj_guide/project-summary.html
@@ -0,0 +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 at Apr 11, 2016 -->
+<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
+ <head>
+ <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
+ <title>Project Summary</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="20160411" />
+ <meta http-equiv="Content-Language" content="en" />
+
+ </head>
+ <body class="composite">
+ <div id="banner">
+ <div id="bannerLeft">
+ Trafodion SPJ Guide
+ </div>
+ <div class="clear">
+ <hr/>
+ </div>
+ </div>
+ <div id="breadcrumbs">
+
+
+ <div class="xleft">
+ <span id="publishDate">Last Published: 2016-04-11</span>
+ | <span id="projectVersion">Version: 2.0.0</span>
+ </div>
+ <div class="xright"> <a href="./" title="Trafodion SPJ Guide">Trafodion SPJ 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">
+ <strong>Project Summary</strong>
+ </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">
+ <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>Project Summary<a name="Project_Summary"></a></h2><a name="Project_Summary"></a><div class="section"><h3>Project Information<a name="Project_Information"></a></h3><a name="Project_Information"></a><table border="0" class="bodyTable"><tr class="a"><th>Field</th><th>Value</th></tr><tr class="b"><td>Name</td><td>Trafodion SPJ Guide</td></tr><tr class="a"><td>Description</td><td>This guide describes how to develop, deploy, and manage Stored Procedures in Java (SPJs) on the Trafodion database.</td></tr><tr class="b"><td>Homepage</td><td><a class="externalLink" href="http://trafodion.incubator.apache.org">http://trafodion.incubator.apache.org</a></td></tr></table></div><div class="section"><h3>Project Organization<a name="Project_Organization"></a></h3><a name="Project_Organization"></a><table border="0" class="bodyTable"><tr class="a"><th>Field</th><th>Value</th></tr><tr class="b"><td>Name</td><td>Apache Software Foundation</td></tr><tr class="a"><td>URL<
/td><td><a class="externalLink" href="http://www.apache.org">http://www.apache.org</a></td></tr></table></div><div class="section"><h3>Build Information<a name="Build_Information"></a></h3><a name="Build_Information"></a><table border="0" class="bodyTable"><tr class="a"><th>Field</th><th>Value</th></tr><tr class="b"><td>GroupId</td><td>org.apache.trafodion</td></tr><tr class="a"><td>ArtifactId</td><td>spj-guide</td></tr><tr class="b"><td>Version</td><td>2.0.0</td></tr><tr class="a"><td>Type</td><td>pom</td></tr></table></div></div>
+ </div>
+ </div>
+ <div class="clear">
+ <hr/>
+ </div>
+ <div id="footer">
+ <div class="xright">
+ Copyright © 2015-2016
+ <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/11567d60/docs/2.0.0/spj_guide/resources/acknowledgements.txt
----------------------------------------------------------------------
diff --git a/docs/2.0.0/spj_guide/resources/acknowledgements.txt b/docs/2.0.0/spj_guide/resources/acknowledgements.txt
new file mode 100644
index 0000000..c395596
--- /dev/null
+++ b/docs/2.0.0/spj_guide/resources/acknowledgements.txt
@@ -0,0 +1,38 @@
+*Acknowledgements*
+
+Microsoft®, Windows®, Windows NT®, Windows® XP, and Windows Vista® are
+U.S. registered trademarks of Microsoft Corporation. Intel® and Intel®
+Itanium® are trademarks of Intel Corporation in the U.S. and other
+countries. Java® is a registered trademark of Oracle and/or its
+affiliates. Motif, OSF/1, UNIX®, X/Open®, and the X device is a
+trademark of X/Open Company Ltd. in the UK and other countries.
+
+OSF, OSF/1, OSF/Motif, Motif, and Open Software Foundation are trademarks of
+the Open Software Foundation in the U.S. and other countries.
+© 1990, 1991, 1992, 1993 Open Software Foundation, Inc.
+
+The OSF documentation and the OSF software to which it relates are derived in
+part from materials supplied by the following: © 1987, 1988, 1989
+Carnegie-Mellon University. © 1989, 1990, 1991 Digital Equipment
+Corporation. © 1985, 1988, 1989, 1990 Encore Computer Corporation. © 1988 Free
+Software Foundation, Inc. © 1987, 1988, 1989, 1990, 1991 Hewlett-Packard
+Company. © 1985, 1987, 1988, 1989, 1990, 1991, 1992 International
+Business Machines Corporation. © 1988, 1989 Massachusetts Institute of
+Technology. © 1988, 1989, 1990 Mentat Inc. © 1988 Microsoft Corporation.
+© 1987, 1988, 1989, 1990, 1991,
+1992 SecureWare, Inc. © 1990, 1991 Siemens Nixdorf Informations systeme
+AG. © 1986, 1989, 1996, 1997 Sun Microsystems, Inc. © 1989, 1990, 1991
+Transarc Corporation.
+
+OSF software and documentation are based in part
+on the Fourth Berkeley Software Distribution under license from The
+Regents of the University of California. OSF acknowledges the following
+individuals and institutions for their role in its development: Kenneth
+C.R.C. Arnold, Gregory S. Couch, Conrad C. Huang, Ed James, Symmetric
+Computer Systems, Robert Elz. © 1980, 1981, 1982, 1983, 1985, 1986,
+1987, 1988, 1989 Regents of the University of California. OSF MAKES NO
+WARRANTY OF ANY KIND WITH REGARD TO THE OSF MATERIAL PROVIDED HEREIN,
+INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY
+AND FITNESS FOR A PARTICULAR PURPOSE. OSF shall not be liable for errors
+contained herein or for incidental consequential damages in connection
+with the furnishing, performance, or use of this material.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/11567d60/docs/2.0.0/spj_guide/resources/source/Inventory.java
----------------------------------------------------------------------
diff --git a/docs/2.0.0/spj_guide/resources/source/Inventory.java b/docs/2.0.0/spj_guide/resources/source/Inventory.java
new file mode 100644
index 0000000..76c5359
--- /dev/null
+++ b/docs/2.0.0/spj_guide/resources/source/Inventory.java
@@ -0,0 +1,120 @@
+import java.sql.* ;
+import java.math.* ;
+
+public class Inventory
+{
+ // The SUPPLIERINFO procedure accepts a supplier number and returns the
+ // supplier's name, street, city, state, and post code to separate output
+ // parameters.
+ //
+ // See http://trafodion.incubator.apache.org/docs/spj_guide/index.html#supplierinfo-procedure
+ // for more documentation.
+ public static void supplierInfo( BigDecimal suppNum
+ , String[] suppName
+ , String[] streetAddr
+ , String[] cityName
+ , String[] stateName
+ , String[] postCode
+ ) throws SQLException
+ {
+ Connection conn =
+ DriverManager.getConnection( "jdbc:default:connection" ) ;
+
+ PreparedStatement getSupplier =
+ conn.prepareStatement( "SELECT suppname, street, city, "
+ + " state, postcode "
+ + "FROM trafodion.invent.supplier "
+ + "WHERE suppnum = ?"
+ ) ;
+
+ getSupplier.setBigDecimal( 1, suppNum ) ;
+ ResultSet rs = getSupplier.executeQuery() ;
+ rs.next() ;
+
+ suppName[0] = rs.getString( 1 ) ;
+ streetAddr[0] = rs.getString( 2 ) ;
+ cityName[0] = rs.getString( 3 ) ;
+ stateName[0] = rs.getString( 4 ) ;
+ postCode[0] = rs.getString( 5 ) ;
+
+ rs.close() ;
+ conn.close() ;
+
+ }
+
+ // The SUPPLYQUANTITIES procedure returns the average, minimum, and maximum
+ // quantities of available parts in inventory to separate output
+ // parameters.
+ //
+ // See http://trafodion.incubator.apache.org/docs/spj_guide/index.html#supplyquantities-procedure
+ // for more documentation.
+ public static void supplyQuantities( int[] avgQty
+ , int[] minQty
+ , int[] maxQty
+ ) throws SQLException
+ {
+ Connection conn =
+ DriverManager.getConnection( "jdbc:default:connection" ) ;
+
+ PreparedStatement getQty =
+ conn.prepareStatement( "SELECT AVG(qty_on_hand), "
+ + " MIN(qty_on_hand), "
+ + " MAX(qty_on_hand) "
+ + "FROM trafodion.invent.partloc"
+ ) ;
+
+ ResultSet rs = getQty.executeQuery() ;
+ rs.next() ;
+
+ avgQty[0] = rs.getInt( 1 ) ;
+ minQty[0] = rs.getInt( 2 ) ;
+ maxQty[0] = rs.getInt( 3 ) ;
+
+ rs.close() ;
+ conn.close() ;
+
+ }
+
+ // The PARTLOCATIONS procedure accepts a part number and quantity and returns a
+ // set of location codes that have the exact quantity and a set of location
+ // codes that have more than that quantity.
+ //
+ // See http://trafodion.incubator.apache.org/docs/spj_guide/index.html#partlocations-procedure
+ // for more documentation.
+ public static void partLocations( int partNum
+ , int quantity
+ , ResultSet exactly[]
+ , ResultSet moreThan[]
+ ) throws SQLException
+
+ {
+ Connection conn =
+ DriverManager.getConnection( "jdbc:default:connection" ) ;
+
+ PreparedStatement getLocationsExact =
+ conn.prepareStatement( "SELECT L.loc_code, L.partnum, L.qty_on_hand "
+ + "FROM trafodion.invent.partloc L "
+ + "WHERE L.partnum = ? "
+ + " AND L.qty_on_hand = ? "
+ + " ORDER BY L.partnum "
+ ) ;
+
+ getLocationsExact.setInt( 1, partNum ) ;
+ getLocationsExact.setInt( 2, quantity) ;
+
+ PreparedStatement getLocationsMoreThan =
+ conn.prepareStatement( "SELECT L.loc_code, L.partnum, L.qty_on_hand "
+ + "FROM trafodion.invent.partloc L "
+ + "WHERE L.partnum = ? "
+ + " AND L.qty_on_hand > ? "
+ + "ORDER BY L.partnum "
+ ) ;
+
+ getLocationsMoreThan.setInt( 1, partNum ) ;
+ getLocationsMoreThan.setInt( 2, quantity) ;
+
+ exactly[0] = getLocationsExact.executeQuery() ;
+ moreThan[0] = getLocationsMoreThan.executeQuery() ;
+
+ }
+}
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/11567d60/docs/2.0.0/spj_guide/resources/source/Payroll.java
----------------------------------------------------------------------
diff --git a/docs/2.0.0/spj_guide/resources/source/Payroll.java b/docs/2.0.0/spj_guide/resources/source/Payroll.java
new file mode 100644
index 0000000..89c28a5
--- /dev/null
+++ b/docs/2.0.0/spj_guide/resources/source/Payroll.java
@@ -0,0 +1,151 @@
+import java.sql.* ;
+import java.math.* ;
+
+public class Payroll
+{
+ // The ADJUSTSALARY procedure accepts an employee number and a percentage
+ // value and updates the employee's salary in the database based on that
+ // percentage. This method also returns the updated salary to an output
+ // parameter.
+ //
+ // See http://trafodion.incubator.apache.org/docs/spj_guide/index.html#adjustsalary-procedure
+ // for more documentation.
+ public static void adjustSalary( BigDecimal empNum
+ , double percent
+ , BigDecimal[] newSalary
+ ) throws SQLException
+ {
+ Connection conn =
+ DriverManager.getConnection( "jdbc:default:connection" ) ;
+
+ PreparedStatement setSalary =
+ conn.prepareStatement( "UPDATE trafodion.persnl.employee "
+ + "SET salary = salary * (1 + (? / 100)) "
+ + "WHERE empnum = ?"
+ ) ;
+
+ PreparedStatement getSalary =
+ conn.prepareStatement( "SELECT salary "
+ + "FROM trafodion.persnl.employee "
+ + "WHERE empnum = ?"
+ ) ;
+
+ setSalary.setDouble( 1, percent ) ;
+ setSalary.setBigDecimal( 2, empNum ) ;
+ setSalary.executeUpdate() ;
+
+ getSalary.setBigDecimal( 1, empNum ) ;
+ ResultSet rs = getSalary.executeQuery() ;
+ rs.next() ;
+
+ newSalary[0] = rs.getBigDecimal( 1 ) ;
+
+ rs.close() ;
+ conn.close() ;
+
+ }
+
+ // The EMPLOYEEJOB procedure accepts an employee number and returns a job
+ // code or null value to an output parameter.
+ //
+ // See http://trafodion.incubator.apache.org/docs/spj_guide/index.html#employeejob-procedure
+ // for more documentation.
+ public static void employeeJob( int empNum
+ , java.lang.Integer[] jobCode
+ ) throws SQLException
+ {
+ Connection conn =
+ DriverManager.getConnection( "jdbc:default:connection" ) ;
+
+ PreparedStatement getJobcode =
+ conn.prepareStatement( "SELECT jobcode "
+ + "FROM trafodion.persnl.employee "
+ + "WHERE empnum = ?"
+ ) ;
+
+ getJobcode.setInt( 1, empNum ) ;
+ ResultSet rs = getJobcode.executeQuery() ;
+ rs.next() ;
+
+ int num = rs.getInt(1) ;
+ if ( rs.wasNull() )
+ jobCode[0] = null ;
+ else
+ jobCode[0] = new Integer(num) ;
+
+ rs.close() ;
+ conn.close() ;
+
+ }
+
+ // The PROJECTTEAM procedure accepts a project code and returns the
+ // employee number, first name, last name, and location of the employees
+ // assigned to that project.
+ //
+ // See http://trafodion.incubator.apache.org/docs/spj_guide/index.html#projectteam-procedure
+ // for more documentation.
+ public static void projectTeam( int projectCode
+ , ResultSet[] members
+ ) throws SQLException
+ {
+ Connection conn =
+ DriverManager.getConnection( "jdbc:default:connection" ) ;
+
+ PreparedStatement getMembers =
+ conn.prepareStatement( "SELECT E.empnum, E.first_name, E.last_name, D.location "
+ + "FROM trafodion.persnl.employee E, trafodion.persnl.dept D, trafodion.persnl.project P "
+ + "WHERE P.projcode = ? "
+ + " AND P.empnum = E.empnum "
+ + " AND E.deptnum = D.deptnum "
+ ) ;
+
+ getMembers.setInt( 1, projectCode ) ;
+ members[0] = getMembers.executeQuery() ;
+
+ }
+
+ // The TOPSALESREPS procedure accepts a number representing the fiscal
+ // quarter (1, 2, 3, and 4, with each number representing a range of
+ // months) and returns the employee number, first name, last name, and sale
+ // figures of the top five sales representatives who had the highest sales
+ // (unit_price * qty_ordered) that quarter.
+ //
+ // See http://trafodion.incubator.apache.org/docs/spj_guide/index.html#topsalesreps-procedure
+ // for more documentation.
+ public static void topSalesReps( int whichQuarter
+ , ResultSet[] topReps
+ ) throws SQLException
+ {
+ if ( whichQuarter < 1 || whichQuarter > 4 )
+ {
+ throw new SQLException ( "Invalid value for quarter. "
+ + "Retry the CALL statement "
+ + "using a number from 1 to 4 "
+ + "to represent the quarter."
+ , "38001"
+ ) ;
+ }
+
+ Connection conn =
+ DriverManager.getConnection( "jdbc:default:connection" ) ;
+
+ PreparedStatement getTopReps =
+ conn.prepareStatement( "SELECT [first 5] e.empnum, e.first_name, "
+ + "e.last_name, totals.total "
+ + "FROM trafodion.persnl.employee e, "
+ + " ( SELECT o.salesrep, "
+ + " SUM( od.unit_price * od.qty_ordered ) as total "
+ + " FROM trafodion.sales.orders o, trafodion.sales.odetail od "
+ + " WHERE o.ordernum = od.ordernum "
+ + " AND QUARTER( o.order_date ) = ? "
+ + " GROUP BY o.salesrep "
+ + " ) totals "
+ + "WHERE e.empnum = totals.salesrep "
+ + "ORDER BY totals.total DESCENDING "
+ ) ;
+
+ getTopReps.setInt( 1, whichQuarter ) ;
+ topReps[0] = getTopReps.executeQuery() ;
+
+ }
+}
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/11567d60/docs/2.0.0/spj_guide/resources/source/Sales.java
----------------------------------------------------------------------
diff --git a/docs/2.0.0/spj_guide/resources/source/Sales.java b/docs/2.0.0/spj_guide/resources/source/Sales.java
new file mode 100644
index 0000000..fd47df8
--- /dev/null
+++ b/docs/2.0.0/spj_guide/resources/source/Sales.java
@@ -0,0 +1,346 @@
+import java.sql.* ;
+import java.math.* ;
+
+public class Sales
+{
+ // The LOWERPRICE procedure determines which items are selling poorly (that
+ // is, have less than 50 orders) and lowers the price of these items in the
+ // database by 10 percent.
+ //
+ // See http://trafodion.incubator.apache.org/docs/spj_guide/index.html#lowerprice-procedure
+ // for more documentation.
+ public static void lowerPrice() throws SQLException
+ {
+ Connection conn =
+ DriverManager.getConnection( "jdbc:default:connection" ) ;
+
+ PreparedStatement getParts =
+ conn.prepareStatement( "SELECT p.partnum, "
+ + "SUM(qty_ordered) AS qtyOrdered "
+ + "FROM trafodion.sales.parts p "
+ + "LEFT JOIN trafodion.sales.odetail o "
+ + "ON p.partnum = o.partnum "
+ + "GROUP BY p.partnum"
+ ) ;
+
+ PreparedStatement updateParts =
+ conn.prepareStatement( "UPDATE trafodion.sales.parts "
+ + "SET price = price * 0.9 "
+ + "WHERE partnum = ?"
+ ) ;
+
+ ResultSet rs = getParts.executeQuery() ;
+ while ( rs.next() )
+ {
+ BigDecimal qtyOrdered = rs.getBigDecimal( 2 ) ;
+
+ if (( qtyOrdered == null ) || ( qtyOrdered.intValue() < 50 ) )
+ {
+ BigDecimal partnum = rs.getBigDecimal( 1 ) ;
+ updateParts.setBigDecimal( 1, partnum ) ;
+ updateParts.executeUpdate() ;
+ }
+ }
+
+ rs.close() ;
+ conn.close() ;
+
+ }
+
+ // The DAILYORDERS procedure accepts a date and returns the number of
+ //orders on that date to an output parameter.
+ //
+ // See http://trafodion.incubator.apache.org/docs/spj_guide/index.html#dailyorders-procedure
+ // for additional documenation.
+ public static void numDailyOrders( Date date
+ , int[] numOrders
+ ) throws SQLException
+ {
+ Connection conn =
+ DriverManager.getConnection( "jdbc:default:connection" ) ;
+
+ PreparedStatement getNumOrders =
+ conn.prepareStatement( "SELECT COUNT(order_date) "
+ + "FROM trafodion.sales.orders "
+ + "WHERE order_date = ?"
+ ) ;
+
+ getNumOrders.setDate( 1, date ) ;
+
+ ResultSet rs = getNumOrders.executeQuery() ;
+ rs.next() ;
+
+ numOrders[0] = rs.getInt( 1 ) ;
+
+ rs.close() ;
+ conn.close() ;
+
+ }
+
+ // The MONTHLYORDERS procedure accepts an integer representing the month
+ // and returns the number of orders during that month to an output parameter.
+ //
+ // See http://trafodion.incubator.apache.org/docs/spj_guide/index.html#monthlyorders-procedure
+ // for more documentation.
+ public static void numMonthlyOrders( int month
+ , int[] numOrders
+ ) throws SQLException
+
+ {
+ if ( month < 1 || month > 12 )
+ {
+ throw new SQLException( "Invalid value for month. "
+ + "Retry the CALL statement "
+ + "using a number from 1 to 12 "
+ + "to represent the month."
+ , "38001"
+ ) ;
+ }
+
+ Connection conn =
+ DriverManager.getConnection( "jdbc:default:connection" ) ;
+
+ PreparedStatement getNumOrders =
+ conn.prepareStatement( "SELECT COUNT( month( order_date ) ) "
+ + "FROM trafodion.sales.orders "
+ + "WHERE month( order_date ) = ?"
+ ) ;
+
+ getNumOrders.setInt( 1, month ) ;
+
+ ResultSet rs = getNumOrders.executeQuery() ;
+ rs.next() ;
+
+ numOrders[0] = rs.getInt(1) ;
+
+ rs.close() ;
+ conn.close();
+
+ }
+
+ // The TOTALPRICE procedure accepts the quantity, shipping speed, and price
+ // of an item, calculates the total price, including tax and shipping
+ // charges, and returns the total price to an input/output parameter.
+ //
+ // See http://trafodion.incubator.apache.org/docs/spj_guide/index.html#totalprice-procedure
+ // for more documentation.
+ public static void totalPrice( BigDecimal qtyOrdered
+ , String shippingSpeed
+ , BigDecimal[] price
+ ) throws SQLException
+ {
+ BigDecimal shipcharge = new BigDecimal( 0 ) ;
+
+ if ( shippingSpeed.equals( "economy" ) )
+ {
+ shipcharge = new BigDecimal( 1.95 ) ;
+ }
+ else if ( shippingSpeed.equals( "standard" ) )
+ {
+ shipcharge = new BigDecimal( 4.99 ) ;
+ }
+ else if ( shippingSpeed.equals( "nextday" ) )
+ {
+ shipcharge = new BigDecimal( 14.99 ) ;
+ }
+ else
+ {
+ throw new SQLException( "Invalid value for shipping speed. "
+ + "Retry the CALL statement using "
+ + "'economy' for 7 to 9 days, "
+ + "'standard' for 3 to 5 days, or "
+ + "'nextday' for one day."
+ , "38002"
+ ) ;
+ }
+
+ BigDecimal subtotal = price[0].multiply( qtyOrdered ) ;
+ BigDecimal tax = new BigDecimal( 0.0825 ) ;
+ BigDecimal taxcharge = subtotal.multiply( tax ) ;
+ BigDecimal charges = taxcharge.add( shipcharge ) ;
+ BigDecimal totalprice = subtotal.add( charges ) ;
+
+ totalprice = totalprice.setScale( 2, BigDecimal.ROUND_HALF_EVEN ) ;
+ price[0] = totalprice ;
+
+ }
+
+ // The PARTDATA procedure accepts a part number and returns this
+ // information about the part:
+ //
+ // * Part description, price, and quantity available as output parameters.
+ // * A result set that contains rows from the ORDERS table about when this part was ordered.
+ // * A result set that contains rows from the PARTLOC table, listing locations that have this
+ // part in stock and the quantity they have on hand.
+ // * A result set that contains rows from the PARTSUPP table for suppliers who carry this part.
+ // * A result set that contains rows from the EMPLOYEE table for sales reps who have sold this part.
+ //
+ // See http://trafodion.incubator.apache.org/docs/spj_guide/index.html#partdata-procedure
+ // for more documentation.
+ public static void partData( int partNum
+ , String[] partDescription
+ , BigDecimal[] unitPrice
+ , int[] qtyAvailable
+ , ResultSet[] orders
+ , ResultSet[] locations
+ , ResultSet[] suppliers
+ , ResultSet[] reps
+ ) throws SQLException
+ {
+
+ Connection conn =
+ DriverManager.getConnection( "jdbc:default:connection" ) ;
+
+ // Retrieve detail about this part into the output parameters
+ PreparedStatement getPartInfo =
+ conn.prepareStatement( "SELECT P.partdesc, P.price, P.qty_available "
+ + "FROM trafodion.sales.parts P "
+ + "WHERE partnum = ? "
+ ) ;
+
+ getPartInfo.setInt( 1, partNum ) ;
+
+ ResultSet rs = getPartInfo.executeQuery() ;
+ rs.next() ;
+
+ partDescription[0] = rs.getString( 1 ) ;
+ unitPrice[0] = rs.getBigDecimal( 2 ) ;
+ qtyAvailable[0] = rs.getInt( 3 ) ;
+
+ rs.close();
+
+ // Return a result set of rows from the ORDERS table listing orders
+ // that included this part. Each ORDERS row is augmented with the
+ // quantity of this part that was ordered.
+ PreparedStatement getOrders =
+ conn.prepareStatement( "SELECT O.*, QTY.QTY_ORDERED "
+ + "FROM trafodion.sales.orders O "
+ + " , ( select ordernum, sum(qty_ordered) as QTY_ORDERED "
+ + " from trafodion.sales.odetail "
+ + " where partnum = ? "
+ + " group by ordernum ) QTY "
+ + "WHERE O.ordernum = QTY.ordernum "
+ + "ORDER BY O.ordernum "
+ ) ;
+
+
+ getOrders.setInt( 1, partNum ) ;
+ orders[0] = getOrders.executeQuery() ;
+
+ // Return a result set of rows from the PARTLOC table listing
+ // locations that have this part in stock and the quantity they
+ // have on hand.
+ PreparedStatement getLocations =
+ conn.prepareStatement( "SELECT * "
+ + "FROM trafodion.invent.partloc "
+ + " WHERE partnum = ? "
+ ) ;
+
+ getLocations.setInt( 1, partNum ) ;
+ locations[0] = getLocations.executeQuery() ;
+
+ // Return a result set of rows from the PARTSUPP table listing
+ // suppliers who supply this part.
+ PreparedStatement getSuppliers =
+ conn.prepareStatement( "SELECT * "
+ + "FROM trafodion.invent.partsupp "
+ + "WHERE partnum = ? "
+ ) ;
+
+ getSuppliers.setInt( 1, partNum ) ;
+ suppliers[0] = getSuppliers.executeQuery() ;
+
+ // Return a result set of rows from the EMPLOYEE table listing
+ // sales reps that have sold this part.
+ PreparedStatement getReps =
+ conn.prepareStatement( "SELECT * "
+ + "FROM trafodion.persnl.employee "
+ + "WHERE empnum in ( SELECT O.salesrep "
+ + " FROM trafodion.sales.orders O, "
+ + " trafodion.sales.odetail D "
+ + " WHERE D.partnum = ? "
+ + " AND O.ordernum = D.ordernum ) "
+ + "ORDER BY empnum "
+ ) ;
+
+ getReps.setInt( 1, partNum ) ;
+ reps[0] = getReps.executeQuery() ;
+
+ }
+
+ // The ORDERSUMMARY procedure accepts a date, which is formatted as a
+ // string, and returns this information about the orders on or after that
+ // date:
+ //
+ // * The number of orders as an output parameter
+ // * A result set that contains one row for each order. Each row contains
+ // fields for the order number, the number of parts ordered, total dollar
+ // amount, order date, and the name of the sales representative.
+ // * A result set that contains details about each order. Each order has
+ // one or more rows that provide details about the ordered parts. Each row
+ // contains fields for the order number, part number, unit price, quantity
+ // ordered, and part description.
+ //
+ // See http://trafodion.incubator.apache.org/docs/spj_guide/index.html#ordersummary-procedure
+ // for more documentation.
+ public static void orderSummary( java.lang.String onOrAfter
+ , long[] numOrders
+ , java.sql.ResultSet[] orders
+ , java.sql.ResultSet[] detail
+ ) throws SQLException
+ {
+ java.lang.String s ;
+
+ java.sql.Connection conn =
+ DriverManager.getConnection( "jdbc:default:connection" ) ;
+
+ // Get the number of orders on or after this date
+ s = "SELECT COUNT(ordernum) FROM trafodion.sales.orders "
+ + "WHERE order_date >= CAST(? AS DATE) "
+ ;
+
+ java.sql.PreparedStatement ps1 = conn.prepareStatement( s ) ;
+ ps1.setString( 1, onOrAfter ) ;
+
+ java.sql.ResultSet rs = ps1.executeQuery() ;
+ rs.next() ;
+
+ numOrders[0] = rs.getLong( 1 ) ;
+ rs.close() ;
+
+ // Open a result set for order num, order info rows
+ s = "SELECT amounts.*, orders.order_date, emps.last_name "
+ + "FROM ( SELECT "
+ + " o.ordernum "
+ + " , COUNT(d.partnum) AS num_parts "
+ + " , SUM(d.unit_price * d.qty_ordered) AS amount "
+ + " FROM trafodion.sales.orders o, trafodion.sales.odetail d "
+ + " WHERE o.ordernum = d.ordernum "
+ + " AND o.order_date >= CAST(? AS DATE) "
+ + " GROUP BY o.ordernum "
+ + " ) amounts "
+ + " , trafodion.sales.orders orders "
+ + " , trafodion.persnl.employee emps "
+ + "WHERE amounts.ordernum = orders.ordernum "
+ + " AND orders.salesrep = emps.empnum "
+ + "ORDER BY orders.ordernum "
+ ;
+
+ java.sql.PreparedStatement ps2 = conn.prepareStatement( s ) ;
+ ps2.setString( 1, onOrAfter ) ;
+ orders[0] = ps2.executeQuery() ;
+
+ // Open a result set for order detail rows
+ s = "SELECT d.*, p.partdesc "
+ + "FROM trafodion.sales.odetail d, trafodion.sales.parts p, trafodion.sales.orders O "
+ + "WHERE d.partnum = p.partnum AND d.ordernum = o.ordernum "
+ + " AND o.order_date >= CAST(? AS DATE) "
+ + "ORDER BY d.ordernum "
+ ;
+
+ java.sql.PreparedStatement ps3 = conn.prepareStatement( s ) ;
+ ps3.setString( 1, onOrAfter ) ;
+ detail[0] = ps3.executeQuery() ;
+
+ }
+}
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/11567d60/docs/2.0.0/spj_guide/resources/source/adjustSalary.java
----------------------------------------------------------------------
diff --git a/docs/2.0.0/spj_guide/resources/source/adjustSalary.java b/docs/2.0.0/spj_guide/resources/source/adjustSalary.java
new file mode 100644
index 0000000..cc2b095
--- /dev/null
+++ b/docs/2.0.0/spj_guide/resources/source/adjustSalary.java
@@ -0,0 +1,41 @@
+// The ADJUSTSALARY procedure accepts an employee number and a percentage
+// value and updates the employee's salary in the database based on that
+// percentage. This method also returns the updated salary to an output
+// parameter.
+//
+// See http://trafodion.incubator.apache.org/docs/spj_guide/index.html#adjustsalary-procedure
+// for more documentation.
+public static void adjustSalary( BigDecimal empNum
+ , double percent
+ , BigDecimal[] newSalary
+ ) throws SQLException
+{
+ Connection conn =
+ DriverManager.getConnection( "jdbc:default:connection" ) ;
+
+ PreparedStatement setSalary =
+ conn.prepareStatement( "UPDATE trafodion.persnl.employee "
+ + "SET salary = salary * (1 + (? / 100)) "
+ + "WHERE empnum = ?"
+ ) ;
+
+ PreparedStatement getSalary =
+ conn.prepareStatement( "SELECT salary "
+ + "FROM trafodion.persnl.employee "
+ + "WHERE empnum = ?"
+ ) ;
+
+ setSalary.setDouble( 1, percent ) ;
+ setSalary.setBigDecimal( 2, empNum ) ;
+ setSalary.executeUpdate() ;
+
+ getSalary.setBigDecimal( 1, empNum ) ;
+ ResultSet rs = getSalary.executeQuery() ;
+ rs.next() ;
+
+ newSalary[0] = rs.getBigDecimal( 1 ) ;
+
+ rs.close() ;
+ conn.close() ;
+
+}
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/11567d60/docs/2.0.0/spj_guide/resources/source/employeeJob.java
----------------------------------------------------------------------
diff --git a/docs/2.0.0/spj_guide/resources/source/employeeJob.java b/docs/2.0.0/spj_guide/resources/source/employeeJob.java
new file mode 100644
index 0000000..ce5cdab
--- /dev/null
+++ b/docs/2.0.0/spj_guide/resources/source/employeeJob.java
@@ -0,0 +1,32 @@
+// The EMPLOYEEJOB procedure accepts an employee number and returns a job
+// code or null value to an output parameter.
+//
+// See http://trafodion.incubator.apache.org/docs/spj_guide/index.html#employeejob-procedure
+// for more documentation.
+public static void employeeJob( int empNum
+ , java.lang.Integer[] jobCode
+ ) throws SQLException
+{
+ Connection conn =
+ DriverManager.getConnection( "jdbc:default:connection" ) ;
+
+ PreparedStatement getJobcode =
+ conn.prepareStatement( "SELECT jobcode "
+ + "FROM trafodion.persnl.employee "
+ + "WHERE empnum = ?"
+ ) ;
+
+ getJobcode.setInt( 1, empNum ) ;
+ ResultSet rs = getJobcode.executeQuery() ;
+ rs.next() ;
+
+ int num = rs.getInt(1) ;
+ if ( rs.wasNull() )
+ jobCode[0] = null ;
+ else
+ jobCode[0] = new Integer(num) ;
+
+ rs.close() ;
+ conn.close() ;
+
+}
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/11567d60/docs/2.0.0/spj_guide/resources/source/invent_partloc_table.sql
----------------------------------------------------------------------
diff --git a/docs/2.0.0/spj_guide/resources/source/invent_partloc_table.sql b/docs/2.0.0/spj_guide/resources/source/invent_partloc_table.sql
new file mode 100644
index 0000000..6268f7f
--- /dev/null
+++ b/docs/2.0.0/spj_guide/resources/source/invent_partloc_table.sql
@@ -0,0 +1,56 @@
+CREATE TABLE trafodion.invent.partloc
+( loc_code CHARACTER (3) NO DEFAULT NOT NULL
+, partnum NUMERIC (4) UNSIGNED NO DEFAULT NOT NULL
+, qty_on_hand NUMERIC (7) DEFAULT 0 NOT NULL
+, PRIMARY KEY ( loc_code, partnum )
+) ;
+
+INSERT INTO trafodion.invent.partloc VALUES
+ ( 'A10', 2001, 800 )
+, ( 'A21', 255, 21 )
+, ( 'A34', 6201, 0 )
+, ( 'A35', 6301, 0 )
+, ( 'A36', 6400, 34 )
+, ( 'A66', 6603, 300 )
+, ( 'A67', 6401, 454 )
+, ( 'A78', 244, 43 )
+, ( 'A78', 5505, 100 )
+, ( 'A87', 212, 18 )
+, ( 'A88', 2403, 735 )
+, ( 'A88', 5504, 30 )
+, ( 'A94', 3205, 200 )
+, ( 'A98', 5110, 510 )
+, ( 'G11', 2002, 20 )
+, ( 'G34', 6201, 106 )
+, ( 'G35', 6301, 331 )
+, ( 'G36', 6400, 1034 )
+, ( 'G43', 5100, 77 )
+, ( 'G45', 4102, 69 )
+, ( 'G65', 3201, 36 )
+, ( 'G68', 6500, 1132 )
+, ( 'G76', 2405, 42 )
+, ( 'G76', 7301, 32 )
+, ( 'G78', 5505, 0 )
+, ( 'G87', 212, 20 )
+, ( 'G87', 3103, 0 )
+, ( 'G87', 3210, 44 )
+, ( 'G87', 2402, 0 )
+, ( 'G88', 2403, 32 )
+, ( 'G88', 5504, 0 )
+, ( 'G89', 5101, 86 )
+, ( 'G94', 3205, 59 )
+, ( 'G98', 5103, 28 )
+, ( 'G98', 5110, 136 )
+, ( 'P10', 2001, 0 )
+, ( 'P12', 2002, 200 )
+, ( 'P12', 2003, 0 )
+, ( 'P15', 2003, 200 )
+, ( 'P66', 6603, 40 )
+, ( 'P67', 6401, 54 )
+, ( 'P68', 6500, 0 )
+, ( 'P76', 7102, 200 )
+, ( 'P78', 244, 23 )
+, ( 'P87', 3103, 300 )
+;
+
+UPDATE STATISTICS FOR TABLE trafodion.invent.partloc ON EVERY COLUMN ;
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/11567d60/docs/2.0.0/spj_guide/resources/source/invent_partsupp_table.sql
----------------------------------------------------------------------
diff --git a/docs/2.0.0/spj_guide/resources/source/invent_partsupp_table.sql b/docs/2.0.0/spj_guide/resources/source/invent_partsupp_table.sql
new file mode 100644
index 0000000..e5d4e1d
--- /dev/null
+++ b/docs/2.0.0/spj_guide/resources/source/invent_partsupp_table.sql
@@ -0,0 +1,128 @@
+CREATE TABLE trafodion.invent.partsupp
+( partnum NUMERIC (4) UNSIGNED NO DEFAULT NOT NULL
+, suppnum NUMERIC (4) UNSIGNED NO DEFAULT NOT NULL
+, partcost NUMERIC (8, 2) NO DEFAULT NOT NULL
+, qty_received NUMERIC (5) UNSIGNED DEFAULT 0 NOT NULL
+, PRIMARY KEY ( partnum, suppnum )
+) ;
+
+CREATE INDEX XSUPORD ON partsupp
+( suppnum
+) ;
+
+CREATE VIEW trafodion.invent.view207
+( partnumber
+, partdescrpt
+, suppnumber
+, supplrname
+, partprice
+, qtyreceived
+)
+AS SELECT
+ x.partnum
+, partdesc
+, x.suppnum
+, suppname
+, partcost
+, qty_received
+FROM
+ trafodion.invent.partsupp x
+, trafodion.sales.parts p
+, trafodion.invent.supplier s
+WHERE x.partnum = p.partnum
+ AND x.suppnum = s.suppnum
+;
+
+CREATE VIEW trafodion.invent.view207n
+( partnumber
+, partdescrpt
+, suppnumber
+, supplrname
+, partprice
+, qtyreceived
+)
+AS SELECT
+ x.partnum
+, p.partdesc
+, s.suppnum
+, s.suppname
+, x.partcost
+, x.qty_received
+FROM trafodion.invent.supplier s
+LEFT JOIN trafodion.invent.partsupp x ON s.suppnum = x.suppnum
+LEFT JOIN trafodion.sales.parts p ON x.partnum = p.partnum
+;
+
+CREATE VIEW trafodion.invent.viewcust
+( custnumber
+, cusname
+, ordernum
+)
+AS SELECT
+ c.custnum
+, c.custname
+, o.ordernum
+FROM trafodion.sales.customer c
+LEFT JOIN trafodion.sales.orders o ON c.custnum = o.custnum
+;
+
+CREATE VIEW trafodion.invent.viewcs AS SELECT
+ custname
+FROM trafodion.sales.customer
+UNION SELECT
+ suppname
+FROM trafodion.invent.supplier ;
+
+INSERT INTO trafodion.invent.partsupp VALUES
+ ( 212, 1, 2000.00, 20 )
+, ( 212, 3, 1900.00, 35 )
+, ( 244, 1, 2400.00, 50 )
+, ( 244, 2, 2200.00, 66 )
+, ( 255, 1, 3300.00, 35 )
+, ( 255, 3, 3000.00, 46 )
+, ( 2001, 1, 700.00, 100 )
+, ( 2001, 2, 750.00, 55 )
+, ( 2002, 1, 1000.00, 120 )
+, ( 2002, 6, 1100.00, 20 )
+, ( 2003, 1, 1300.00, 100 )
+, ( 2003, 2, 1400.00, 50 )
+, ( 2003, 10, 1450.00, 50 )
+, ( 2402, 1, 200.00, 35 )
+, ( 2403, 1, 300.00, 200 )
+, ( 2405, 1, 500.00, 40 )
+, ( 2405, 6, 450.00, 50 )
+, ( 3103, 1, 3200.00, 200 )
+, ( 3103, 15, 3300.00, 100 )
+, ( 3201, 1, 380.00, 36 )
+, ( 3205, 1, 425.00, 150 )
+, ( 3210, 6, 470.00, 10 )
+, ( 3210, 15, 450.00, 25 )
+, ( 4102, 6, 20.00, 115 )
+, ( 4102, 8, 19.00, 140 )
+, ( 4102, 15, 21.00, 30 )
+, ( 5100, 6, 100.00, 50 )
+, ( 5100, 8, 105.00, 40 )
+, ( 5100, 15, 95.00, 60 )
+, ( 5101, 8, 135.00, 33 )
+, ( 5101, 15, 125.00, 43 )
+, ( 5103, 8, 265.00, 20 )
+, ( 5103, 15, 250.00, 58 )
+, ( 5110, 1, 335.00, 100 )
+, ( 5110, 2, 350.00, 36 )
+, ( 5504, 2, 85.00, 10 )
+, ( 5504, 6, 75.00, 10 )
+, ( 5504, 15, 78.00, 10 )
+, ( 5505, 15, 200.00, 100 )
+, ( 6201, 1, 100.00, 110 )
+, ( 6301, 1, 150.00, 230 )
+, ( 6400, 1, 390.00, 50 )
+, ( 6401, 2, 500.00, 20 )
+, ( 6401, 3, 480.00, 38 )
+, ( 6500, 2, 60.00, 140 )
+, ( 6500, 3, 65.00, 32 )
+, ( 6603, 2, 25.00, 150 )
+, ( 7102, 10, 165.00, 100 )
+, ( 7301, 1, 300.00, 32 )
+;
+
+UPDATE STATISTICS FOR TABLE trafodion.invent.partsupp ON EVERY COLUMN ;
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/11567d60/docs/2.0.0/spj_guide/resources/source/invent_schema.sql
----------------------------------------------------------------------
diff --git a/docs/2.0.0/spj_guide/resources/source/invent_schema.sql b/docs/2.0.0/spj_guide/resources/source/invent_schema.sql
new file mode 100644
index 0000000..69ec911
--- /dev/null
+++ b/docs/2.0.0/spj_guide/resources/source/invent_schema.sql
@@ -0,0 +1,2 @@
+CREATE SCHEMA trafodion.invent ;
+SET SCHEMA trafodion.invent ;
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/11567d60/docs/2.0.0/spj_guide/resources/source/invent_supplier_table.sql
----------------------------------------------------------------------
diff --git a/docs/2.0.0/spj_guide/resources/source/invent_supplier_table.sql b/docs/2.0.0/spj_guide/resources/source/invent_supplier_table.sql
new file mode 100644
index 0000000..0391052
--- /dev/null
+++ b/docs/2.0.0/spj_guide/resources/source/invent_supplier_table.sql
@@ -0,0 +1,35 @@
+CREATE TABLE trafodion.invent.supplier
+( suppnum NUMERIC (4) UNSIGNED NO DEFAULT NOT NULL
+, suppname CHARACTER (18) NO DEFAULT NOT NULL
+, street CHARACTER (22) NO DEFAULT NOT NULL
+, city CHARACTER (14) NO DEFAULT NOT NULL
+, state CHARACTER (12) NO DEFAULT NOT NULL
+, postcode CHARACTER (10) NO DEFAULT NOT NULL
+, PRIMARY KEY ( suppnum )
+) ;
+
+CREATE INDEX xsuppnam ON supplier
+( suppname
+) ;
+
+INSERT INTO trafodion.invent.supplier VALUES
+ ( 1, 'NEW COMPUTERS INC', '1800 KING ST.', 'SAN FRANCISCO', 'CALIFORNIA', '94112' )
+, ( 2, 'DATA TERMINAL INC', '2000 BAKER STREET', 'LAS VEGAS', 'NEVADA', '66134' )
+, ( 3, 'HIGH DENSITY INC', '7600 EMERSON', 'NEW YORK', 'NEW YORK', '10230' )
+, ( 6, 'MAGNETICS INC', '1000 INDUSTRY DRIVE', 'LEXINGTON', 'MASS', '02159' )
+, ( 8, 'ATTRACTIVE CORP', '7777 FOUNTAIN WAY', 'CHICAGO', 'ILLINOIS', '60610' )
+, ( 10, 'LEVERAGE INC', '6000 LINCOLN LANE', 'DENVER', 'COLORADO', '80712' )
+, ( 15, 'DATADRIVE CORP', '100 MAC ARTHUR', 'DALLAS', 'TEXAS', '75244' )
+, ( 20, 'Macadam''S PC''s', '106 River Road', 'New Orleans', 'Louisiana', '67890' )
+, ( 25, 'Schroeder''s Ltd', '212 Strasse Blvd West', 'Hamburg', 'Rhode Island', '22222' )
+, ( 30, 'O''Donnell''s Drives', '729 West Palm Beach ', 'San Antonio', 'Texas', '78344' )
+, ( 35, 'Mac''Murphys PC''s', '93323 Alemeda', 'Menlo Park', 'California', '94025' )
+, ( 36, 'MAC''MURPHYS PCB''s', '93323 Alemeda Suite B', 'Menlo Park', 'California', '94025' )
+, ( 90, 'laser jets inc', '284 blue ridge way', 'levittown', 'penna.', '09520' )
+, ( 92, 'watercolors', '84 north grand avenue', 'menlo park', 'california', '94025' )
+, ( 95, 'application do''ers', '2846 yellowwood drive', 'wayland', 'mass', '02158' )
+, ( 99, 'terminals, inc.', '2 longfellow way', 'heightstown', 'nj', '08520' )
+, ( 186, '186 Disk Makers', '186 Dis Way', 'Dat Way', 'Wisconsin', '00186' )
+;
+
+UPDATE STATISTICS FOR TABLE trafodion.invent.supplier ON EVERY COLUMN ;