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:19 UTC
[15/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/source/img/Add_Alias_SQuirreL.png
----------------------------------------------------------------------
diff --git a/docs/client_install/source/img/Add_Alias_SQuirreL.png b/docs/client_install/source/img/Add_Alias_SQuirreL.png
deleted file mode 100755
index 51adf98..0000000
Binary files a/docs/client_install/source/img/Add_Alias_SQuirreL.png and /dev/null differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/source/img/Add_Driver_SQuirreL.png
----------------------------------------------------------------------
diff --git a/docs/client_install/source/img/Add_Driver_SQuirreL.png b/docs/client_install/source/img/Add_Driver_SQuirreL.png
deleted file mode 100755
index c72b218..0000000
Binary files a/docs/client_install/source/img/Add_Driver_SQuirreL.png and /dev/null differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/source/img/Database_Connection_in_DbVisualizer.png
----------------------------------------------------------------------
diff --git a/docs/client_install/source/img/Database_Connection_in_DbVisualizer.png b/docs/client_install/source/img/Database_Connection_in_DbVisualizer.png
deleted file mode 100755
index c21e4c3..0000000
Binary files a/docs/client_install/source/img/Database_Connection_in_DbVisualizer.png and /dev/null differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/source/img/DbVisualizer_Driver_Manager.png
----------------------------------------------------------------------
diff --git a/docs/client_install/source/img/DbVisualizer_Driver_Manager.png b/docs/client_install/source/img/DbVisualizer_Driver_Manager.png
deleted file mode 100755
index 422afbf..0000000
Binary files a/docs/client_install/source/img/DbVisualizer_Driver_Manager.png and /dev/null differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/source/img/Extracted_Files.png
----------------------------------------------------------------------
diff --git a/docs/client_install/source/img/Extracted_Files.png b/docs/client_install/source/img/Extracted_Files.png
deleted file mode 100755
index ebff90b..0000000
Binary files a/docs/client_install/source/img/Extracted_Files.png and /dev/null differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/source/img/InstallComplete.png
----------------------------------------------------------------------
diff --git a/docs/client_install/source/img/InstallComplete.png b/docs/client_install/source/img/InstallComplete.png
deleted file mode 100755
index 63ffa55..0000000
Binary files a/docs/client_install/source/img/InstallComplete.png and /dev/null differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/source/img/InstallerWizardPaths.png
----------------------------------------------------------------------
diff --git a/docs/client_install/source/img/InstallerWizardPaths.png b/docs/client_install/source/img/InstallerWizardPaths.png
deleted file mode 100755
index 0e333a2..0000000
Binary files a/docs/client_install/source/img/InstallerWizardPaths.png and /dev/null differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/source/img/InstallerWizardWelcome.png
----------------------------------------------------------------------
diff --git a/docs/client_install/source/img/InstallerWizardWelcome.png b/docs/client_install/source/img/InstallerWizardWelcome.png
deleted file mode 100755
index 76f0b10..0000000
Binary files a/docs/client_install/source/img/InstallerWizardWelcome.png and /dev/null differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/source/img/JDBC_JAR_Path.png
----------------------------------------------------------------------
diff --git a/docs/client_install/source/img/JDBC_JAR_Path.png b/docs/client_install/source/img/JDBC_JAR_Path.png
deleted file mode 100755
index 9b4039e..0000000
Binary files a/docs/client_install/source/img/JDBC_JAR_Path.png and /dev/null differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/source/img/OptionalComponents.png
----------------------------------------------------------------------
diff --git a/docs/client_install/source/img/OptionalComponents.png b/docs/client_install/source/img/OptionalComponents.png
deleted file mode 100755
index 0fa10bf..0000000
Binary files a/docs/client_install/source/img/OptionalComponents.png and /dev/null differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/source/img/PerlJavaServerURL.png
----------------------------------------------------------------------
diff --git a/docs/client_install/source/img/PerlJavaServerURL.png b/docs/client_install/source/img/PerlJavaServerURL.png
deleted file mode 100755
index b57c6d2..0000000
Binary files a/docs/client_install/source/img/PerlJavaServerURL.png and /dev/null differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/source/img/Physical_Connection.png
----------------------------------------------------------------------
diff --git a/docs/client_install/source/img/Physical_Connection.png b/docs/client_install/source/img/Physical_Connection.png
deleted file mode 100755
index 0adacfc..0000000
Binary files a/docs/client_install/source/img/Physical_Connection.png and /dev/null differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/source/img/Properties_for_Alias_SQuirreL.png
----------------------------------------------------------------------
diff --git a/docs/client_install/source/img/Properties_for_Alias_SQuirreL.png b/docs/client_install/source/img/Properties_for_Alias_SQuirreL.png
deleted file mode 100755
index be9d497..0000000
Binary files a/docs/client_install/source/img/Properties_for_Alias_SQuirreL.png and /dev/null differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/source/img/ProxySettings.png
----------------------------------------------------------------------
diff --git a/docs/client_install/source/img/ProxySettings.png b/docs/client_install/source/img/ProxySettings.png
deleted file mode 100755
index 6f535b2..0000000
Binary files a/docs/client_install/source/img/ProxySettings.png and /dev/null differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/source/img/TQW_control_options.png
----------------------------------------------------------------------
diff --git a/docs/client_install/source/img/TQW_control_options.png b/docs/client_install/source/img/TQW_control_options.png
deleted file mode 100755
index 584816b..0000000
Binary files a/docs/client_install/source/img/TQW_control_options.png and /dev/null differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/source/img/TQW_login.png
----------------------------------------------------------------------
diff --git a/docs/client_install/source/img/TQW_login.png b/docs/client_install/source/img/TQW_login.png
deleted file mode 100755
index 111edf9..0000000
Binary files a/docs/client_install/source/img/TQW_login.png and /dev/null differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/source/img/TQW_logout.png
----------------------------------------------------------------------
diff --git a/docs/client_install/source/img/TQW_logout.png b/docs/client_install/source/img/TQW_logout.png
deleted file mode 100755
index 10715fd..0000000
Binary files a/docs/client_install/source/img/TQW_logout.png and /dev/null differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/source/img/TQW_query_plan.png
----------------------------------------------------------------------
diff --git a/docs/client_install/source/img/TQW_query_plan.png b/docs/client_install/source/img/TQW_query_plan.png
deleted file mode 100755
index 8ad6354..0000000
Binary files a/docs/client_install/source/img/TQW_query_plan.png and /dev/null differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/source/img/TQW_session.png
----------------------------------------------------------------------
diff --git a/docs/client_install/source/img/TQW_session.png b/docs/client_install/source/img/TQW_session.png
deleted file mode 100755
index 74663a7..0000000
Binary files a/docs/client_install/source/img/TQW_session.png and /dev/null differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/source/img/TQW_whiteboard.png
----------------------------------------------------------------------
diff --git a/docs/client_install/source/img/TQW_whiteboard.png b/docs/client_install/source/img/TQW_whiteboard.png
deleted file mode 100755
index 6b41ad1..0000000
Binary files a/docs/client_install/source/img/TQW_whiteboard.png and /dev/null differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/source/img/path2.png
----------------------------------------------------------------------
diff --git a/docs/client_install/source/img/path2.png b/docs/client_install/source/img/path2.png
deleted file mode 100755
index 5779c63..0000000
Binary files a/docs/client_install/source/img/path2.png and /dev/null differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/source/img/varval2.png
----------------------------------------------------------------------
diff --git a/docs/client_install/source/img/varval2.png b/docs/client_install/source/img/varval2.png
deleted file mode 100755
index 1f44dda..0000000
Binary files a/docs/client_install/source/img/varval2.png and /dev/null differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/source/xml-profile.xml
----------------------------------------------------------------------
diff --git a/docs/client_install/source/xml-profile.xml b/docs/client_install/source/xml-profile.xml
deleted file mode 100755
index 4a470f7..0000000
--- a/docs/client_install/source/xml-profile.xml
+++ /dev/null
@@ -1,41 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<!--
-* @@@ 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 @@@
--->
-
-<!--Arbortext, Inc., 1988-2014, v.4002-->
-<!DOCTYPE xidi:xidi PUBLIC "-//Apache Software Foundation (ASF)//DTD XIDI Specifications V1.0//EN"
- "xidi-xidi.dtd">
-<xidi:xidi>
-<!--Profiling Information-->
-<xidi:conditionSet>
-<xidi:conditional refCondition="hidden" value="off"/>
-</xidi:conditionSet>
-<!--Parameters specific to PDF rendering-->
-<xidi:pdfSpec>
-<xidi:paper.type value="HPA1-8.26x11"/>
-<xidi:secondary.color value="medium.blue"/>
-<xidi:dragonParam name="variablelist.as.blocks" value="1"/>
-<!--Be sure to set document status value="final" for the final copy-->
-<xidi:document.status value="final"/>
-</xidi:pdfSpec>
-</xidi:xidi>
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/asciidoc/_chapters/SQuirrel.adoc
----------------------------------------------------------------------
diff --git a/docs/client_install/src/asciidoc/_chapters/SQuirrel.adoc b/docs/client_install/src/asciidoc/_chapters/SQuirrel.adoc
new file mode 100644
index 0000000..1f88b98
--- /dev/null
+++ b/docs/client_install/src/asciidoc/_chapters/SQuirrel.adoc
@@ -0,0 +1,68 @@
+////
+/**
+ *@@@ 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 @@@
+ */
+////
+
+= Configure SQuirreL Client
+These configuration instructions apply to Trafodion Release 1.3.*_n_* and subsequent updates of Trafodion until otherwise indicated.
+
+== Prerequisite Software
+
+Make sure that you have this software installed on your workstation:
+
+* Java Runtime Environment (JRE) 1.7 or higher. See <<jdbct4_JRE, Install Java Runtime Environment (JRE)>>.
+* Trafodion JDBC Type-4 Driver. See <<jdbct4_install, JDBC Type-4 Installation>>.
+* SQuirreL SQL Client 3.5.0. See the http://squirrel-sql.sourceforge.net/[_SQuirreL SQL Client website_].
+
+<<<
+== Configuration Instructions
+=== Register JDBC Type-4 Driver
+
+Use the *Add Driver* function and register the Trafodion JDBC Type-4 Driver:
+
+1. Click on the *Add* button and locate the Trafodion JDBC Type-4 Driver.
+2. Click on the *List Drivers* button to find the JDBC Driver Class Name.
+3. Set the properties as shown below:
++
+image:{images}/Add_Driver_SQuirreL.jpg[image]
++
+* Name: `Trafodion`
+* Example URL: `jdbc:t4jdbc://_host-name or ip-address_:37800/:`
+
+<<<
+=== Connect to Trafodion
+
+Use the Add Alias dialog box and create an alias for your Trafodion System:
+
+image:{images}/Add_Alias_SQuirreL.jpg[image]
+
+1. Edit the connection *URL* to match your Trafodion system's host name and port number:
++
+====
+*jdbc:t4jdbc://_host-name or ip-address_:37800/:*
+====
+
+2. Click on the *Properties* button for the alias.
+3. In the *Schemas* tab, select the option *Load all and cache all Schemas*.
++
+image:{images}/Properties_for_Alias_SQuirreL.jpg[image]
+
+Once you have a successful connection, use the SQL tab and run a query to confirm the connection.
+
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/asciidoc/_chapters/about.adoc
----------------------------------------------------------------------
diff --git a/docs/client_install/src/asciidoc/_chapters/about.adoc b/docs/client_install/src/asciidoc/_chapters/about.adoc
new file mode 100644
index 0000000..6c38694
--- /dev/null
+++ b/docs/client_install/src/asciidoc/_chapters/about.adoc
@@ -0,0 +1,112 @@
+////
+/**
+* @@@ 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 @@@
+ */
+////
+
+= About This Document
+This manual describes how to install and configure client applications that enable you to connect to and use a Trafodion database.
+
+== Intended Audience
+This manual is intended for users who want to connect to and use a Trafodion database.
+
+== New and Changed Information
+This manual shows updated versions for Trafodion Release 1.3.0. It also provides instructions on how to download and install <<odb,Trafodion odb>>, a
+new multi-threaded, ODBC-based command-line tool for parallel data loading and extracting.
+
+== Notation Conventions
+This list summarizes the notation conventions for syntax presentation in this manual.
+
+[cols="15%,30%,25%,30%",options="header"]
+|===
+| Notation | Usage | Example | Notes
+| UPPERCASE LETTERS | Uppercase letters indicate keywords and reserved words. Type these items exactly as shown. Items not enclosed in brackets are required. | SELECT |
+| _Italic Letters_ | Italic letters, regardless of font, indicate variable items that you supply. Items not enclosed in brackets are required. | _file-name_ |
+| `Computer Type` | Computer type letters within text indicate case-sensitive keywords and reserved words. Type these items exactly as shown. Items not enclosed in
+brackets are required. | `myfile.sh` |
+| *Bold Text* | Bold text in an example indicates user input typed at the terminal. | `ENTER RUN CODE:` +
+ ?**123** +
+ `CODE RECEIVED: 123.00` | The user must press the Return key after typing the input.
+| [ ] Brackets | Brackets enclose optional syntax items. |
+DATETIME [__start-field__ TO] +
+_end-field_
+| A group of items enclosed in brackets is a list from which you can choose one item or none.
+
+The items in the list can be arranged either vertically, with aligned brackets on each side of the list, or horizontally, enclosed in a pair of brackets and separated by vertical lines.
+
+For example:
+
+`DROP SCHEMA _schema_ [CASCADE]` +
+`DROP SCHEMA _schema_ [ CASCADE \| RESTRICT ]`
+| { } Braces | Braces enclose required syntax items. | `FROM { __grantee__[, __grantee__]...}` | A group of items enclosed in braces is a list from which you are required to choose one item.
+
+The items in the list can be arranged either vertically, with aligned braces on each side of the list, or horizontally, enclosed in a pair of braces and separated by vertical lines.
+
+For example:
+
+`INTERVAL { _start-field_ TO _end-field_ }` +
+`{ _single-field_ }` +
+`INTERVAL { _start-field_ TO _end-field_ \| _single-field_ }`
+--
+| \| Vertical Line | A vertical line separates alternatives in a horizontal list that is enclosed in brackets or braces. | `{__expression__ \| NULL}` |
+| … Ellipsis | An ellipsis immediately following a pair of brackets or braces indicates that you can repeat the enclosed sequence of syntax items any number of times. |
+`ATTRIBUTE[S] _attribute_ [, __attribute__]...` +
+`{, __sql-expression__}...`
+| An ellipsis immediately following a single syntax item indicates that you can repeat that syntax item any number of times.
+
+For example:
+
+`__expression-n__…`
+| Punctuation | Parentheses, commas, semicolons, and other symbols not previously described must be typed as shown. |
+DAY (__datetime-expression__)` +
+`@__script-file__` | Quotation marks around a symbol such as a bracket or brace indicate the symbol is a required character that you must type as shown.
+
+For example:
+
+`"{" _module-name_ [, __module-name__]... "}"`
+| Item Spacing | Spaces shown between items are required unless one of the items is a punctuation symbol such as a parenthesis or a comma. |
+`DAY (__datetime-expression__) DAY(__datetime-expression__)` | If there is no space between two items, spaces are not permitted. In this example, no spaces are permitted between the period and any other items:
+
+`__myfile__.sh`
+
+| Line Spacing | If the syntax of a command is too long to fit on a single line, each continuation line is indented three spaces and is separated from the preceding line by a blank line.
+
+This spacing distinguishes items in a continuation line from items in a vertical list of selections. |
+`_match-value_ [NOT] LIKE _pattern_`
+ [ESCAPE __esc-char-expression__] |
+|===
+
+== Publishing History
+[cols="2*",options="header"]
+|===
+| Product Version | Publication Date
+| Trafodion Release 1.3.0 | To be announced.
+|===
+
+== Comments Encouraged
+The Trafodion community encourages your comments concerning this document. We are committed to providing documentation that meets your
+needs. Send any errors found, suggestions for improvement, or compliments to:
+
+issues@trafodion.incubator.apache.org
+
+Include the document title and any comment, error found, or suggestion for improvement you have concerning this document.
+
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/asciidoc/_chapters/dbviz.adoc
----------------------------------------------------------------------
diff --git a/docs/client_install/src/asciidoc/_chapters/dbviz.adoc b/docs/client_install/src/asciidoc/_chapters/dbviz.adoc
new file mode 100644
index 0000000..ee82f0b
--- /dev/null
+++ b/docs/client_install/src/asciidoc/_chapters/dbviz.adoc
@@ -0,0 +1,84 @@
+////
+/**
+ *@@@ 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 @@@
+ */
+////
+
+= Configure DbVisualizer
+These configuration instructions apply to Trafodion Release 1.3.*_n_* and subsequent updates of Trafodion until otherwise indicated.
+
+== Prerequisite Software
+
+Make sure that you have this software installed on your workstation:
+
+* Java Runtime Environment (JRE) 1.7 or higher.
++
+See <<jdbct4_JRE, Install Java Runtime Environment (JRE)>>.
++
+In addition, see DbVisualizer’s FAQ “How to” page:
+http://confluence.dbvis.com/pages/viewpage.action?pageId=3146120[_How do I change the Java version that DbVisualizer uses?_]
+* Trafodion JDBC Type-4 Driver. See <<jdbct4_install, JDBC Type-4 Installation>>.
+* DbVisualizer 9.x.x. See the http://www.dbvis.com/[_DbVisualizer website_].
+
+== Configuration Instructions
+
+=== Disable Connection Validation Select Option
+
+==== DbVisualizer 9.1 (or an earlier version)
+Edit the `_DbVisualizer-Install-Dir_\resources\dbvis-custom.prefs` file and
+disable the `ConnectionValidationSelect` option as shown below:
+
+====
+*dbvis.generic.-ConnectionValidationSelect=disabled*
+====
+
+==== DbVisualizer 9.2 (or a later version)
+Set the *Physical Connection* property to keep your connections alive. Follow these steps:
+
+1. For the database connection, select the *Properties* tab.
+2. In the left navigation tree, expand the *Generic* connection properties, and select *Physical Connection*.
+3. Under *Validation SQL*, enter `values(current_timestamp)`.
++
+<<<
+image:{images}/Physical_Connection.jpg[width=600,height=600,alt="DbVisualizer Physical Connection"]
+
+<<<
+=== Register JDBC Type-4 Driver
+
+Use the DbVisualizer Driver Manager and register the Trafodion JDBC Type-4 Driver.
+
+image:{images}/DbVisualizer_Driver_Manager.jpg[image]
+
+* Use the Open File icon and locate the Trafodion JDBC Type-4 Driver.
+* Use the JDBC URL format:
++
+====
+*jdbc:t4jdbc://_host-name or ip-address_:37800/:*
+====
+
+<<<
+=== Connect to Trafodion
+
+Create a new connection by selecting the Trafodion JDBC Type-4 Driver and filling in the connection parameters. Edit the database URL to match
+your Trafodion system’s host name and port number: `jdbc:t4jdbc://_host-name or ip-address_:37800/:`
+
+image:{images}/Database_Connection_in_DbVisualizer.jpg[image]
+
+Once you have connected successfully, execute a query using SQL Commander to confirm the connection.
+
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/asciidoc/_chapters/introduction.adoc
----------------------------------------------------------------------
diff --git a/docs/client_install/src/asciidoc/_chapters/introduction.adoc b/docs/client_install/src/asciidoc/_chapters/introduction.adoc
new file mode 100644
index 0000000..f9d6ed1
--- /dev/null
+++ b/docs/client_install/src/asciidoc/_chapters/introduction.adoc
@@ -0,0 +1,49 @@
+////
+/**
+ *@@@ 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 Products
+This manual describes how to install and configure the following client applications, which enable you to connect to and use a Trafodion
+database.
+
+== Client Summary
+The following table lists the clients supported by Trafodion.
+[cols="30%h,70%",options="header"]
+|===
+| Client Name | Description
+| Trafodion ODBC Driver for Windows | A driver that enables applications, which were developed for the Microsoft Open Database Connectivity (ODBC) application programming
+interface (API) and which run on a Windows workstation, to connect to a Trafodion database.
+| Trafodion ODBC Driver for Linux | A driver that enables applications, which were developed for the Microsoft ODBC API and run on a Linux workstation, to connect to a
+Trafodion database.
+| Trafodion JDBC Type 4 Driver | A driver that enables Java applications that run on a client workstation to connect to a Trafodion database.
+
+NOTE: The Trafodion Command Interface (TrafCI), DbVisualizer, and SQuirreL SQL Client require this driver to be installed on the client
+workstation.
+| Trafodion Command Interface (TrafCI) | A command-line interface that allows you to connect to a Trafodion database and run SQL statements and other commands interactively or from
+script files. For more information, see the __Trafodion Command Interface Guide__.
+| Trafodion odb tool | A multi-threaded, ODBC-based command-line tool for parallel data loading and extracting. For more information, see the __Trafodion odb User
+Guide__.
+| DbVisualizer | A third-party database tool that allows you to connect to a Trafodion database. For more information, see the http://www.dbvis.com/[_DbVisualizer website_].
+| SQuirreL SQL Client | A third-party database tool that allows you to connect to a Trafodion database. For more information, see the
+http://squirrel-sql.sourceforge.net/[_SQuirreL SQL Client website_].
+|===
+
+
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/asciidoc/_chapters/jdbct4.adoc
----------------------------------------------------------------------
diff --git a/docs/client_install/src/asciidoc/_chapters/jdbct4.adoc b/docs/client_install/src/asciidoc/_chapters/jdbct4.adoc
new file mode 100644
index 0000000..d213856
--- /dev/null
+++ b/docs/client_install/src/asciidoc/_chapters/jdbct4.adoc
@@ -0,0 +1,344 @@
+////
+/**
+ *@@@ 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 JDBC Type-4 Driver
+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 JDBC Type 4 Driver 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 the Trafodion JDBC Type 4 Driver:
+
+[cols="35%,35%,30%",options="header"]
+|===
+| Distribution File | Description | Client Operating System
+| `JDBCT4.zip` | Zip file | Windows or Linux
+|===
+
+By default, a new version of the JDBC Type 4 driver will be installed in this directory and its folders unless you specify a
+different directory during installation:
+
+[cols="65%,35%",options="header"]
+|===
+| Default Installation Directory | Client Operating System
+| `_<user-specified directory>_` (For example: `/usr/local/jdbc)` | Windows or Linux
+|===
+
+[cols="30%,25%,45%",options="header"]
+|===
+| Installation Folder | Files | Description
+| `/lib` | `jdbcT4.jar` | Product JAR file.
+| `/samples` | `t4jdbc.properties` | Properties file that you can configure for your application environment.
+| | `README` | Readme file that explains how to use the common sample set.
+| `/samples/common` | `sampleUtils.java` | Sample source code for creating, populating, and dropping sample tables.
+| `/samples/DBMetaSample` | `DBMetaSample.java` | Sample source code for getting metadata about the sample tables.
+| | `README` | Readme file that explains how to use this sample set.
+| `/samples/PreparedStatementSample` | `PreparedStatementSample.java` | Sample code for simple or parameterized SELECT statements that are prepared.
+| | `README` | Readme file that explains how to use this sample set.
+| `/samples/ResultSetSample` | `README` | Readme file that explains how to use this sample set.
+| | `ResultSetSample.java` | Sample source code for fetching rows from a result set.
+| `/samples/StatementSample` | `README` | Readme file that explains how to use this sample set.
+| | `StatementSample.java` | Sample source code for fetching rows from a simple SELECT statement.
+|===
+
+== Installation Requirements
+
+The Trafodion JDBC Type 4 Driver requires a Java-enabled platform that supports the Java Development Kit (JDK) 1.7 or higher.
+
+To determine the Java version that you have installed on your client workstation and to install a supported version, please refer to
+<<jdbct4_JRE, Install Java Runtime Environment (JRE)>> below.
+
+[[jdbct4_JRE]]
+=== Install Java Runtime Environment (JRE)
+
+The Trafodion JDBC Type 4 Driver requires 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.
+
+==== Verify Java Version
+
+To display the Java version of the client workstation on the screen, enter:
+
+====
+*java -version*
+====
+
+====
+`C:\>` *java -version*
+```
+java version "1.7.0_45" #_This is the version you need to check_
+Java(TM) SE Runtime Environment (build 1.7.0_45-b18)
+Java HotSpot(TM) Client VM (build 24.45-b08, mixed mode, sharing)
+C:\>`
+====
+
+The Java version should be *1.7* or higher. If the returned version is not supported, please refer to
+<<jdbct4_install_java, Installing a Supported Java Version>> below.
+
+<<<
+If you see this message:
+
+====
+```
+'java' is not recognized as an internal or external command, operable program or batch file.`
+```
+====
+
+It indicates that the Java PATH is not set. Follow one of these sets of instructions, depending on the operating system of your client
+workstation:
+
+* <<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>>
+
+[[jdbct4_install_java]]
+==== Install Supported Java Version
+
+The supported Java version is 1.7 or higher. To install one of the supported Java versions on the client workstation,
+go to this link: http://www.java.com/en/download
+
+After installing the Java version, proceed with setting the Java path. Follow one of these sets of instructions, depending on the operating
+system of your client workstation:
+
+* <<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>>
+
+[[jdbct4_path_windows]]
+==== Set Windows PATH Variable
+
+1. Right-click the *Computer* icon on your desktop, and then select *Properties*. The *Control Panel > System and Security > System* window
+appears.
+2. In the left navigation bar, click the *Advanced* system settings link.
+3. In the *System Properties* dialog box, click the *Environment Variables* button.
+4. Under *System* variables, select the variable named *Path*, and then click *Edit*:
++
+image:{images}/path2.jpg[image]
+
+5. Place the cursor at the start of the *Variable* value field and enter the path of the Java bin directory, ending with a semicolon (;):
++
+image:{images}/varval2.jpg[image]
++
+*Example*
++
+====
+*"C:\Program Files (x86)\Java\jre7\bin";*
+====
++
+NOTE: Check that no space exists after the semicolon (;) in the path. If there are spaces in the directory name, delimit the entire directory
+path in double quotes (") before the semicolon.
+
+6. Click *OK*.
+7. Verify that the updated *Path* appears under *System* variables, and click *OK*.
+8. In the *System Properties* dialog box, click *OK* to accept the changes.
+
+[[jdbct4_path_linux]]
+==== Set Linux PATH Variable
+
+1. Open the user profile (`.profile` or `.bash_profile` for the Bash shell) in the `$HOME` directory.
++
+====
+*cd $HOME* +
+*vi .profile*
+====
+
+2. In the user profile, set the `PATH` environment variable to include the path of the Java bin
+directory.
++
+====
+*export PATH=/opt/java1.7/jre/bin:$PATH*
+====
++
+NOTE: Place the path of the Java bin directory before `$PATH`, and check that no space exists after the colon (:) in the path. In the C shell,
+use the setenv command instead of export.
+
+3. To activate the changes, either log out and log in again or execute the user profile.
++
+====
+*. .profile*
+====
+
+<<<
+[[jdbct4_install]]
+== Installation Instructions
+
+[[jdbct4_download]]
+=== Download JDBC Type-4 Driver
+
+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 `JDBCT4.zip` distribution file, which is extracted to the clients subdirectory.
+
+6. Proceed with <<jdbct4_install_zip, Installing the Trafodion JDBC Type 4 Driver From the Zip File>> below.
+
+[[jdbct4_install_zip]]
+=== Install JDBC Type-4 Driver
+
+1. Change the directory to the clients subdirectory.
+2. Extract the contents of the `JDBCT4.zip` file by using the unzip command (or the WinZip extract tool):
++
+====
+*unzip JDBCT4.zip*
+====
++
+The command creates these subdirectories:
++
+* `lib`, which contains the `jdbcT4.jar` file
+* `samples`, which contains sample programs
+
+3. Set up the client environment. See <<jdbct4_setup_env, Set Up Client Environment>>.
+
+<<<
+=== Uninstall JDBC Type-4 Driver
+Run one of these sets of commands to remove the Trafodion JDBC Type 4 Driver:
+
+* On Linux:
++
+====
+*rm -rf _jdbc-installation-directory_*
+====
++
+*Example*
++
+====
+*rm -rf /usr/local/jdbc*
+====
+
+<<<
+* On Windows:
++
+====
+*del _jdbc-installation-directory_* +
+*rmdir _jdbc-installation-directory_*
+====
++
+*Example*
++
+Windows uninstall
++
+====
+`C:\>`*del /s JDBC +
+`C:\JDBC\*, Are you sure (Y/N)?` *Y* +
+`C:\JDBC\install\*, Are you sure (Y/N)?` *Y*
+```
+Deleted file - C:\JDBC\install\t4jdbcSanityCheck.class
+Deleted file - C:\JDBC\install\t4jdbcUninstall.class
+Deleted file - C:\JDBC\install\product.contents
+```
+`C:\JDBC\lib\*, Are you sure (Y/N)?` *Y*
+```
+Deleted file - C:\JDBC\lib\jdbcT4.jar
+```
+`C:\JDBC\samples\*, Are you sure (Y/N)?` *Y*
+```
+Deleted file - C:\JDBC\samples\t4jdbc.properties
+Deleted file - C:\JDBC\samples\README
+```
+`C:\JDBC\samples\common\*, Are you sure (Y/N)?` *Y*
+```
+Deleted file - C:\JDBC\samples\common\sampleUtils.java
+```
+`C:\JDBC\samples\DBMetaSample\*, Are you sure (Y/N)?` *Y*
+```
+Deleted file - C:\JDBC\samples\DBMetaSample\DBMetaSample.java
+Deleted file - C:\JDBC\samples\DBMetaSample\README
+```
+`C:\JDBC\samples\PreparedStatementSample\*, Are you sure (Y/N)?` *Y*
+```
+Deleted file - C:\JDBC\samples\PreparedStatementSample\PreparedStatementSample.java
+Deleted file - C:\JDBC\samples\PreparedStatementSample\README
+```
+`C:\JDBC\samples\ResultSetSample\*, Are you sure (Y/N)?` *Y*
+```
+Deleted file - C:\JDBC\samples\ResultSetSample\README
+Deleted file - C:\JDBC\samples\ResultSetSample\ResultSetSample.java
+```
+`C:\JDBC\samples\StatementSample\*, Are you sure (Y/N)?` *Y*
+```
+Deleted file - C:\JDBC\samples\StatementSample\README
+Deleted file - C:\JDBC\samples\StatementSample\StatementSample.java
+```
+`C:\>`*rmdir /s JDBC* +
+`JDBC, Are you sure (Y/N)?` *Y* +
+`C:\>`
+====
+
+=== Reinstall JDBC Type-4 Driver
+
+1. Close all applications running on the workstation, except the Web browser.
+2. In the browser, navigate to the download site and download the client package file. For more information, please refer to
+<<jdbct4_download, Downloading the Trafodion JDBC Type 4 Driver>>.
+3. Extract the contents of the zip file by following these instructions: <<jdbct4_install_zip, Installing the Trafodion JDBC Type 4 Driver From the Zip File>>.
+4. Set up the client environment. Please refer to: <<jdbct4_setup_env, Setting Up the Client Environment>>.
+
+<<<
+[[jdbct4_setup_env]]
+== Set Up Client Environment
+
+Check that you have a supported Java version installed on the client workstation. The supported Java version is 1.7 or higher. For more
+information, see <<jdbct4_JRE, Installing and Verifying the Java Runtime>>.
+
+If you plan to write and run Java applications that use the Trafodion JDBC Type 4 Driver to connect to a Trafodion database, set these
+environment variables on the client workstation, replacing `_jdk-directory_` with the location of your Java Development Kit and
+replacing `_jdbc-installation-directory_` with the name of the directory where you downloaded the JDBC Type 4 driver:
+
+[cols="20%,40%,40%",options="header"]
+|===
+| Environment Variable | On Windows | On Linux
+| `JAVA_HOME` | `set JAVA_HOME=_jdk-directory_` | `export JAVA_HOME=_jdk-directory_`
+| `PATH` | `set PATH=%PATH%;%JAVA_HOME%\bin` | `export PATH=$PATH:$JAVA_HOME/bin`
+| `CLASSPATH` | `set CLASSPATH=%CLASSPATH%;_jdbc-installation-directory_\lib\jdbcT4.jar;` | `export CLASSPATH=$CLASSPATH:_jdbc-installation-directory_/lib/jdbcT4.jar:`
+|===
+
+=== Configure Applications
+
+Edit the `t4jdbc.properties` file. Set these values for your environment:
+
+* `catalog`: Specify a catalog that exists in the database.
+* `schema`: Specify a schema that exists in the database.
+* `user`: Specify the name of a user who will be accessing the database.
+* `password`: Specify the password of a user who will be accessing the database.
+* `url`: Specify this string: `jdbc:t4jdbc://_host-name_:_port-number_/:`
+
+`_host-name_` is the IP address or host name of the database platform, and `_port-number_` is the location where the
+Trafodion Database Connectivity Service (DCS) is running, which is `37800` by default.
+
+*Example*
+
+====
+```
+catalog = _your-catalog_ schema = _your-schema_ user = _user-name_
+password = _password_
+
+url = jdbc:t4jdbc://_host-name_:_port-number_/:
+```
+====
+
+NOTE: The driver’s class name is `org.trafodion.jdbc.t4.T4Driver`.
+
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/asciidoc/_chapters/odb.adoc
----------------------------------------------------------------------
diff --git a/docs/client_install/src/asciidoc/_chapters/odb.adoc b/docs/client_install/src/asciidoc/_chapters/odb.adoc
new file mode 100644
index 0000000..a9e1e98
--- /dev/null
+++ b/docs/client_install/src/asciidoc/_chapters/odb.adoc
@@ -0,0 +1,98 @@
+////
+/**
+ *@@@ 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 odb
+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 odb 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 odb:
+
+[cols="35%,35%,30%",options="header"]
+|===
+| Distribution File | File Contents | Client Operating System
+| `odb64_linux.tar.gz` | `README` +
+`/bin/odb64luo` | 64-bit Linux
+|===
+
+== Installation Requirements
+
+The odb tool runs on 64-bit Linux. On a Linux workstation, odb requires `pthread` libraries, which are usually installed by default. It also
+requires the unixODBC Driver Manager to be installed and configured on the client workstation. For more information, see the
+http://trafodion.apache.org/docs/odb_user/index.html[_Trafodion odb User Guide_].
+
+== Installation Instructions
+
+NOTE: Before following these installation instructions, please make sure to install and configure unixODBC on the client workstation. For more
+information, see the http://trafodion.apache.org/docs/odb_user/index.html[_Trafodion odb User Guide_].
+
+Follow these instructions to download and install odb on the client workstation.
+
+* <<odb_download, Downloading odb>>
+* <<odb_install, Installing odb>>
+
+To uninstall odb, please refer to <<odb_uninstall, Uninstalling odb>>.
+
+[[odb_download]]
+=== Download odb
+
+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 `odb64_linux.tar.gz` distribution file, which is extracted to the clients subdirectory.
+
+6. Proceed with <<odb_install, Installing odb>>.
+
+[[odb_install]]
+=== Install odb
+
+1. Change the directory to the clients subdirectory.
+2. Unpack the contents of the `odb64_linux.tar.gz` file to a location on your client workstation:
++
+====
+*tar -xzf odb64_linux.tar.gz*
+====
++
+The command extracts these files:
++
+* `README`
+* `/bin/odb64luo` `odb64luo` is the odb executable.
+
+3. You are now ready to run the odb executable. For more information, see the http://trafodion.apache.org/docs/odb_user/index.html[_Trafodion odb User Guide_].
+
+[[odb_uninstall]]
+=== Uninstall odb
+
+To uninstall odb, delete the `README` and `/bin/odb64luo` files from their installed location.
+
+====
+*rm -rf _odb-installation-directory_*
+====
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/asciidoc/_chapters/odbc_linux.adoc
----------------------------------------------------------------------
diff --git a/docs/client_install/src/asciidoc/_chapters/odbc_linux.adoc b/docs/client_install/src/asciidoc/_chapters/odbc_linux.adoc
new file mode 100644
index 0000000..340f9eb
--- /dev/null
+++ b/docs/client_install/src/asciidoc/_chapters/odbc_linux.adoc
@@ -0,0 +1,314 @@
+////
+/**
+ *@@@ 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 Linux ODBC Driver
+These installation instructions apply to Trafodion Release 1.3.*_n_* and subsequent updates of the product until otherwise indicated.
+
+== Installation Packaged
+
+The distribution file for the Trafodion ODBC Driver for Linux 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.
+
+`TRAF_ODBC_Linux_Driver_64.tar.gz` is used to install the Trafodion ODBC Driver for Linux. It contains the following files:
+
+====
+```
+connect_test.cpp
+install.sh
+libicudataNv44.so.44
+libicuucNv44.so.44
+libtrafodbc_l64.so
+libtrafodbc_l64_drvr.so
+LICENSE
+license.txt
+MD5SUM
+TRAFDSN
+```
+====
+
+By default, a new version of the Trafodion ODBC driver will be installed in the following directories unless you specify a different directory
+during installation:
+
+* `/usr/lib64`
+* `/etc/odbc`
+
+NOTE: The following header files are not packaged with the Trafodion ODBC driver:
+
+* `sql.h`
+* `sqlext.h`
+* `sqltypes.h`
+* `sqlucode.h`
+
+To install those header files, <<win_odbc_client_env, Setting Up the Client Environment>>..
+
+<<<
+== Installation Requirements
+
+The driver for Linux requires `libgcc 3.4.3` and `libstd++ 6.0`.
+
+If you are building ODBC applications, please use the preferred build platform, RedHat 6.4 or CentOS 6.4.
+
+== Installation Instructions
+
+=== Download Linux ODBC Driver
+
+1. Create a download folder on the client workstation.
+2. Open a Web browser and navigate to http://trafodion.incubator.apache.org/download.html.
+3. Click on the `clients-1.3.*_n_*.tar.gz` link to start downloading the Trafodionclients 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 Trafodion ODBC distribution file, `TRAF_ODBC_Linux_Driver_64.tar.gz`, which is extracted to the clients subdirectory.
+
+=== Install/Reinstall Linux ODBC Driver
+
+NOTE: You must have root access to install the Trafodion ODBC Driver for Linux at the default system location.
+
+1. Change the directory to the clients subdirectory, and decompress the `.tar.gz` distribution file:
++
+====
+*gunzip TRAF_ODBC_Linux_Driver_64.tar.gz*
+====
+2. Extract the contents of the `.tar` file. A directory called `PkgTmp` is created.
++
+====
+*tar –xvf TRAF_ODBC_Linux_Driver_64.tar*
+====
++
+<<<
+
+3. Install the product by entering these commands:
++
+====
+*cd PkgTmp +
+*./install.sh*
+====
++
+Except for the sample file, the `install.sh` script saves a copy (`.SAV`) of your previous installation files if they exist.
+4. Accept the terms of the license agreement by entering *yes*.
+5. Enter a directory for the library files, or press Enter to use the default directory (`/usr/lib64`).
+6. Enter a directory for the datasource template file, or press *Enter* to use the default directory (`/etc/odbc`).
+7. Enter a directory for the sample program, or press *Enter* to use the default directory (`/etc/odbc`).
+
+=== Set Up Client Environment
+
+If you selected default options during installation, ensure that:
+
+* The libraries are located in the `/usr/lib64` directory.
+* A `TRAFDSN` file is in the `/etc/odbc` directory.
+
+If you select non-default locations during installation, ensure that the files are installed in the directories that you specified during
+installation.
+
+The driver expects the `TRAFDSN` file to be present in either the default location (`/etc/odbc`) or the current working directory (`CWD`) of the
+application.
+
+If you are building ODBC applications, you will need to install these header files in your build environment:
+
+* `sql.h`
+* `sqlext.h`
+* `sqltypes.h`
+* `sqlucode.h`
+
+To install those header files from the latest packages, run this `yum` command:
+
+====
+*yum install libiodbc libiodbc-devel*
+====
+
+The `yum` command automatically installs the header files in the `/usr/include` and `/usr/include/libiodbc` directories.
+
+<<<
+=== Enable Compression
+
+When compression is enabled in the ODBC driver, the ODBC driver can send and receive large volumes of data quickly and efficiently to and from
+the Trafodion Database Connectivity Services (DCS) server over a TCP/IP network. By default, compression is disabled.
+
+To enable compression in the ODBC driver or to change the compression setting, follow these steps:
+
+* If you are using the Trafodion ODBC driver manager, add
++
+====
+*Compression = _compression-level_*
+====
++
+to the `DSN` section of `TRAFDSN` file.
+
+* If you are using a third-party driver manager, such as unixODBC, add
++
+====
+*Compression = _compression-level_*
+====
++
+to the `DSN` section of the `odbc.ini` file.
+
+The `_compression-level_` is one of these values:
+
+* `SYSTEM_DEFAULT`, which is the same as no compression
+* `no compression`
+* `best speed`
+* `best compression`
+* `balance`
+* An integer from `0` to `9`, with `0` being `no compression` and `9` being the `maximum available compression`
+
+<<<
+=== Use Third-Party Driver Manager
+
+NOTE: For better performance, we recommend that you use at least version `2.3._x_` of unixODBC.
+
+* If you are using an external driver manager, you must point to `libtrafodbc_drvr64.so` and not to `libtrafodbc64.so`.
+* The driver, `libtrafodbc_l64_drvr.so`, has been verified with iODBC and unixODBC driver managers.
+* These driver managers, as well as documentation, can be found at these Web sites:
+* http://www.iodbc.org/
+* http://www.unixodbc.org/
+* For information on the necessary data-source configuration options, you will need to add to the respective configuration files (for example,
+to `odbc.ini`).
+
+=== Run Sample Program (`connect_test`)
+
+NOTE: The examples after each step assume that you have default installation directories.
+
+If you have a previous version of the Trafodion ODBC driver installed, you need to re-link your existing application to ensure that you pick up
+the correct version of the driver. If you are unsure of the version, check the version of your application with this command:
+
+====
+*ldd _object-file_*
+====
+
+1. Move to the directory where you installed the sample program:
++
+====
+*cd /etc/odbc*
+====
+2. Set the environment variable `LD_LIBRARY_PATH`:
++
+====
+*export LD_LIBRARY_PATH=_<path-to-odbc-library-files or /usr/lib64>_*
+====
++
+<<<
+
+3. In the `/etc/odbc/TRAFDSN` file, add the correct IP address to the `Server` parameter for the `Default_DataSource`.
++
+*Example*
++
+====
+`[Default_DataSource]` +
+`Description = Default Data Source` +
+`Catalog = TRAFODION` +
+`Schema = SEABASE` +
+`DataLang = 0` +
+`FetchBufferSize = SYSTEM_DEFAULT` +
+`Server = TCP:1.2.3.4:37800` <- _Set IP Address_ +
+`SQL_ATTR_CONNECTION_TIMEOUT = SYSTEM_DEFAULT` +
+`SQL_LOGIN_TIMEOUT = SYSTEM_DEFAULT` +
+`SQL_QUERY_TIMEOUT = NO_TIMEOUT`
+====
+4. Compile the sample program.
++
+====
+*g++ -g connect_test.cpp -L/usr/lib64 -I/usr/include/odbc -ltrafodbc64 -o connect_test*
+====
+
+5. Run the sample program:
++
+====
+*./connect_test -d Default_DataSource -u _username_ -p _password_*
+====
+
+If the sample program runs successfully, you should see output similar to the following:
+
+====
+```
+Using Connect String: DSN=Default_DataSource;UID=username;PWD=****;
+Connect Test Passed...
+```
+====
+
+<<<
+[[linux_odbc_run_basicsql]]
+=== Run Sample Program (`basicsql`)
+
+NOTE: The Basic SQL sample program is not currently bundled with the ODBC Linux driver. To obtain the source code for this program, see
+<<odbc_sample_program, `basicsql` (Sample ODBC Program)>>.
+
+If you have a previous version of the Trafodion ODBC driver installed, you need to re-link your existing application to ensure that you pick up
+the correct version of the driver. If you are unsure of the version, check the version of your application with this command:
+
+====
+*ldd _object-file_*
+====
+
+1. Move to the directory where you put the `basicsql.cpp` file.
+2. Set the environment variable `LD_LIBRARY_PATH`:
++
+====
+*export LD_LIBRARY_PATH=_<path-to-odbc-driver-dlls>_*
+====
+3. In the `/etc/odbc/TRAFDSN` file, add the correct IP address to the `Server` parameter for the `Default_DataSource`. For example:
++
+*Example*
++
+====
+`[Default_DataSource]` +
+`Description = Default Data Source` +
+`Catalog = TRAFODION` +
+`Schema = SEABASE` +
+`DataLang = 0` +
+`FetchBufferSize = SYSTEM_DEFAULT` +
+`Server = TCP:1.2.3.4:37800` <- _Set IP Address_ +
+`SQL_ATTR_CONNECTION_TIMEOUT = SYSTEM_DEFAULT` +
+`SQL_LOGIN_TIMEOUT = SYSTEM_DEFAULT` +
+`SQL_QUERY_TIMEOUT = NO_TIMEOUT`
+====
+
+4. Compile the sample program.
++
+====
+*g++ -g basicsql.cpp -L. -I. -ltrafodbc64 -o basicsql*
+====
+5. Run the sample program:
++
+====
+`basicsql Default_DataSource _username password_`
+====
+
+<<<
+If the sample program runs successfully, you should see output similar to the following:
+
+====
+```
+Using Connect String: DSN=Default_DataSource;UID=user1;PWD=pwd1;
+Successfully connected using SQLDriverConnect.
+Drop sample table if it exists... Creating sample table TASKS...
+Table TASKS created using SQLExecDirect.
+Inserting data using SQLBindParameter, SQLPrepare, SQLExecute Data
+Data inserted.
+Fetching data using SQLExecDirect, SQLFetch, SQLGetData
+Data selected: 1000 CREATE REPORTS 2014-3-22
+Basic SQL ODBC Test Passed!
+```
+====
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/asciidoc/_chapters/odbc_windows.adoc
----------------------------------------------------------------------
diff --git a/docs/client_install/src/asciidoc/_chapters/odbc_windows.adoc b/docs/client_install/src/asciidoc/_chapters/odbc_windows.adoc
new file mode 100644
index 0000000..336ab69
--- /dev/null
+++ b/docs/client_install/src/asciidoc/_chapters/odbc_windows.adoc
@@ -0,0 +1,240 @@
+////
+/**
+ *@@@ 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 Windows ODBC Driver
+These installation instructions apply to Trafodion Release 1.3.*_n_* and subsequent updates of the product until otherwise indicated.
+
+== Installation Package
+The installer file for the Trafodion ODBC Driver for Windows 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 installer file to install the Trafodion ODBC Driver for Windows:
+
+[cols="25%,25%,50%",options="header"]
+|===
+| Installer File | Description | Client Operating System
+| `TFODBC64-1.3.*_n_*.msi` | Windows MSI installer file | Windows 64-bit
+|===
+
+By default, a new version of the ODBC driver will be installed in this directory and its folders unless you specify a different directory
+during installation:
+
+[cols="40%,60%",options="header"]
+|===
+| Default Installation Directory | Client Operating System
+| `C:\Program Files\Trafodion\TRAF` | ODBC 1.0 Windows 64-bit
+|===
+
+The ODBC client installation file installs or links to multiple client components:
+
+[cols="40%s,60%",options="header"]
+|===
+| This client component... | Does this...
+| Microsoft ODBC Driver Manager | Manages access to ODBC drivers for applications. The driver manager loads and unloads drivers and passes calls for ODBC functions to the
+correct driver.
+| Trafodion ODBC driver | Implements ODBC function calls to enable an ODBC client application to access the Trafodion database.
+| Microsoft ODBC Administrator | Adds, configures, and removes ODBC data sources on client workstations.
+|===
+
+<<<
+== Installation Requirements
+
+[cols="40%s,60%",options="header"]
+|===
+| Item | Requirement
+| Computer | Windows compatible PC workstation
+| Memory | Recommended minimum 32 MB
+| Disk Space | Minimum 30 MB additional free space
+| Operating System | x64 Edition of Microsoft Windows 7, Windows 8, or Windows Server 2008
+| Network Software | TCP/IP
+|===
+
+== Installation Instructions
+[[win_odbc_install]]
+=== Install Windows ODBC Driver
+NOTE: To install the driver on your PC, you must be logged on with a user ID that has administrator privileges.
+
+==== Task 1: Download the ODBC client installation file
+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.com/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. Extract the contents of the `clients-1.3.*_n_*.tar.gz` file by using an extract tool like WinZip. The package file contains the
+`TFODBC64-1.3.*_n_*.msi` installer file, which is extracted to the clients sub-directory.
+
+==== Task 2: Start the InstallShield wizard
+The InstallShield wizard walks you through the steps to install the client components (Trafodion ODBC 1.0) on your workstation. You can
+perform the installation in _interactive mode_, in which you provide input or accept defaults when prompted as ODBC is installed.
+Please refer to <<win_odbc_interactive_mode,Interactive Mode Installation>> below.
+
+<<<
+[[win_odbc_interactive_mode]]
+===== Interactive Mode Installation
+1. Double-click the `.msi` distribution file to start the InstallShield wizard.
+2. On the *Welcome* page, click *Next*.
+3. On the *Destination Folder* page, click *Next* to select the default location: `C:\Program Files\Trafodion\TRAF ODBC 1.0\`
++
+This location is the installation directory for ODBC header and help files. All other ODBC files are installed in `%SYSTEMROOT%\system32`.
+4. On the *Set Certificate Directory* page, click *Next* to accept the default location for the security certificate (`SYSTEM_DEFAULT`).
+5. On the *Ready to Install the Program* page, click *Install*. The installation begins. The *Installing Trafodion ODBC64 1.0* page displays a
+progress bar.
+6. On the *InstallShield Wizard Completed* page, click *Finish* to exit the wizard. Do not add a new `Trafodion ODBC` data source to the MS ODBC
+Administrator until you have restarted your system.
+
+==== Task 3: Add a client data source
+1. Start the Microsoft ODBC Administrator:
+* On Windows 7: *Start->All Programs->Trafodion ODBC 1.0->MS ODBC Administrator*
+* On Windows 8: Right-click the *Trafodion ODBC 1.0* icon on the desktop and select MS ODBC Administrator.
+2. In the *ODBC Data Source Administrator* dialog box, click *Add*.
+3. Select *TRAF ODBC 1.0*, and then click *Finish* to start the *Create a New Trafodion ODBC Data Source* wizard.
+4. Enter the data source name (for example, `Default_DataSource_Schema1`) and an optional description, and click *Next*.
+5. Enter the `IP address` or `host name` for the database platform. Enter the port number as *37800*. Leave the defaults as is, and click *Next*.
+6. Enter the schema name. The default schema name is `SEABASE`. Click *Next*.
+7. Enter the translate DLL name and its option, if you have one. If not, leave it blank. Leave the localization defaults as is.
++
+The Replacement Character replaces any character that is incompatible for translation when retrieving data. It is one character (one or two
+bytes long). The Replacement Character is assumed to be in the character set specified in the Client/Server Character Set Interaction. If it is not specified, `?` is used as the default.
++
+Click *Next*.
++
+<<<
+8. Select the trace options, if desired. Change the *Log File Path* to the location you want, or leave the default as is, and click *Finish*.
+9. The wizard gives you an opportunity to test the connection. Click *Test Connection* and click *OK*.
+10. The server ID and schema are filled in for you. Enter a valid user name and password, and click *OK*.
++
+The wizard attempts to connect to the data source and displays a message stating whether it was successful or not.
+11. Click *OK* to save the data source, or click *Cancel* _twice_ to quit the *Create Data Source* wizard.
+
+=== Reinstall Windows ODBC Driver
+To reinstall the driver, we recommend that you fully remove your ODBC driver and then install the new version. Please refer to
+<<win_odbc_uninstall,Uninstalling the Trafodion ODBC Driver for Windows>> and then <<win_odbc_install, Installing the Trafodion ODBC Driver for Windows>>.
+
+[[win_odbc_uninstall]]
+=== Uninstalling Windows ODBC Driver
+1. Start to remove the ODBC driver:
+* On Windows 7: *Start->All Programs->Trafodion ODBC 1.0->Remove TRAF ODBC 1.0*
+* On Windows 8: Right-click the *Trafodion ODBC 1.0* icon on the desktop and select *Remove TRAF ODBC 1.0*.
+2. When the *Windows Installer* dialog box asks you if you want to uninstall this product, click *Yes*.
+3. The *Trafodion ODBC 1.0* dialog box displays the status and asks you to wait while `Windows configures Trafodion ODBC 1.0` (that is, removes
+the Trafodion ODBC Driver from your Windows workstation).
++
+After this dialog box disappears, Trafodion ODBC 1.0 is no longer on your workstation.
+
+NOTE: Uninstalling the ODBC driver does not remove pre-existing data source definitions from the Windows registry.
+
+<<<
+[[win_odbc_client_env]]
+=== Set Up Client Environment
+All client data sources connect to the pre-configured server data source on the database platform, which is `Default_DataSource`.
+
+You can configure one data source only, `Default_DataSource`, on the database platform, but you can create other data source
+definitions on the workstation.
+
+For example, if you have more than one schema on the database platform and you want to connect
+to each of those schemas on the database platform, you can create a client data source for each of those schemas.
+
+Instead of changing the schema definition in the data source definition on the workstation, you can create multiple data source
+definitions with different schemas on the workstation. The client data source will use the specified schema but will connect to
+`Default_DataSource` on the database platform.
+
+To create a data source on the client workstation, follow these steps:
+
+1. Launch the *MS ODBC Administrator*.
++
+For example, on Windows 7, select *Start->All Programs->Trafodion ODBC 1.0->MS ODBC Administrator*.
+2. In the *ODBC Data Source Administrator* dialog box, select the *User DSN* tab, and click *Add*.
+3. Select the *TRAF ODBC 1.0* driver, and then click *Finish*.
++
+A new dialog box appears, prompting you to create a new data source.
+4. Enter the name of the data source, `Default_DataSource`, and click *Next* to continue.
+5. Enter the IP address and port number of the Trafodion system to which will be connecting. The port number must be *37800*.
+Click *Next* to continue.
+6. Select the default schema. If you do not select a schema, the default is `USR`. Click Next to continue.
+7. If desired, configure the *translate dll*, which translates data from one character set to another, and configure the localization. By
+default, the client error message language is English, and the client’s local character set is used. Click *Next* to continue.
+8. If desired, set the trace options and the file path of the trace log. Click *Finish*.
++
+The *Test Trafodion ODBC Connection* dialog box appears, allowing you to test the connection using the data source that you created.
+9. Click *Test Connection*.
+10. When prompted, enter your username and password, and click *OK*.
++
+If the connection is successful, you will see `Connected Successfully` in the *Test Trafodion ODBC Connection* dialog box.
+
+=== Enable Compression
+When compression is enabled in the ODBC driver, the ODBC driver can send and receive large volumes of data quickly and efficiently to and from
+the Trafodion Database Connectivity Services (DCS) server over a TCP/IP network. By default, compression is disabled.
+
+To enable compression in the ODBC driver or to change the compression setting, follow these steps:
+
+1. Launch the MS ODBC Administrator. For example, on Windows 7, select *Start→All Programs→Trafodion ODBC 1.0→MS ODBC Administrator*.
+2. In the *ODBC Data Source Administrator* dialog box, select the *User DSN* tab, select the name of your data source under
+*User Data Sources*, and click *Configure*. If you did not create a data source, please refer to
+<<win_odbc_client_env, Setting Up the Client Environment>>.
++
+A new dialog box appears, showing the configuration of your data source.
+3. Select the *Network* tab, and then select one of these values for *Compression*:
+* `SYSTEM_DEFAULT`, which is the same as no compression
+* `no compression`
+* `best speed`
+* `best compression`
+* `balance`
+* An integer from 0 to 9, with 0 being no compression and 9 being the
+maximum available compression
+4. Click *OK* to accept the change.
+5. Click *OK* to exit the *ODBC Data Source Administrator* dialog box.
+
+<<<
+[[win_odbc_run_basicsql]]
+=== Run Sample Program (`basicsql`)
+NOTE: The Basic SQL sample program is not currently bundled with the ODBC Windows driver. To obtain the source code and the build and run
+files for this program, please refer to <<odbc_sample_program, ODBC Sample Program>>.
+
+To build and run the executable file, follow these steps:
+
+1. Open a Visual Studio x64 Win64 Command Prompt. Make sure to select the x64 version of the command prompt. For example, on Windows 7, select
+*Start->All Programs->Microsoft Visual Studio 2010->Visual Studio Tools->Visual Studio x64 Win64 Command Prompt*.
+2. At the command prompt, move to the directory where you put the `basicsql.cpp` and build files.
+3. Run build at the command prompt. You will see `basicsql.exe` created in the same directory as the source file.
+4. Before running the sample program, create a Trafodion data source named `Default_DataSource` on the client workstation using MS ODBC
+Administrator. For instructions, please refer to <<win_odbc_client_env,Set Up Client Environment>>.
+5. From the command prompt, run the sample program by entering either run or this command:
++
+====
+*basicsql Default_DataSource _username password_*
+====
++
+If the sample program executes successfully, you should see this output:
++
+*Example*
++
+====
+```
+Using Connect String: DSN=Default_DataSource;UID=user1;PWD=pwd1;
+Successfully connected using SQLDriverConnect.
+Drop sample table if it exists...
+Creating sample table TASKS...
+Table TASKS created using SQLExecDirect.
+Inserting data using SQLBindParameter, SQLPrepare, SQLExecute
+Data inserted.
+Fetching data using SQLExecDirect, SQLFetch, SQLGetData
+Data selected: 1000 CREATE REPORTS 2014-3-22
+Basic SQL ODBC Test Passed!
+```
+====
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/client_install/src/asciidoc/_chapters/sample_prog.adoc
----------------------------------------------------------------------
diff --git a/docs/client_install/src/asciidoc/_chapters/sample_prog.adoc b/docs/client_install/src/asciidoc/_chapters/sample_prog.adoc
new file mode 100644
index 0000000..dfe7b2e
--- /dev/null
+++ b/docs/client_install/src/asciidoc/_chapters/sample_prog.adoc
@@ -0,0 +1,75 @@
+////
+/**
+ *@@@ 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 @@@
+ */
+////
+
+[[odbc_sample_program]]
+== `basicsql` (Sample ODBC Program)
+This appendix provides the source code for the ODBC sample program, `basicsql,` which is not currently bundled with the ODBC drivers.
+
+This appendix also provides the code for the script files that are needed to build and run the sample program on Windows. See
+<<basicsql_build, Windows Build and Run Files for 'basicsql'>>.
+
+Copy and paste the code from this appendix into the recommended files. To build and run the sample program, see these instructions:
+
+* On Windows: <<win_odbc_run_basicsql, Run Sample Program (`basicsql`)>>.
+* On Linux: <<linux_odbc_run_basicsql, Run Sample Program (`basicsql`)>>.
+
+=== `basicsql.cpp` Source Code
+You can download the `basicsql.cpp` example from
+http://trafodion.incubator.apache.org/docs/latest/client_install/resources/source/basicsql.cpp.
+
+Alternatively, copy and paste the following code into a file named `basicsql.cpp`:
+
+[source, cplusplus]
+----
+include::{sourcedir}/basicsql.cpp[]
+----
+
+[[basicsql_build]]
+=== Windows Build and Run Files for `basicsql`
+
+The script files that are needed to build and run the sample program on Windows are not currently bundled with the ODBC driver.
+Copy and paste the code from this appendix into the recommended files. To build and run the sample program on Windows,
+see the instructions in <<win_odbc_run_basicsql, Run Sample Program (`basicsql`)>>.
+
+==== `build.bat` (Build Script)
+You can download the `build.bat` example from
+http://trafodion.incubator.apache.org/docs/latest/client_install/resources/source/build.bat.
+
+Alternatively, copy and paste the following code into a file named `build.bat`, which is used to build the sample program on Windows:
+
+----
+include::{sourcedir}/build.bat[]
+----
+
+To build the sample program on Windows, see the instructions in <<win_odbc_run_basicsql, Run Sample Program (`basicsql`)>>.
+
+==== Run `run.bat`
+You can download the `run.bat` example from
+http://trafodion.incubator.apache.org/docs/latest/client_install/resources/source/run.bat.
+
+Alternatively, copy and paste the following code into a file named `run.bat`, which is used to run the sample program on Windows:
+
+----
+include::{sourcedir}/run.bat[]
+----
+
+To run the sample program on Windows, see the instructions in <<win_odbc_run_basicsql, Run Sample Program (`basicsql`)>>.