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:[email protected]";>Subscribe</a></td><td><a class="externalLink" href="mailto:[email protected]";>Unsubscribe</a></td><td><a class="externalLink" href="mailto:[email protected]";>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:[email protected]";>Unsubscribe</a></td><td><a class="externalLink" href="mailto:[email protected]";>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:[email protected]";>Subscribe</a></td><td><a class="externalLink" href="mailto:[email protected]";>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:[email protected]";>Subscribe</a></td><td><a class="externalLink" href="mailto:commi [email protected]">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:[email protected]";>Subscribe</a></td><td><a class="externalLink" href="mailto:[email protected]";>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 ;
