You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by sv...@apache.org on 2016/01/14 19:18:18 UTC
[14/42] incubator-trafodion git commit: Rechecking of asciidoc
conversion due to weird Windows10 upgrade.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/asciidoc/_chapters/trafci.adoc
----------------------------------------------------------------------
diff --git a/docs/client_install/src/asciidoc/_chapters/trafci.adoc b/docs/client_install/src/asciidoc/_chapters/trafci.adoc
new file mode 100644
index 0000000..0980b3a
--- /dev/null
+++ b/docs/client_install/src/asciidoc/_chapters/trafci.adoc
@@ -0,0 +1,488 @@
+////
+/**
+ *@@@ START COPYRIGHT @@@
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you 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.
+ * @@@ END COPYRIGHT @@@
+ */
+////
+
+= Install TrafCI
+These installation instructions apply to Trafodion Release 1.3.*_n_* and subsequent updates of the product until otherwise indicated.
+
+== Installation Package
+
+The distribution file for the Trafodion Command Interface (TrafCI) is packaged within the Trafodion clients tar file,
+`clients-1.3.*_n_*.tar.gz`, on the Trafodion downloads site http://trafodion.incubator.apache.org/download.html.
+Use this distribution file to install TrafCI:
+
+[cols="35%,35%,30%",options="header"]
+|===
+| Distribution File | Description | Client Operating System
+| `trafci.zip` | Zip file | Windows or Linux
+|===
+
+The distribution zip file contains this installer file: `trafciInstaller.jar`, an executable JAR file.
+
+== Installation Requirements
+
+The Trafodion Command Interface (TrafCI) runs on Windows and Linux. Before installing TrafCI on the client workstation, follow these
+instructions:
+
+* <<trafci_JRE, Install Java Runtime Environment>>
+* <<trafci_install_jdbct4, Install JDBC Type-4 Driver>>
+* <<trafci_perl_python, Install Perl or Python>>
+
+[[trafci_JRE]]
+=== Install/Verify Java Runtime Environment
+
+TrafCI and the Trafodion JDBC Type 4 Driver require that a compatible Java version be installed on the client workstation and that the Java
+path be set to the correct location. The supported Java version is 1.7 or higher.
+
+To determine the Java version that you have installed on your client workstation and to install a supported version, see
+<<jdbct4_JRE, Install Java Runtime Environment (JRE)>>.
+
+[[trafci_install_jdbct4]]
+=== Install/Verify JDBC Type-4 Driver
+TrafCI requires a compatible version of the Trafodion JDBC Type 4 Driver to be installed on the client workstation before you install TrafCI.
+
+==== Install JDBC Type-4 Driver
+To install and use the JDBC driver, see <<jdbct4_JRE, Install Java Runtime Environment (JRE)>>.
+
+==== Verify JDBC Type-4 Driver
+To display the version of the JDBC driver that is already installed on the client workstation:
+
+1. Change the directory to the lib directory, which contains the JDBC driver JAR file:
+* On Windows, enter this command:
++
+====
+*cd _jdbc-installation-directory_\lib*
+====
++
+`_jdbc-installation-directory_` is the directory where you installed the JDBC driver.
+
+* On Linux, enter this command:
++
+====
+*cd _jdbc-installation-directory_/lib*
+====
++
+`_jdbc-installation-directory_` is the directory where you installed the JDBC driver.
+
+2. Enter this command to return version information:
++
+====
+*java -jar jdbcT4.jar*
+====
++
+====
+`C:\>` *cd "\<user-specified directory>\lib"* +
+`C:\<user-specified directory>\lib>` *java -jar jdbcT4.jar*
+```
+Traf_JDBC_Type4_Build_40894
+```
+`C:\<user-specified directory>\lib>`
+====
+
+If the JAR file is inaccessible or the returned version is not supported, see <<trafci_install_jdbct4, Install/Verify JDBC Type-4 Driver>>.
+
+[[trafci_perl_python]]
+=== Install Perl or Python
+
+If you plan to use Perl or Python scripts with TrafCI, verify that you have Perl or Python installed on the client workstation. TrafCI supports
+these versions of Perl and Python:
+
+* Perl version 5.8.8
+* Python version 2.3.4
+
+If you do not have Perl or Python, download it from any open source software provider. You can perform this installation procedure anytime
+before or after installing TrafCI.
+
+If you plan to run the sample scripts provided with TrafCI, verify that you have the Perl JavaServer and Jython (Java implementation of Python)
+installed on your client workstation. Use the TrafCI Installation Wizard to automatically download and install both the Perl JavaServer and
+Jython open source extensions. To download them manually, see the `README` in the samples directory.
+
+== Installation Instructions
+
+NOTE: Before following the installation procedures, you must install the Trafodion JDBC Type 4 Driver on the client workstation. For more
+information, see <<trafci_install_jdbct4, Install JDBC Type-4 Driver>>.
+
+Follow these instructions to download and install TrafCI on the client workstation.
+
+* <<trafci_download_installer, Download Installer>>
+* <<trafci_run_installer, Run Executable JAR Installer>>
+
+To uninstall TrafCI, see <<trafci_uninstall, Uninstall_TrafCI>>.
+
+[[trafci_download_installer]]
+=== Download Installer
+
+1. Create a download folder on the client workstation.
+2. Open a Web browser and navigate to the Trafodion downloads site http://trafodion.incubator.apache.org/download/html
+3. Click on the `clients-1.3.*_n_*.tar.gz` link to start downloading the Trafodion clients tar file to your workstation.
+4. Place the `clients-1.3.*_n_*.tar.gz` file into the download folder.
+5. Unpack the `clients-1.3.*_n_*.tar.gz` file.
++
+====
+*tar -xzf clients-1.3.0.tar.gz*
+====
++
+The package file contains the trafci.zip distribution file, which is extracted to the clients subdirectory.
+
+6. Change the directory to the clients subdirectory.
++
+<<<
+7. Extract the contents of the `trafci.zip` file to a location on your client workstation by using the unzip command (or the WinZip extract
+tool):
++
+====
+*unzip trafci.zip*
+====
++
+The command extracts these files:
++
+* `README`
+* `trafciInstaller.jar`
+
+8. Proceed with <<trafci_run_installer, Run Executable JAR Installer>>.
+
+[[trafci_run_installer]]
+=== Run Executable JAR Installer
+
+When using the executable JAR file, trafciInstaller.jar, to install TrafCI, you have a choice of running the installer from the Installer
+Wizard Graphical User Interface (GUI) or from the command line:
+
+* <<trafci_wizard_install, Installer Wizard Steps>>
+* <<trafci_cmd_install, Command-Line Installation Steps>>
+
+[[trafci_wizard_install]]
+==== Installer Wizard Steps
+
+NOTE: On Linux, to run the Installer Wizard, you must have the X Window system installed on the client workstation. If the client workstation
+does not have the X Window system, see <<trafci_cmd_install, Command-Line Installation Steps>>.
+
+===== Launching the Installer Wizard
+
+1. Locate the `trafciInstaller.jar` file in the folder where you extracted the contents of the distribution (`.zip`) file.
+2. Verify that the `trafciInstaller.jar` file appears as an executable JAR File. If not, skip the next two steps and go to Step 5.
+3. Double-click the `trafciInstaller.jar` file to launch the Installer Wizard.
+4. Proceed to <<trafci_using_wizard, Using the Installer Wizard>>.
+5. At a command prompt, change to the directory where you extracted the installer files:
++
+====
+*cd _installer-directory_*
+====
++
+`_installer-directory_` is the directory where you extracted the installer file, `trafciInstaller.jar`.
++
+<<<
+6. Launch the Installer Wizard by entering:
++
+====
+*java -jar trafciInstaller.jar*
+====
+
+7. Proceed to <<trafci_using_wizard, Using the Installer Wizard>>.
+
+[[trafci_using_wizard]]
+===== Using the Installer Wizard
+
+When you execute `trafciInstaller.jar`, the Installer Wizard appears:
+
+image:{images}/InstallerWizardWelcome.jpg[image]
+
+1. Click one of these buttons for the type of installation that you would like to perform:
+* *Standard Installation* to start the Installer Wizard, which guides you through installing both the core TrafCI components and the optional open
+source extensions
+* *Core Components* for a quick installation of the core TrafCI files
+* *Optional Components* if you have already installed the core TrafCI files but want to install only the optional open source extensions
++
+<<<
+2. After you have selected the components you wish to install, browse and select the JDBC JAR file and then specify an installation directory
+where you will install TrafCI.
++
+image:{images}/InstallerWizardPaths.jpg[image]
+
+3. To locate the JDBC driver JAR file, click *Browse* next to the *JDBC Type 4 Driver JAR File*.
+4. In the *Select JDBC Type 4 Driver JAR File* dialog box, navigate to and select the lib folder of the Trafodion JDBC driver, and then click *Open*.
+5. Select `jdbcT4.jar` so that it appears in the *File Name* box, and then click *Select*.
++
+The Installer Wizard now displays the path of the JDBC driver JAR file.
++
+image:{images}/JDBC_JAR_Path.jpg[image]
+6. To install in the default location, proceed to Step 9. To install in your own preferred location, proceed to Step 7.
+7. To find an installation location for TrafCI, click *Browse* next to the *Trafodion Command Interface* installation directory.
+8. In the *Select Trafodion Command Interface Installation Directory* dialog box, select the folder where you want to install TrafCI so that
+the directory path appears in the *File Name* box, and then click *Select*.
++
+The Installer Wizard displays the directory where TrafCI is installed.
+9. Click *Next* to review the open-source legal disclaimer.
+10. If you agree to the terms and conditions, select the check box, and click *Next*.
++
+The Installer Wizard dialog box shows which components are available for you to download and install.
++
+image:{images}/OptionalComponents.jpg[image]
++
+<<<
+11. Select the optional components to be downloaded and installed. Each optional component is installed if the component box is checked.
++
+If you want to change the download URL for the extensions, click *Edit URL*, and this dialog box appears:
++
+image:{images}/PerlJavaServerURL.jpg[image]
++
+Type a new path, and click *OK*.
++
+NOTE: Perl and Python must be installed for the respective extensions to work.
+12. If you do not require a proxy server, proceed to Step 15.
+13. If you require a proxy server, select *Use the following proxy settings* and enter the proxy server and port for downloading the open
+source extensions.
++
+image:{images}/ProxySettings.jpg[image]
+14. Click *Detect Proxy Server(s)* to try to auto-detect your proxy settings. If TrafCI detects one or more proxy servers, it displays
+them in a drop-down menu next to the *Detect Proxy Server(s)* button.
+15. Click *Install* to start the installation.
++
+<<<
+16. After the core TrafCI files are installed, the *Installation Status* dialog box appears indicating how many files were extracted to the
+installation directory:
++
+image:{images}/Extracted_Files.jpg[image]
++
+Click *OK* to continue the installation.
+17. If you chose to install the optional components, the installer attempts to download and install them. The progress bar indicates the
+download progress of each file. In addition, an installation log provides details about the status of the download and installation of
+the components.
++
+image:{images}/InstallComplete.jpg[image]
+18. After all TrafCI files are installed, the Installer Wizard completes.
+19. Click *Exit*.
+
+<<<
+[[trafci_cmd_install]]
+==== Command-Line Installation Steps
+
+1. At a command prompt, change to the directory where you extracted the contents of the distribution (.zip) file:
++
+====
+*cd _installer-directory_*
+====
++
+`_installer-directory_` is the directory where you extracted the installer files.
+
+2. Before launching the command-line installer, see the command options below:
++
+====
+```
+java -jar trafciInstaller.jar -help
+Usage: java -jar <installer jar> [ -help] | <-cm|-silent>
+ [-jdbcFile <jdbc filename>] [-installDir <install dir>] ]
+```
+====
++
+The `-silent` option installs the client without prompting you for options.
++
+====
+*java -jar trafciInstaller.jar -silent -jdbcFile "C:\JDBC\lib\jdbcT4.jar" -installDir C:\TRAFCI*
+====
++
+`-jdbcFile` and `-installDir` are optional parameters. If you do not specify those parameters, you will be prompted to enter them during
+installation.
+
+3. Launch the command-line installer by entering this command:
++
+====
+*java -jar trafciInstaller.jar cm*
+====
++
+The command-line installer starts and prompts you to enter the type of installation:
++
+====
+```
+/home/myname/trafcitemp>java -jar trafciInstaller.jar cm
+********************************************************************
+**** **
+**** Welcome to Trafodion Command Interface Installer **
+**** **
+**** NOTE: The installer requires a the JDBC Type 4 **
+**** Driver to be installed a on your workstation. **
+********************************************************************
+Type Y for a standard installation, or N for optional components only.
+
+Standard Installation [Y]:
+```
+====
++
+* For a standard installation, type *Y* and press *Enter*.
+* To install the optional components only, type *N*, press *Enter*, and proceed to Step 7.
++
+NOTE: All items in square brackets are default values. Press Enter to accept the default value.
+
+4. Enter the full directory path and file name of the JDBC driver JAR file, `jdbcT4.jar`, which is located in the JDBC driver lib directory:
++
+====
+```
+JDBC Type 4 Driver JAR File
+--------------------------------
+Enter the location and file name:
+```
+====
+5. Enter an existing directory where you would like to install TrafCI:
++
+====
+```
+Trafodion Command Interface
+--------------------------------
+Enter the installation directory:
+```
+====
++
+The installation status appears, indicating how many files are installed in the installation directory:
++
+====
+```
+Extracted 18 files from the
+/home/myname/trafcitemp/trafciInstaller.jar archive into the
+/usr/local/trafci directory.
+Core TRAFCI files installed.
+Do you want to install the optional components? [Y]:
+```
+====
+6. If you do not wish to download and install the optional components, type *N* at the prompt and press Enter, and your installation
+is complete. Otherwise, type *Y*, press *Enter*, and proceed through the remainder of the installation.
+7. Type *Y* and press *Enter* if you agree to the terms. If you are doing an optional install only, you are prompted to enter a valid TrafCI
+installation directory:
++
+====
+`Do you agree to these terms? (Y or N):` *Y* +
+```
+Enter your installation directory:
+```
+====
++
+<<<
+8. If you do not require a proxy server, type *N*, press *Enter*, and proceed to Step 10. Otherwise, type *Y*, press *Enter*,
+and proceed to Step 9.
++
+====
+```
+Use a proxy server? [N]:
+```
+====
+
+9. When prompted to auto-detect proxy servers, type *Y* and press *Enter* to direct TrafCI to detect your proxy settings.
+If TrafCI finds proxy servers, it displays them. If you type *N* and press *Enter*, TrafCI prompts you to enter the proxy server and port:
++
+====
+`Use a proxy server? [Y]:` *Y* +
+`Attempt to auto-detect proxy server(s)? [Y]:` *N* +
+`Enter the proxy server (do not include the port):` *myproxyserver.com* +
+`Enter the proxy port:` *8080*
+====
+
+10. You are prompted to select which optional components you wish to download and install. You can also change the download URL.
++
+====
+`Install Perl JavaServer extensions? [Y]:` *Y* +
+```
+Perl JavaServer requires 3 files: Java.pm, JavaArray.pm, and JavaServer.jar
+http://search.cpan.org/src/METZZO/Java-4.7/[URL of the folder which contains these files [http://search.cpan.org/src/METZZO/Java-4.7/]:]
+```
+`Install Perl XML SAX Module? [Y]:` *Y* +
+```
+Perl SAX XML Module URL (PerlSAX.pm)
+```
+`Install Jython, a Java implementation of Python? [Y]:` *Y* +
+```
+Jython URL (jython_installer-2.2.jar)
+```
+====
+
+11. The setup proceeds to download and install the optional open-sourcecomponents. As each component is retrieved, dots (.) are printed to
+indicate the progress of the download.
++
+====
+```
+Downloading Perl JavaServer [1 of 3] - Java.pm
+......................... 100%
+Downloading Perl JavaServer [2 of 3] - JavaArray.pm1 +
+......................... 100%
+Downloading Perl JavaServer [3 of 3] - JavaServer.jar
+......................... 100%
+Successfully added settings.pl
+Downloading Perl XML SAX Module [1 of 1] - PerlSAX.pm
+......................... 100%
+Downloading Jython [1 of 1] - jython_installer-2.2.jar
+......................... 100%
+Sucessfully Installed Jython. Successfully added settings.py
+Trafodion Command Interface Installation Complete.
+/home/myname/trafcitemp>
+```
+====
+
+[[trafci_uninstall]]
+=== Uninstall TrafCI
+
+If you used the executable JAR file, `trafciInstaller.jar`, to install TrafCI, delete the entire
+`Trafodion Command Interface` folder to uninstall TrafCI.
+
+== Post-Installation Instructions
+
+=== Verify Installed Software Files
+
+After downloading and running the installer file, verify that the TrafCI software files are installed in the correct locations:
+
+[cols="15%,20%,65%",options="header"]
+|===
+| Folder | Files | Description
+| `bin` | `trafci` |
+| | `trafci.cmd` | Windows launch file.
+| | `trafci.pl` | Perl wrapper script. trafci-perl.pl is renamed trafci.pl. To run this script, see the _Trafodion Command Interface Guide_.
+| | `trafci.py` | Python wrapper script. `trafci-python.py` is renamed as `trafci.py`. To run this script, see the http://trafodion.incubator.apache.com/docs/command_interface/index.html[_Trafodion Command Interface Guide_].
+| | `trafci.sh` | Linux launch file.
+| | `trafci-perl.pl` | Perl wrapper script. This script has been modified to invoke trafci.pl. This script is retained for backward compatibility.
+| | `trafci-python.py` | Python wrapper script. This script has been modified to invoke trafci.py. This script is retained for backward compatibility.
+| `lib` | `trafci.jar` | Product JAR file.
+| `lib/perl` | `Session.pm` | Product file.
+| `lib/python` | `Session.py` | Product file.
+| `samples` | `README` | Readme file that describes how to use the sample scripts.
+| | `arrayDML.pl` | Sample Perl program that executes DML statements and returns results in an array format.
+| | `sample.pl` | Sample Perl program that supports multiple sessions in one script.
+| | `sample.sql` | Sample SQL script.
+| | `sampleDDL.py` | Sample Python file that uses Jython to execute DDL statements.
+| | `sampleDML.py` | Sample Python file that uses Jython to execute DML statements.
+| | `sampleTables.pl` | Sample Perl file that lists all tables and respective rowcounts. The file accepts a wildcard argument on the command line.
+| | `sampleTables.py` | Sample Python file that lists all tables and respective rowcounts. The file accepts a wildcard argument on the command line.
+|===
+
+=== Test Launching TrafCI
+
+Before launching TrafCI, make sure that you have set the Java path to the correct location. For more information, see:
+
+* <<jdbct4_path_windows, Setting the PATH to a Supported Java Version on Windows>>
+* <<jdbct4_path_linux, Setting the PATH to a Supported Java Version on Linux>>
+
+If you did not set the Java path on your client workstation and you try to launch TrafCI, you might see the following error message appear
+momentarily in the TrafCI window before the TrafCI window disappears:
+
+====
+```
+'java' is not recognized as an internal or external command, operable program or batch file.
+```
+====
+
+For information about setting up the client, such as choosing the look and feel of the interface or presetting launch parameters, see the
+_Trafodion Command Interface Guide_.
+
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/asciidoc/index.adoc
----------------------------------------------------------------------
diff --git a/docs/client_install/src/asciidoc/index.adoc b/docs/client_install/src/asciidoc/index.adoc
new file mode 100644
index 0000000..673a748
--- /dev/null
+++ b/docs/client_install/src/asciidoc/index.adoc
@@ -0,0 +1,80 @@
+////
+* @@@ START COPYRIGHT @@@
+*
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements. See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership. The ASF licenses this file
+* to you 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.
+*
+* @@@ END COPYRIGHT @@@
+////
+
+= Trafodion Client Installation Guide
+Version 1.3.0, January 2016
+:doctype: book
+:numbered:
+:toc: left
+:toclevels: 3
+:toc-title: Table of Contents
+:icons: font
+:iconsdir: icons
+:experimental:
+:source-language: text
+
+:images: ../images
+:sourcedir: ../../resources/source
+
+:leveloffset: 1
+
+// The directory is called _chapters because asciidoctor skips direct
+// processing of files found in directories starting with an _. This
+// prevents each chapter being built as its own book.
+
+**License Statement**
+
+Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information regarding copyright ownership. The ASF licenses this file
+to you 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.
+
+**Acknowledgements**
+
+Microsoft® and Windows® are U.S. registered trademarks of Microsoft Corporation. Java® is a registered trademark of Oracle and/or its affiliates. DbVisualizer™ is a trademark of DbVis Software AB.
+
+[cols="2",options="header"]
+|===
+| Version | Date
+| 1.3.0 | January, 2016
+|===
+
+include::asciidoc/_chapters/about.adoc[]
+include::asciidoc/_chapters/introduction.adoc[]
+include::asciidoc/_chapters/odbc_windows.adoc[]
+include::asciidoc/_chapters/odbc_linux.adoc[]
+include::asciidoc/_chapters/jdbct4.adoc[]
+include::asciidoc/_chapters/trafci.adoc[]
+include::asciidoc/_chapters/odb.adoc[]
+include::asciidoc/_chapters/dbviz.adoc[]
+include::asciidoc/_chapters/SQuirrel.adoc[]
+
+= Appendix
+include::asciidoc/_chapters/sample_prog.adoc[]
+
+
+
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/images/Add_Alias_SQuirreL.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/src/images/Add_Alias_SQuirreL.jpg b/docs/client_install/src/images/Add_Alias_SQuirreL.jpg
new file mode 100644
index 0000000..0e2d483
Binary files /dev/null and b/docs/client_install/src/images/Add_Alias_SQuirreL.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/images/Add_Driver_SQuirreL.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/src/images/Add_Driver_SQuirreL.jpg b/docs/client_install/src/images/Add_Driver_SQuirreL.jpg
new file mode 100644
index 0000000..6dd3244
Binary files /dev/null and b/docs/client_install/src/images/Add_Driver_SQuirreL.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/images/Database_Connection_in_DbVisualizer.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/src/images/Database_Connection_in_DbVisualizer.jpg b/docs/client_install/src/images/Database_Connection_in_DbVisualizer.jpg
new file mode 100644
index 0000000..5cd345c
Binary files /dev/null and b/docs/client_install/src/images/Database_Connection_in_DbVisualizer.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/images/DbVisualizer_Driver_Manager.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/src/images/DbVisualizer_Driver_Manager.jpg b/docs/client_install/src/images/DbVisualizer_Driver_Manager.jpg
new file mode 100644
index 0000000..535d96f
Binary files /dev/null and b/docs/client_install/src/images/DbVisualizer_Driver_Manager.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/images/Extracted_Files.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/src/images/Extracted_Files.jpg b/docs/client_install/src/images/Extracted_Files.jpg
new file mode 100644
index 0000000..b272015
Binary files /dev/null and b/docs/client_install/src/images/Extracted_Files.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/images/InstallComplete.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/src/images/InstallComplete.jpg b/docs/client_install/src/images/InstallComplete.jpg
new file mode 100644
index 0000000..a565be3
Binary files /dev/null and b/docs/client_install/src/images/InstallComplete.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/images/InstallerWizardPaths.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/src/images/InstallerWizardPaths.jpg b/docs/client_install/src/images/InstallerWizardPaths.jpg
new file mode 100644
index 0000000..b13e61d
Binary files /dev/null and b/docs/client_install/src/images/InstallerWizardPaths.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/images/InstallerWizardWelcome.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/src/images/InstallerWizardWelcome.jpg b/docs/client_install/src/images/InstallerWizardWelcome.jpg
new file mode 100644
index 0000000..a87437e
Binary files /dev/null and b/docs/client_install/src/images/InstallerWizardWelcome.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/images/JDBC_JAR_Path.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/src/images/JDBC_JAR_Path.jpg b/docs/client_install/src/images/JDBC_JAR_Path.jpg
new file mode 100644
index 0000000..ebae592
Binary files /dev/null and b/docs/client_install/src/images/JDBC_JAR_Path.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/images/OptionalComponents.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/src/images/OptionalComponents.jpg b/docs/client_install/src/images/OptionalComponents.jpg
new file mode 100644
index 0000000..b95dff2
Binary files /dev/null and b/docs/client_install/src/images/OptionalComponents.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/images/PerlJavaServerURL.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/src/images/PerlJavaServerURL.jpg b/docs/client_install/src/images/PerlJavaServerURL.jpg
new file mode 100644
index 0000000..c78b55b
Binary files /dev/null and b/docs/client_install/src/images/PerlJavaServerURL.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/images/Physical_Connection.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/src/images/Physical_Connection.jpg b/docs/client_install/src/images/Physical_Connection.jpg
new file mode 100644
index 0000000..b5d3475
Binary files /dev/null and b/docs/client_install/src/images/Physical_Connection.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/images/Properties_for_Alias_SQuirreL.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/src/images/Properties_for_Alias_SQuirreL.jpg b/docs/client_install/src/images/Properties_for_Alias_SQuirreL.jpg
new file mode 100644
index 0000000..51bc3e3
Binary files /dev/null and b/docs/client_install/src/images/Properties_for_Alias_SQuirreL.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/images/ProxySettings.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/src/images/ProxySettings.jpg b/docs/client_install/src/images/ProxySettings.jpg
new file mode 100644
index 0000000..1d4596c
Binary files /dev/null and b/docs/client_install/src/images/ProxySettings.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/images/TQW_control_options.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/src/images/TQW_control_options.jpg b/docs/client_install/src/images/TQW_control_options.jpg
new file mode 100644
index 0000000..af6df88
Binary files /dev/null and b/docs/client_install/src/images/TQW_control_options.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/images/TQW_login.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/src/images/TQW_login.jpg b/docs/client_install/src/images/TQW_login.jpg
new file mode 100644
index 0000000..0fa92da
Binary files /dev/null and b/docs/client_install/src/images/TQW_login.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/images/TQW_logout.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/src/images/TQW_logout.jpg b/docs/client_install/src/images/TQW_logout.jpg
new file mode 100644
index 0000000..b1f5c91
Binary files /dev/null and b/docs/client_install/src/images/TQW_logout.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/images/TQW_query_plan.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/src/images/TQW_query_plan.jpg b/docs/client_install/src/images/TQW_query_plan.jpg
new file mode 100644
index 0000000..0a3efd4
Binary files /dev/null and b/docs/client_install/src/images/TQW_query_plan.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/images/TQW_session.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/src/images/TQW_session.jpg b/docs/client_install/src/images/TQW_session.jpg
new file mode 100644
index 0000000..51c23eb
Binary files /dev/null and b/docs/client_install/src/images/TQW_session.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/images/TQW_whiteboard.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/src/images/TQW_whiteboard.jpg b/docs/client_install/src/images/TQW_whiteboard.jpg
new file mode 100644
index 0000000..f60efc3
Binary files /dev/null and b/docs/client_install/src/images/TQW_whiteboard.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/images/path2.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/src/images/path2.jpg b/docs/client_install/src/images/path2.jpg
new file mode 100644
index 0000000..9823379
Binary files /dev/null and b/docs/client_install/src/images/path2.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/images/varval2.jpg
----------------------------------------------------------------------
diff --git a/docs/client_install/src/images/varval2.jpg b/docs/client_install/src/images/varval2.jpg
new file mode 100644
index 0000000..340fefe
Binary files /dev/null and b/docs/client_install/src/images/varval2.jpg differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/resources/source/basicsql.cpp
----------------------------------------------------------------------
diff --git a/docs/client_install/src/resources/source/basicsql.cpp b/docs/client_install/src/resources/source/basicsql.cpp
new file mode 100644
index 0000000..9215a5d
--- /dev/null
+++ b/docs/client_install/src/resources/source/basicsql.cpp
@@ -0,0 +1,394 @@
+// @@@ START COPYRIGHT @@@
+//
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you 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.
+//
+// @@@ END COPYRIGHT @@@
+
+#ifdef __linux
+ #include <unistd.h>
+#else
+ #include <windows.h>
+ #include <tchar.h>
+#endif
+
+//#include <stdarg.h>
+
+#include <stdio.h>
+#include <string.h>
+#include <stdlib.h>
+#include <assert.h>
+
+#include <sql.h>
+#include <sqlext.h>
+
+SQLHENV henv;
+SQLHDBC hdbc;
+SQLHSTMT hstmt;
+SQLHWND hWnd;
+
+#define MAX_SQLSTRING_LEN 1000
+#define STATE_SIZE 6
+#define MAX_CONNECT_STRING 256
+#define TRUE 1
+#define FALSE 0
+#define ARGS "d:u:p:"
+
+const char *SqlRetText(int rc)
+{
+ static char buffer[80];
+ switch (rc)
+ {
+ case SQL_SUCCESS:
+ return("SQL_SUCCESS");
+ case SQL_SUCCESS_WITH_INFO:
+ return("SQL_SUCCESS_WITH_INFO");
+ case SQL_NO_DATA:
+ return("SQL_NO_DATA");
+ case SQL_ERROR:
+ return("SQL_ERROR");
+ case SQL_INVALID_HANDLE:
+ return("SQL_INVALID_HANDLE");
+ case SQL_STILL_EXECUTING:
+ return("SQL_STILL_EXECUTING");
+ case SQL_NEED_DATA:
+ return("SQL_NEED_DATA");
+ }
+ sprintf(buffer,"SQL Error %d",rc);
+ return(buffer);
+}
+
+void CleanUp()
+{
+ printf("\nConnect Test FAILED!!!\n");
+ if(hstmt != SQL_NULL_HANDLE)
+ SQLFreeHandle(SQL_HANDLE_STMT,hstmt);
+ if(hdbc != SQL_NULL_HANDLE)
+ {
+ SQLDisconnect(hdbc);
+ SQLFreeHandle(SQL_HANDLE_DBC,hdbc);
+ }
+ if(henv != SQL_NULL_HANDLE)
+ SQLFreeHandle(SQL_HANDLE_ENV,henv);
+ exit(EXIT_FAILURE);
+}
+
+void LogDiagnostics(const char *sqlFunction, SQLRETURN rc, bool exitOnError=true)
+{
+ SQLRETURN diagRC = SQL_SUCCESS;
+ SQLSMALLINT recordNumber;
+ SQLINTEGER nativeError;
+ SQLCHAR messageText[SQL_MAX_MESSAGE_LENGTH];
+ SQLCHAR sqlState[6];
+ int diagsPrinted = 0;
+ bool printedErrorLogHeader = false;
+
+ printf("Function %s returned %s\n", sqlFunction, SqlRetText(rc));
+
+ /* Log any henv Diagnostics */
+ recordNumber = 1;
+ do
+ {
+ diagRC = SQLGetDiagRec( SQL_HANDLE_ENV
+ , henv
+ , recordNumber
+ , sqlState
+ , &nativeError
+ , messageText
+ , sizeof(messageText)
+ , NULL
+ );
+ if(diagRC==SQL_SUCCESS)
+ {
+ if(!printedErrorLogHeader)
+ {
+ printf("Diagnostics associated with environment handle:\n");
+ printedErrorLogHeader = true;
+ }
+ printf("\n\tSQL Diag %d\n\tNative Error: %ld\n\tSQL State: %s\n\tMessage: %s\n",
+ recordNumber,nativeError,sqlState,messageText);
+ }
+ recordNumber++;
+ } while (diagRC==SQL_SUCCESS);
+
+ /* Log any hdbc Diagnostics */
+ recordNumber = 1;
+ printedErrorLogHeader = false;
+ do
+ {
+ diagRC = SQLGetDiagRec( SQL_HANDLE_DBC
+ , hdbc
+ , recordNumber
+ , sqlState
+ , &nativeError
+ , messageText
+ , sizeof(messageText)
+ , NULL
+ );
+ if(diagRC==SQL_SUCCESS)
+ {
+ if(!printedErrorLogHeader)
+ {
+ printf("Diagnostics associated with connection handle:\n");
+ printedErrorLogHeader = true;
+ }
+ printf("\n\tSQL Diag %d\n\tNative Error: %ld\n\tSQL State: %s\n\tMessage: %s\n",
+ recordNumber,nativeError,sqlState,messageText);
+ }
+ recordNumber++;
+ } while (diagRC==SQL_SUCCESS);
+
+ /* Log any hstmt Diagnostics */
+ recordNumber = 1;
+ printedErrorLogHeader = false;
+ do
+ {
+ diagRC = SQLGetDiagRec( SQL_HANDLE_STMT
+ , hstmt
+ , recordNumber
+ , sqlState
+ , &nativeError
+ , messageText
+ , sizeof(messageText)
+ , NULL
+ );
+ if(diagRC==SQL_SUCCESS)
+ {
+ if(!printedErrorLogHeader)
+ {
+ printf("Diagnostics associated with statmement handle:\n");
+ printedErrorLogHeader = true;
+ }
+ printf("\n\tSQL Diag %d\n\tNative Error: %ld\n\tSQL State: %s\n\tMessage: %s\n",
+ recordNumber,nativeError,sqlState,messageText);
+ }
+ recordNumber++;
+ } while (diagRC==SQL_SUCCESS);
+
+ if(exitOnError && rc!=SQL_SUCCESS_WITH_INFO)
+ CleanUp();
+}
+
+// Main Program
+int main (int argc, char *argv[])
+{
+ unsigned char dsnName[20];
+ unsigned char user[20];
+ unsigned char password[20];
+ SQLRETURN returnCode;
+ bool testPassed = true;
+ SQLCHAR InConnStr[MAX_CONNECT_STRING];
+ SQLCHAR OutConnStr[MAX_CONNECT_STRING];
+ SQLSMALLINT ConnStrLength;
+ int errflag = 0;
+
+ //optarg = NULL;
+ if (argc != 4)
+ errflag++;
+
+ if (!errflag )
+ {
+ strcpy ((char *)dsnName, argv[1]);
+ strcpy ((char *)dsnName, argv[1]);
+ strcpy ((char *)user, argv[2]);
+ strcpy ((char *)password, argv[3]);
+ }
+
+ if (errflag)
+ {
+ printf("Command line error.\n");
+ printf("Usage: %s <datasource> <userid> <password>\n", argv[0] );
+ return FALSE;
+ }
+
+ // Initialize handles to NULL
+ henv = SQL_NULL_HANDLE;
+ hstmt = SQL_NULL_HANDLE;
+ hdbc = SQL_NULL_HANDLE;
+
+ // Allocate Environment Handle
+ returnCode = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv);
+ if (!SQL_SUCCEEDED(returnCode))
+ LogDiagnostics("SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv)",returnCode);
+
+ // Set ODBC version to 3.0
+ returnCode = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (void*)SQL_OV_ODBC3, 0);
+ if (!SQL_SUCCEEDED(returnCode))
+ LogDiagnostics( "SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (void*)SQL_OV_ODBC3, 0)"
+ , returnCode
+ , false
+ );
+
+ // Allocate Connection handle
+ returnCode = SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);
+ if (!SQL_SUCCEEDED(returnCode))
+ LogDiagnostics("SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc)", returnCode);
+
+ //Connect to the database
+ sprintf((char*)InConnStr,"DSN=%s;UID=%s;PWD=%s;%c",(char*)dsnName, (char*)user, (char*)password,'\0');
+ printf("Using Connect String: %s\n", InConnStr);
+ returnCode = SQLDriverConnect( hdbc
+ , hWnd
+ , InConnStr
+ , SQL_NTS
+ , OutConnStr
+ , sizeof(OutConnStr)
+ , &ConnStrLength
+ , SQL_DRIVER_NOPROMPT
+ );
+ if (!SQL_SUCCEEDED(returnCode))
+ LogDiagnostics("SQLDriverConnect",returnCode);
+ printf("Successfully connected using SQLDriverConnect.\n");
+
+ //Allocate Statement handle
+ returnCode = SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);
+ if (!SQL_SUCCEEDED(returnCode))
+ LogDiagnostics("SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt)", returnCode);
+
+ printf("Drop sample table if it exists...\n");
+ //Drop the test table if it exists
+ //DROP IF EXISTS TASKS;
+ returnCode = SQLExecDirect(hstmt, (SQLCHAR*)"DROP TABLE IF EXISTS TASKS", SQL_NTS);
+ if (!SQL_SUCCEEDED(returnCode))
+ LogDiagnostics("SQLExecDirect of DROP", returnCode);
+
+ printf("Creating sample table TASKS...\n");
+ //Create a test table in default schema
+ //CREATE TABLE TASKS (ID INT NOT NULL, TASK VARCHAR(10), LAST_UPDATE TIMESTAMP, PRIMARY KEY (C1));
+ returnCode =
+ SQLExecDirect
+ ( hstmt
+ , (SQLCHAR*)"CREATE TABLE TASKS (ID INT NOT NULL, TASK CHAR(20), COMPLETED DATE, PRIMARY KEY (ID))"
+ , SQL_NTS
+ );
+ if (!SQL_SUCCEEDED(returnCode))
+ LogDiagnostics("SQLExecDirect of CREATE", returnCode);
+ printf("Table TASKS created using SQLExecDirect.\n");
+
+ printf("Inserting data using SQLBindParameter, SQLPrepare, SQLExecute\n");
+ //Insert few rows into test table using bound parameters
+ //INSERT INTO TASKS VALUES (?, ?, ?);
+ SQLINTEGER intID;
+ SQLLEN cbID = 0, cbTask = SQL_NTS, cbCompleted = 0;
+ SQLCHAR strTask[200];
+ SQL_DATE_STRUCT dsCompleted;
+
+ returnCode = SQLBindParameter( hstmt
+ , 1
+ , SQL_PARAM_INPUT
+ , SQL_C_SHORT
+ , SQL_INTEGER
+ , 0
+ , 0
+ , &intID
+ , 0
+ , &cbID
+ );
+ if (!SQL_SUCCEEDED(returnCode))
+ LogDiagnostics("SQLBindParameter 1", returnCode);
+
+ returnCode = SQLBindParameter(hstmt, 2, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR, 0, 0, &strTask, 0, &cbTask);
+ if (!SQL_SUCCEEDED(returnCode))
+ LogDiagnostics("SQLBindParameter 2", returnCode);
+
+ returnCode = SQLBindParameter( hstmt
+ , 3
+ , SQL_PARAM_INPUT
+ , SQL_C_TYPE_DATE
+ , SQL_DATE
+ , sizeof(dsCompleted)
+ , 0
+ , &dsCompleted
+ , 0
+ , &cbCompleted
+ );
+ if (!SQL_SUCCEEDED(returnCode))
+ LogDiagnostics("SQLBindParameter 3", returnCode);
+
+ returnCode = SQLPrepare(hstmt, (SQLCHAR*)"INSERT INTO TASKS VALUES (?, ?, ?)", SQL_NTS);
+ if (!SQL_SUCCEEDED(returnCode))
+ LogDiagnostics("SQLPrepare of INSERT", returnCode);
+
+ intID = 1000;
+ strcpy ((char*)strTask, "CREATE REPORTS");
+ dsCompleted.year = 2014;
+ dsCompleted.month = 3;
+ dsCompleted.day = 22;
+
+ returnCode = SQLExecute(hstmt);
+ if (!SQL_SUCCEEDED(returnCode))
+ LogDiagnostics("SQLExecute", returnCode);
+ printf("Data inserted.\n");
+
+ //Select rows from test table and fetch the data
+ //SELECT * from TASKS WHERE TASK LIKE '%REPORT%'
+ printf("Fetching data using SQLExecDirect, SQLFetch, SQLGetData\n");
+ returnCode = SQLExecDirect(hstmt, (SQLCHAR*)"SELECT ID, TASK, COMPLETED FROM TASKS", SQL_NTS);
+ if (!SQL_SUCCEEDED(returnCode))
+ LogDiagnostics("SQLExecDirect of SELECT", returnCode);
+
+ //loop thru resultset
+ while (TRUE)
+ {
+ returnCode = SQLFetch(hstmt);
+ if (returnCode == SQL_ERROR || returnCode == SQL_SUCCESS_WITH_INFO)
+ {
+ LogDiagnostics("SQLFetch", returnCode);
+ }
+ if (returnCode == SQL_SUCCESS || returnCode == SQL_SUCCESS_WITH_INFO)
+ {
+ SQLGetData(hstmt, 1, SQL_C_SHORT, &intID, 0, &cbID);
+ SQLGetData(hstmt, 2, SQL_C_CHAR, strTask, 20, &cbTask);
+ SQLGetData(hstmt, 3, SQL_C_TYPE_DATE, &dsCompleted, sizeof(dsCompleted), &cbCompleted);
+ printf( "Data selected: %d %s %d-%d-%d\n"
+ , intID
+ , strTask
+ , dsCompleted.year
+ , dsCompleted.month
+ , dsCompleted.day
+ );
+ }
+ else
+ break;
+ }
+
+ //Free Statement handle
+ returnCode = SQLFreeHandle(SQL_HANDLE_STMT, hstmt);
+ if (!SQL_SUCCEEDED(returnCode))
+ LogDiagnostics("SQLFreeHandle(SQL_HANDLE_STMT, hstmt)", returnCode);
+ hstmt = SQL_NULL_HANDLE;
+
+ //Disconnect
+ returnCode = SQLDisconnect(hdbc);
+ if (!SQL_SUCCEEDED(returnCode))
+ LogDiagnostics("SQLDisconnect(hdbc)", returnCode);
+
+ //Free Connection handle
+ returnCode = SQLFreeHandle(SQL_HANDLE_DBC, hdbc);
+ if (!SQL_SUCCEEDED(returnCode))
+ LogDiagnostics("SQLFreeHandle(SQL_HANDLE_DBC, hdbc)", returnCode);
+ hdbc = SQL_NULL_HANDLE;
+
+ //Free Environment handle
+ returnCode = SQLFreeHandle(SQL_HANDLE_ENV, henv);
+ if (!SQL_SUCCEEDED(returnCode))
+ LogDiagnostics("SQLFreeHandle(SQL_HANDLE_ENV, henv)", returnCode);
+ henv = SQL_NULL_HANDLE;
+
+ printf("Basic SQL ODBC Test Passed!\n");
+ exit(EXIT_SUCCESS);
+}
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/resources/source/build.bat
----------------------------------------------------------------------
diff --git a/docs/client_install/src/resources/source/build.bat b/docs/client_install/src/resources/source/build.bat
new file mode 100644
index 0000000..d8ecdda
--- /dev/null
+++ b/docs/client_install/src/resources/source/build.bat
@@ -0,0 +1,25 @@
+@echo off
+REM @@@ START COPYRIGHT @@@
+REM
+REM Licensed to the Apache Software Foundation (ASF) under one
+REM or more contributor license agreements. See the NOTICE file
+REM distributed with this work for additional information
+REM regarding copyright ownership. The ASF licenses this file
+REM to you under the Apache License, Version 2.0 (the
+REM "License"); you may not use this file except in compliance
+REM with the License. You may obtain a copy of the License at
+REM
+REM http://www.apache.org/licenses/LICENSE-2.0
+REM
+REM Unless required by applicable law or agreed to in writing,
+REM software distributed under the License is distributed on an
+REM "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+REM KIND, either express or implied. See the License for the
+REM specific language governing permissions and limitations
+REM under the License.
+REM
+REM @@@ END COPYRIGHT @@@
+
+CL /c /Zi /nologo /W3 /WX- /O2 /D "NDEBUG" /D "_CRT_SECURE_NO_DEPRECATE" /D "_MBCS" /Gm /EHsc /GS /fp:precise /Zc:wchar_t /Zc:forScope /Fo"./" /Gd /errorReport:queue basicsql.cpp
+
+link /OUT:"./basicsql.exe" /NOLOGO "kernel32.lib" "user32.lib" "gdi32.lib" "winspool.lib" "comdlg32.lib" "advapi32.lib" "shell32.lib" "ole32.lib" "oleaut32.lib" "uuid.lib" "odbc32.lib" "odbccp32.lib" /TLBID:1 /DYNAMICBASE /NXCOMPAT /MACHINE:X64 /ERRORREPORT:QUEUE basicsql.obj
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/resources/source/run.bat
----------------------------------------------------------------------
diff --git a/docs/client_install/src/resources/source/run.bat b/docs/client_install/src/resources/source/run.bat
new file mode 100644
index 0000000..98997b9
--- /dev/null
+++ b/docs/client_install/src/resources/source/run.bat
@@ -0,0 +1,23 @@
+@echo off
+REM @@@ START COPYRIGHT @@@
+REM
+REM Licensed to the Apache Software Foundation (ASF) under one
+REM or more contributor license agreements. See the NOTICE file
+REM distributed with this work for additional information
+REM regarding copyright ownership. The ASF licenses this file
+REM to you under the Apache License, Version 2.0 (the
+REM "License"); you may not use this file except in compliance
+REM with the License. You may obtain a copy of the License at
+REM
+REM http://www.apache.org/licenses/LICENSE-2.0
+REM
+REM Unless required by applicable law or agreed to in writing,
+REM software distributed under the License is distributed on an
+REM "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+REM KIND, either express or implied. See the License for the
+REM specific language governing permissions and limitations
+REM under the License.
+REM
+REM @@@ END COPYRIGHT @@@
+
+basicsql.exe Default_Datasource user1 pwd1
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/command_interface/pom.xml
----------------------------------------------------------------------
diff --git a/docs/command_interface/pom.xml b/docs/command_interface/pom.xml
new file mode 100644
index 0000000..d006407
--- /dev/null
+++ b/docs/command_interface/pom.xml
@@ -0,0 +1,219 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
+ <!--
+* @@@ START COPYRIGHT @@@
+*
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements. See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership. The ASF licenses this file
+* to you 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.
+*
+* @@@ END COPYRIGHT @@@
+-->
+ <modelVersion>4.0.0</modelVersion>
+ <groupId>org.apache.trafodion</groupId>
+ <artifactId>command-interface-guide</artifactId>
+ <version>1.3.0</version>
+ <packaging>pom</packaging>
+ <name>Trafodion Command Interface Guide</name>
+ <description>This guide describes how to use the Trafodion Command Interface (TrafCI).</description>
+ <url>http://trafodion.incubator.apache.org</url>
+ <inceptionYear>2015</inceptionYear>
+
+ <licenses>
+ <license>
+ <name>The Apache Software License, Version 2.0</name>
+ <url>http://www.apache.org/licenses/LICENSE-2.0.txt</url>
+ <distribution>repo</distribution>
+ <comments>A business-friendly OSS license</comments>
+ </license>
+ </licenses>
+
+ <organization>
+ <name>Apache Software Foundation</name>
+ <url>http://www.apache.org</url>
+ </organization>
+
+ <issueManagement>
+ <system>JIRA</system>
+ <url>http://issues.apache.org/jira/browse/TRAFODION</url>
+ </issueManagement>
+
+ <scm>
+ <connection>scm:git:http://git-wip-us.apache.org/repos/asf/incubator-trafodion.git</connection>
+ <developerConnection>scm:git:https://git-wip-us.apache.org/repos/asf/incubator-trafodion.git</developerConnection>
+ <url>https://git-wip-us.apache.org/repos/asf?p=incubator-trafodion.git</url>
+ <tag>HEAD</tag>
+ </scm>
+
+ <ciManagement>
+ <system>Jenkins</system>
+ <url>https://jenkins.esgyn.com</url>
+ </ciManagement>
+
+ <properties>
+ <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
+ <asciidoctor.maven.plugin.version>1.5.2.1</asciidoctor.maven.plugin.version>
+ <asciidoctorj.pdf.version>1.5.0-alpha.10.1</asciidoctorj.pdf.version>
+ <asciidoctorj.version>1.5.3.2</asciidoctorj.version>
+ </properties>
+
+ <build>
+ <plugins>
+ <plugin>
+ <groupId>org.apache.maven.plugins</groupId>
+ <artifactId>maven-resources-plugin</artifactId>
+ <version>2.7</version>
+ <configuration>
+ <encoding>UTF-8</encoding>
+ <attributes>
+ <generateReports>false</generateReports>
+ </attributes>
+ </configuration>
+ </plugin>
+ <plugin>
+ <groupId>org.asciidoctor</groupId>
+ <artifactId>asciidoctor-maven-plugin</artifactId>
+ <version>${asciidoctor.maven.plugin.version}</version>
+ <dependencies>
+ <dependency>
+ <groupId>org.asciidoctor</groupId>
+ <artifactId>asciidoctorj-pdf</artifactId>
+ <version>${asciidoctorj.pdf.version}</version>
+ </dependency>
+ <dependency>
+ <groupId>org.asciidoctor</groupId>
+ <artifactId>asciidoctorj</artifactId>
+ <version>${asciidoctorj.version}</version>
+ </dependency>
+ </dependencies>
+ <configuration>
+ <sourceDirectory>${basedir}/src</sourceDirectory>
+ </configuration>
+ <executions>
+ <execution>
+ <id>generate-html-doc</id>
+ <goals>
+ <goal>process-asciidoc</goal>
+ </goals>
+ <phase>site</phase>
+ <configuration>
+ <doctype>book</doctype>
+ <backend>html5</backend>
+ <sourceHighlighter>coderay</sourceHighlighter>
+ <outputDirectory>${basedir}/target/site</outputDirectory>
+ <attributes>
+ <!-- Location of centralized stylesheet -->
+ <stylesheet>${basedir}/../css/trafodion-manuals.css</stylesheet>
+ <projectVersion>1.3.0</projectVersion>
+ <buildDate>${maven.build.timestamp}</buildDate>
+ </attributes>
+ </configuration>
+ </execution>
+ <execution>
+ <id>generate-pdf-doc</id>
+ <phase>site</phase>
+ <goals>
+ <goal>process-asciidoc</goal>
+ </goals>
+ <configuration>
+ <doctype>book</doctype>
+ <backend>pdf</backend>
+ <sourceHighlighter>coderay</sourceHighlighter>
+ <outputDirectory>${basedir}/target</outputDirectory>
+ <attributes>
+ <icons>font</icons>
+ <pagenums/>
+ <toc/>
+ <idprefix/>
+ <idseparator>-</idseparator>
+ </attributes>
+ </configuration>
+ </execution>
+ </executions>
+ </plugin>
+ <!-- Copy files to the web-site end destinations. -->
+ <plugin>
+ <groupId>org.apache.maven.plugins</groupId>
+ <artifactId>maven-antrun-plugin</artifactId>
+ <version>1.8</version>
+ <inherited>false</inherited>
+ <executions>
+ <execution>
+ <id>populate-release-directories</id>
+ <phase>post-site</phase>
+ <configuration>
+ <target name="Populate Release Directories">
+ <!-- The website uses the following organization for the docs/target/docs directory:
+ - To ensure a known location, the base directory contains the LATEST version of the web book and the PDF files.
+ - The know location is docs/target/docs/<document>
+ - target/docs/<version>/<document> contains version-specific renderings of the documents.
+ - target/docs/<version>/<document> contains the PDF version and the web book. The web book is named index.html
+ -->
+ <!-- Copy the PDF file to its target directories -->
+ <copy file="${basedir}/target/index.pdf" tofile="${basedir}/../target/docs/command_interface/Trafodion_Command_Interface_Guide.pdf" />
+ <copy file="${basedir}/target/index.pdf" tofile="${basedir}/../target/docs/${project.version}/command_interface/Trafodion_Command_Interface_Guide.pdf" />
+ <!-- Copy the Web Book files to their target directories -->
+ <copy todir="${basedir}/../target/docs/command_interface">
+ <fileset dir="${basedir}/target/site">
+ <include name="**/*.*"/> <!--All sub-directories, too-->
+ </fileset>
+ </copy>
+ <copy todir="${basedir}/../target/docs/${project.version}/command_interface">
+ <fileset dir="${basedir}/target/site">
+ <include name="**/*.*"/> <!--All sub-directories, too-->
+ </fileset>
+ </copy>
+ </target>
+ </configuration>
+ <goals>
+ <goal>run</goal>
+ </goals>
+ </execution>
+ </executions>
+ </plugin>
+ </plugins>
+ </build>
+
+ <!-- Included because this is required. No reports are generated. -->
+ <reporting>
+ <excludeDefaults>true</excludeDefaults>
+ <plugins>
+ <plugin>
+ <groupId>org.apache.maven.plugins</groupId>
+ <artifactId>maven-project-info-reports-plugin</artifactId>
+ <version>2.8</version>
+ <reportSets>
+ <reportSet>
+ <reports>
+ </reports>
+ </reportSet>
+ </reportSets>
+ </plugin>
+ </plugins>
+ </reporting>
+
+ <distributionManagement>
+ <site>
+ <id>trafodion.incubator.apache.org</id>
+ <name>Trafodion Website at incubator.apache.org</name>
+ <!-- On why this is the tmp dir and not trafodion.incubator.apache.org, see
+ https://issues.apache.org/jira/browse/HBASE-7593?focusedCommentId=13555866&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-13555866
+ -->
+ <url>file:///tmp</url>
+ </site>
+ </distributionManagement>
+</project>