trafodion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dbirds...@apache.org
Subject [2/4] incubator-trafodion-site git commit: [TRAFODION-1905] part of PR 424: SPJ Guide for release 1.3.0
Date Tue, 12 Apr 2016 18:46:07 GMT
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/69a48e02/docs/1.3.0/spj_guide/integration.html
----------------------------------------------------------------------
diff --git a/docs/1.3.0/spj_guide/integration.html b/docs/1.3.0/spj_guide/integration.html
new file mode 100644
index 0000000..d801a04
--- /dev/null
+++ b/docs/1.3.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 12, 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="20160412" />
+    <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-12</span>
+                  &nbsp;| <span id="projectVersion">Version: 1.3.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 &#169;                    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/69a48e02/docs/1.3.0/spj_guide/issue-tracking.html
----------------------------------------------------------------------
diff --git a/docs/1.3.0/spj_guide/issue-tracking.html b/docs/1.3.0/spj_guide/issue-tracking.html
new file mode 100644
index 0000000..2882a78
--- /dev/null
+++ b/docs/1.3.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 12, 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="20160412" />
+    <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-12</span>
+                  &nbsp;| <span id="projectVersion">Version: 1.3.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 &#169;                    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/69a48e02/docs/1.3.0/spj_guide/license.html
----------------------------------------------------------------------
diff --git a/docs/1.3.0/spj_guide/license.html b/docs/1.3.0/spj_guide/license.html
new file mode 100644
index 0000000..252e102
--- /dev/null
+++ b/docs/1.3.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 12, 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="20160412" />
+    <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-12</span>
+                  &nbsp;| <span id="projectVersion">Version: 1.3.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.
+
+      &quot;License&quot; shall mean the terms and conditions for use, reproduction,
+      and distribution as defined by Sections 1 through 9 of this document.
+
+      &quot;Licensor&quot; shall mean the copyright owner or entity authorized by
+      the copyright owner that is granting the License.
+
+      &quot;Legal Entity&quot; 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,
+      &quot;control&quot; 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.
+
+      &quot;You&quot; (or &quot;Your&quot;) shall mean an individual or Legal Entity
+      exercising permissions granted by this License.
+
+      &quot;Source&quot; form shall mean the preferred form for making modifications,
+      including but not limited to software source code, documentation
+      source, and configuration files.
+
+      &quot;Object&quot; 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.
+
+      &quot;Work&quot; 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).
+
+      &quot;Derivative Works&quot; 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.
+
+      &quot;Contribution&quot; 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, &quot;submitted&quot;
+      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 &quot;Not a Contribution.&quot;
+
+      &quot;Contributor&quot; 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 &quot;NOTICE&quot; 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 &quot;AS IS&quot; 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 &quot;[]&quot;
+      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 &quot;printed page&quot; 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 &quot;License&quot;);
+   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 &quot;AS IS&quot; 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 &#169;                    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/69a48e02/docs/1.3.0/spj_guide/mail-lists.html
----------------------------------------------------------------------
diff --git a/docs/1.3.0/spj_guide/mail-lists.html b/docs/1.3.0/spj_guide/mail-lists.html
new file mode 100644
index 0000000..581ac02
--- /dev/null
+++ b/docs/1.3.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 12, 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="20160412" />
+    <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-12</span>
+                  &nbsp;| <span id="projectVersion">Version: 1.3.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 &#169;                    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/69a48e02/docs/1.3.0/spj_guide/project-info.html
----------------------------------------------------------------------
diff --git a/docs/1.3.0/spj_guide/project-info.html b/docs/1.3.0/spj_guide/project-info.html
new file mode 100644
index 0000000..3d46256
--- /dev/null
+++ b/docs/1.3.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 12, 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="20160412" />
+    <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-12</span>
+                  &nbsp;| <span id="projectVersion">Version: 1.3.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 &#169;                    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/69a48e02/docs/1.3.0/spj_guide/project-summary.html
----------------------------------------------------------------------
diff --git a/docs/1.3.0/spj_guide/project-summary.html b/docs/1.3.0/spj_guide/project-summary.html
new file mode 100644
index 0000000..9d1f9fa
--- /dev/null
+++ b/docs/1.3.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 12, 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="20160412" />
+    <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-12</span>
+                  &nbsp;| <span id="projectVersion">Version: 1.3.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>1.3.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 &#169;                    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/69a48e02/docs/1.3.0/spj_guide/resources/acknowledgements.txt
----------------------------------------------------------------------
diff --git a/docs/1.3.0/spj_guide/resources/acknowledgements.txt b/docs/1.3.0/spj_guide/resources/acknowledgements.txt
new file mode 100644
index 0000000..c395596
--- /dev/null
+++ b/docs/1.3.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/69a48e02/docs/1.3.0/spj_guide/resources/source/Inventory.java
----------------------------------------------------------------------
diff --git a/docs/1.3.0/spj_guide/resources/source/Inventory.java b/docs/1.3.0/spj_guide/resources/source/Inventory.java
new file mode 100644
index 0000000..76c5359
--- /dev/null
+++ b/docs/1.3.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/69a48e02/docs/1.3.0/spj_guide/resources/source/Payroll.java
----------------------------------------------------------------------
diff --git a/docs/1.3.0/spj_guide/resources/source/Payroll.java b/docs/1.3.0/spj_guide/resources/source/Payroll.java
new file mode 100644
index 0000000..89c28a5
--- /dev/null
+++ b/docs/1.3.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/69a48e02/docs/1.3.0/spj_guide/resources/source/Sales.java
----------------------------------------------------------------------
diff --git a/docs/1.3.0/spj_guide/resources/source/Sales.java b/docs/1.3.0/spj_guide/resources/source/Sales.java
new file mode 100644
index 0000000..fd47df8
--- /dev/null
+++ b/docs/1.3.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/69a48e02/docs/1.3.0/spj_guide/resources/source/adjustSalary.java
----------------------------------------------------------------------
diff --git a/docs/1.3.0/spj_guide/resources/source/adjustSalary.java b/docs/1.3.0/spj_guide/resources/source/adjustSalary.java
new file mode 100644
index 0000000..cc2b095
--- /dev/null
+++ b/docs/1.3.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/69a48e02/docs/1.3.0/spj_guide/resources/source/employeeJob.java
----------------------------------------------------------------------
diff --git a/docs/1.3.0/spj_guide/resources/source/employeeJob.java b/docs/1.3.0/spj_guide/resources/source/employeeJob.java
new file mode 100644
index 0000000..ce5cdab
--- /dev/null
+++ b/docs/1.3.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/69a48e02/docs/1.3.0/spj_guide/resources/source/invent_partloc_table.sql
----------------------------------------------------------------------
diff --git a/docs/1.3.0/spj_guide/resources/source/invent_partloc_table.sql b/docs/1.3.0/spj_guide/resources/source/invent_partloc_table.sql
new file mode 100644
index 0000000..6268f7f
--- /dev/null
+++ b/docs/1.3.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/69a48e02/docs/1.3.0/spj_guide/resources/source/invent_partsupp_table.sql
----------------------------------------------------------------------
diff --git a/docs/1.3.0/spj_guide/resources/source/invent_partsupp_table.sql b/docs/1.3.0/spj_guide/resources/source/invent_partsupp_table.sql
new file mode 100644
index 0000000..e5d4e1d
--- /dev/null
+++ b/docs/1.3.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/69a48e02/docs/1.3.0/spj_guide/resources/source/invent_schema.sql
----------------------------------------------------------------------
diff --git a/docs/1.3.0/spj_guide/resources/source/invent_schema.sql b/docs/1.3.0/spj_guide/resources/source/invent_schema.sql
new file mode 100644
index 0000000..69ec911
--- /dev/null
+++ b/docs/1.3.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/69a48e02/docs/1.3.0/spj_guide/resources/source/invent_supplier_table.sql
----------------------------------------------------------------------
diff --git a/docs/1.3.0/spj_guide/resources/source/invent_supplier_table.sql b/docs/1.3.0/spj_guide/resources/source/invent_supplier_table.sql
new file mode 100644
index 0000000..0391052
--- /dev/null
+++ b/docs/1.3.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 ;



Mime
View raw message