trafodion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From svar...@apache.org
Subject [13/42] incubator-trafodion git commit: Rechecking of asciidoc conversion due to weird Windows10 upgrade.
Date Thu, 14 Jan 2016 18:18:17 GMT
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/859a7e4c/docs/command_interface/source/Trafodion_Command_Interface_Guide.xml
----------------------------------------------------------------------
diff --git a/docs/command_interface/source/Trafodion_Command_Interface_Guide.xml b/docs/command_interface/source/Trafodion_Command_Interface_Guide.xml
deleted file mode 100755
index 9dadb5a..0000000
--- a/docs/command_interface/source/Trafodion_Command_Interface_Guide.xml
+++ /dev/null
@@ -1,9846 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<?xml-stylesheet href="xdocbook.css" type="text/css"?>
-<!-- 
-* @@@ 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 book PUBLIC "-//Apache Software Foundation (ASF)//DTD DocBook Extension//EN"
- "ess.dtd">
-<book>
-<title>Trafodion Command Interface Guide</title>
-<bookinfo>
-<title>Trafodion Command Interface Guide</title>
-<edition>Trafodion Release 0.8.0 Beta</edition><pubsnumber>T824-080-001</pubsnumber>
-<pubdate>June 2014</pubdate>
-<abstract condition="hidden">
-<para>Last updated: 5/28/2014</para>
-</abstract>
-<copyright><year>2015</year><holder> Apache Software Foundation (ASF),
-</holder></copyright>
-<legalnotice>
-<!--WRITER'S NOTE: HP legal notice for open source release-->
-<title>Legal Notice</title>
-<para>The information contained herein is subject to change without
-notice. This documentation is distributed on an “AS IS” basis, without
-warranties or conditions of any kind, either express or implied. Nothing
-herein should be construed as constituting an additional warranty.
-HP shall not be liable for technical or editorial errors or omissions
-contained herein.</para><para>NOTICE REGARDING OPEN SOURCE SOFTWARE:
-Project Trafodion is licensed under the Apache License, Version 2.0
-(the "License"); you may not use software from Project Trafodion except
-in compliance with the License. You may obtain a copy of the License
-at <ulink url="http://www.apache.org/licenses/LICENSE-2.0">http://www.apache.org/licenses/LICENSE-2.0</ulink
->. 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.</para>
-<formalpara>
-<title>Acknowledgements</title>
-<para>Microsoft® and Windows® are U.S. registered trademarks of Microsoft
-Corporation. Java® is a registered trademark of Oracle and/or its
-affiliates.</para></formalpara>
-</legalnotice>
-</bookinfo>
-<preface id="preface">
-<title>About This Document</title>
-<para>This guide describes how to use the Trafodion Command Interface
-(TrafCI) on a client workstation to connect to and query a Trafodion
-database. The TrafCI enables you to run SQL statements interactively
-or from script files.</para>
-<section>
-<title>Intended Audience</title>
-<para>This guide is intended for database administrators and support
-personnel who are maintaining and monitoring a Trafodion database.</para>
-</section>
-<section>
-<title>Document Organization</title>
-<informaltable colsep="0" frame="none" rowsep="0">
-<tgroup cols="2" tgroupstyle="TI  inline table">
-<colspec colwidth="0.62*"/>
-<colspec colwidth="1.41*"/>
-<tbody>
-<row><entry><xref linkend="Chapter1" role="select:label title"/></entry>
-<entry>Introduces the Trafodion Command Interface (TrafCI) and describes
-its capabilities. </entry></row>
-<row><entry><xref linkend="Chapter2" role="select:label title"/></entry>
-<entry>Describes how to configure TrafCI on the client workstation.</entry>
-</row>
-<row><entry><xref linkend="Chapter3" role="select:label title"/></entry>
-<entry>Describes how to launch, log in to, and exit TrafCI on a client
-workstation. </entry></row>
-<row><entry><xref linkend="Chapter4" role="select:label title"/></entry>
-<entry>Describes how to run commands interactively in TrafCI.  </entry>
-</row>
-<row><entry><xref linkend="Chapter5" role="select:label title"/></entry>
-<entry>Describes how to run script files in TrafCI. </entry></row>
-<row><entry><xref linkend="i1006618" role="select:label title"/></entry>
-<entry>Describes how to run TrafCI from Perl or Python. </entry></row>
-<row><entry><xref linkend="i1008451" role="select:label title"/></entry>
-<entry>Provides syntax, considerations, and examples for the interface
-commands. </entry></row>
-</tbody>
-</tgroup>
-</informaltable>
-</section>
-<section>
-<title>New and Changed Information in This Edition</title>
-<para>This manual is new.</para>
-</section>
-<section>
-<title>Notation Conventions</title>
-<section role="no.new.page">
-<title>General Syntax Notation</title>
-<para>This list summarizes the notation conventions for syntax presentation
-in this manual.</para>
-<variablelist>
-<varlistentry><term>UPPERCASE LETTERS</term>
-<listitem><para>Uppercase letters indicate keywords and reserved words.
- Type these items exactly as shown.  Items not enclosed in brackets
-are required.  For example:</para><para>SELECT</para>
-</listitem>
-</varlistentry>
-<varlistentry><term><replaceable>Italic Letters</replaceable></term>
-<listitem><para>Italic letters, regardless of font, indicate variable
-items that you supply.  Items not enclosed in brackets are required.
- For example:</para><para><replaceable>file-name</replaceable></para>
-</listitem>
-</varlistentry>
-<varlistentry><term><computeroutput>Computer Type</computeroutput
-></term>
-<listitem><para>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. For example:</para>
-<programlisting>
-myfile.sh
-</programlisting>
-</listitem>
-</varlistentry>
-<varlistentry condition="hidden"><term><userinput>Bold Text</userinput
-></term>
-<listitem><para>Bold text in an example indicates user input typed
-at the terminal.  For example:</para>
-<programlisting>
-ENTER RUN CODE
-
-?<userinput>123</userinput>
-CODE RECEIVED:      123.00
-</programlisting>
-<para>The user must press the Return key after typing the input.</para>
-</listitem>
-</varlistentry>
-<varlistentry><term>[  ]  Brackets</term>
-<listitem><para>Brackets enclose optional syntax items. For example:</para>
-<programlisting>
-DATETIME [<replaceable>start-field</replaceable> TO] <replaceable
->end-field</replaceable>
-</programlisting>
-<para>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:</para>
-<programlisting>
-DROP SCHEMA <replaceable>schema</replaceable> [CASCADE]
-                   [RESTRICT]
-</programlisting>
-<programlisting>
-DROP SCHEMA <replaceable>schema</replaceable> [ CASCADE | RESTRICT ]
-</programlisting>
-</listitem>
-</varlistentry>
-<varlistentry><term>{  }  Braces</term>
-<listitem><para>Braces enclose required syntax items. For example:</para>
-<programlisting>
-FROM { <replaceable>grantee</replaceable>[, <replaceable>grantee</replaceable
->]...}
-</programlisting>
-<para>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:</para>
-<programlisting>
-INTERVAL { <replaceable>start-field</replaceable> TO <replaceable
->end-field</replaceable> }
-         { <replaceable>single-field</replaceable> }
-</programlisting>
-<programlisting>
-INTERVAL { <replaceable>start-field</replaceable> TO <replaceable
->end-field</replaceable>  | <replaceable>single-field</replaceable
-> }
-</programlisting>
-</listitem>
-</varlistentry>
-<varlistentry><term>|  Vertical Line</term>
-<listitem><para>A vertical line separates alternatives in a horizontal
-list that is enclosed in brackets or braces. For example:</para>
-<programlisting>
-{<replaceable>expression</replaceable> | NULL}
-</programlisting>
-</listitem>
-</varlistentry>
-<varlistentry><term>…  Ellipsis</term>
-<listitem><para>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. For example:</para>
-<programlisting>
-ATTRIBUTE[S] <replaceable>attribute</replaceable> [, <replaceable
->attribute</replaceable>]...
-</programlisting>
-<programlisting>
-{, <replaceable>sql-expression</replaceable>}...
-</programlisting>
-<para>An ellipsis immediately following a single syntax item indicates
-that you can repeat that syntax item any number of times. For example:</para>
-<programlisting>
-<replaceable>expression-n</replaceable>…
-</programlisting>
-</listitem>
-</varlistentry>
-<varlistentry><term>Punctuation</term>
-<listitem><para>Parentheses, commas, semicolons, and other symbols
-not previously described must be typed as shown. For example:</para>
-<programlisting>
-DAY (<replaceable>datetime-expression</replaceable>)
-</programlisting>
-<programlisting>
-@<replaceable>script-file</replaceable>
-</programlisting>
-<para>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:</para>
-<programlisting>
-"{" <replaceable>module-name</replaceable> [, <replaceable>module-name</replaceable
->]... "}"
-</programlisting>
-</listitem>
-</varlistentry>
-<varlistentry><term>Item Spacing</term>
-<listitem><para>Spaces shown between items are required unless one
-of the items is a punctuation symbol such as a parenthesis or a comma.
-For example:</para>
-<programlisting>
-DAY (<replaceable>datetime-expression</replaceable>)
-</programlisting>
-<programlisting>
-DAY(<replaceable>datetime-expression</replaceable>)
-</programlisting>
-<para>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:</para>
-<programlisting>
-<replaceable>myfile</replaceable>.sh
-</programlisting>
-</listitem>
-</varlistentry>
-<varlistentry><term>Line Spacing</term>
-<listitem><para>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.
-For example:</para>
-<programlisting>
-<replaceable>match-value</replaceable> [NOT] LIKE <replaceable>pattern</replaceable
-> 
-
-   [ESCAPE <replaceable>esc-char-expression</replaceable>]
-</programlisting>
-</listitem>
-</varlistentry>
-</variablelist>
-</section>
-</section>
-<section>
-<title>Publishing History</title>
-<informaltable>
-<tgroup cols="3">
-<colspec colwidth="0.47*"/>
-<colspec colwidth="1.52*"/>
-<colspec colwidth="0.80*"/>
-<thead>
-<row><entry>Part Number</entry><entry>Product Version</entry><entry
->Publication Date</entry></row>
-</thead>
-<tbody>
-<row><entry>T824-080-001</entry><entry>Trafodion Release 0.8.0 Beta</entry>
-<entry>June 2014</entry></row>
-</tbody>
-</tgroup>
-</informaltable>
-</section>
-<section>
-<title>We Encourage Your Comments</title>
-<para>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:</para>
-<para><email>trafodion-documentation@lists.launchpad.net</email></para>
-<para>Include the document title, part number, and any comment, error
-found, or suggestion for improvement you have concerning this document.</para>
-</section>
-</preface>
-<chapter id="Chapter1">
-<title>Introduction to the Trafodion Command Interface (TrafCI)</title>
-<indexterm><primary>Trafodion Command Interface (TrafCI)</primary>
-<secondary>description of</secondary></indexterm>
-<para>The Trafodion Command Interface (TrafCI) is a command-line interface
-that you download and install on a client workstation that has the
-Trafodion JDBC Type 4 Driver installed. Operating systems that support
-the JDBC driver include Windows and Linux. The JDBC driver connects
-TrafCI on a client workstation to a Trafodion database.</para>
-<figure id="NCI_within_Neo_platform_network">
-<title>TrafCI Connected to a Trafodion Database</title>
-<mediaobject><imageobject role="pdf"><imagedata contentwidth="6in"
-fileref="img/VST101.png" role="pdf"/></imageobject></mediaobject>
-</figure>
-<para>TrafCI enables you to perform daily administrative and database
-management tasks by running SQL statements or other commands interactively
-or from script files. You can also run TrafCI from a Perl or Python
-command line or from Perl or Python programs.</para>
-</chapter>
-<chapter id="Chapter2">
-<title>Installing and Configuring TrafCI</title>
-<itemizedlist>
-<listitem><para><xref linkend="Installing-NCI"
-role="select:quotedtitle page"/></para></listitem>
-<listitem><para><xref linkend="Verifying-and-Setting-the-Java-Path"
-role="select:quotedtitle page"/></para></listitem>
-<listitem><para><xref linkend="i1006727" role="select:quotedtitle page"
-/></para></listitem>
-</itemizedlist>
-<section id="Installing-NCI">
-<title>Installing TrafCI</title>
-<!--WRITER'S NOTE: Update this cross-reference to point to instructions on the wiki:-->
-<para>To install TrafCI on a client workstation, follow the procedures
-in the <citetitle>Trafodion Client Installation Guide</citetitle>.</para>
-</section>
-<section id="Verifying-and-Setting-the-Java-Path">
-<title>Verifying and Setting the Java Path</title>
-<para>To be able to launch and run TrafCI, you must have the Java
-path set to the correct location. Follow these instructions:</para>
-<itemizedlist>
-<listitem><para><xref linkend="Setting-PATH-on-Win7"
-role="select:quotedtitle page"/></para></listitem>
-<listitem><para><xref linkend="i1006974" role="select:quotedtitle page"
-/></para></listitem>
-</itemizedlist>
-<!--WRITER'S NOTE: Update this cross-reference to point to instructions on the wiki:-->
-<note>
-<para>To install the Java Runtime Environment (JRE), see the TrafCI
-installation instructions in the <citetitle>Trafodion Client Installation
-Guide</citetitle>.</para>
-</note>
-<section id="Setting-PATH-on-Win7">
-<title>Setting the PATH on Windows</title>
-<indexterm><primary>PATH</primary><secondary>Trafodion Command Interface
-(TrafCI) setting</secondary><tertiary>Windows</tertiary></indexterm>
-<procedure>
-<step><para>Right-click the <guiicon>Computer</guiicon> icon on your
-desktop, and then select <guilabel>Properties</guilabel>.</para><para
-> The Control Panel > System and Security > System window appears.</para>
-</step>
-<step><para>In the left navigation bar, click the <guilabel>Advanced
-system settings</guilabel> link.</para></step>
-<step><para>In the System Properties dialog box, click the <guibutton
->Environment Variables</guibutton> button.</para></step>
-<step><para>Under System variables, select the variable named <guilabel
->Path</guilabel>, and then click <guibutton>Edit</guibutton>:</para>
-<mediaobject><imageobject role="pdf"><imagedata contentwidth="3.5in"
-fileref="img/path2.png"/></imageobject></mediaobject>
-</step>
-<step><para>Place the cursor at the beginning of the Variable value
-field and enter the path of the Java <literal>bin</literal> directory,
-ending with a semicolon (;):</para>
-<mediaobject><imageobject role="pdf"><imagedata
-fileref="img/varval2.png"/></imageobject></mediaobject>
-<para>For example:</para>
-<programlisting>"C:\Program Files (x86)\Java\jre7\bin";</programlisting>
-<note>
-<para>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.</para>
-</note>
-</step>
-<step><para>Click <guibutton>OK</guibutton>.</para></step>
-<step><para>Verify that the updated Path appears under System variables,
-and click <guibutton>OK</guibutton>.</para></step>
-<step><para>In the System Properties dialog box, click <guibutton
->OK</guibutton> to accept the changes.</para></step>
-</procedure>
-</section>
-<section id="i1006974">
-<title>Setting the PATH on Linux</title>
-<indexterm><primary>PATH</primary><secondary>Trafodion Command Interface
-(TrafCI) setting</secondary><tertiary>Linux</tertiary></indexterm>
-<procedure>
-<step><para>Open the user profile (<literal>.profile</literal> or <literal
->.bash_profile</literal> for the Bash shell) in the <literal>/home</literal
-> directory. For example:</para>
-<screen><command>vi .profile</command></screen>
-</step>
-<step><para>In the user profile, set the PATH environment variable
-to include the path of the Java <literal>bin</literal> directory.
-For example:</para>
-<screen><command>export PATH=/opt/java1.7/jre/bin:$PATH </command
-></screen>
-<note>
-<para>Place the path of the Java <literal>bin</literal> directory
-before $PATH, and check that no space exists after the colon (:) in
-the path. In the C shell, use the <literal>setenv</literal> command
-instead of <literal>export</literal>.</para>
-</note>
-</step>
-<step><para>To activate the changes, either log out and log in again
-or execute the user profile. For example:</para>
-<screen><command>. .profile</command></screen>
-</step>
-</procedure>
-</section>
-</section>
-<section id="i1006727">
-<title>Testing the Launch of TrafCI</title>
-<indexterm><primary>Trafodion Command Interface (TrafCI)</primary>
-<secondary>testing the launch of</secondary></indexterm><indexterm>
-<primary>Installation procedures</primary><secondary>testing the launch
-of TrafCI</secondary></indexterm>
-<procedure>
-<step><para>Launch TrafCI and verify that you can connect to the database.
-For instructions, see <xref linkend="Chapter3" role="select:label page"
-/>.</para>
-<!--WRITER'S NOTE: Update this illustration to include the latest TrafCI screen capture without the data source:-->
-<para>This window should appear:</para>
-<mediaobject><imageobject role="pdf"><imagedata contentwidth="6in"
-fileref="img/launch02.png" role="pdf"/></imageobject></mediaobject>
-</step>
-<step><para>If you cannot launch TrafCI or connect to the database,
-verify that:</para>
-<itemizedlist>
-<listitem><para>The database platform is available and running, and
-the port number is correct for the database platform<phrase
-condition="hidden">, and you are authorized to log in to that database
-platform. To obtain a user ID to log in to the database, see your
-cluster security administrator</phrase>.</para></listitem>
-<listitem><para>The Java path is set to the correct location. See <xref
-linkend="Verifying-and-Setting-the-Java-Path"
-role="select:quotedtitle page"/>.</para></listitem>
-<!--WRITER'S NOTE: Update this cross-reference to point to instructions on the wiki:-->
-<listitem><para>You installed the TrafCI and JDBC software files correctly.
-See the <citetitle>Trafodion Client Installation Guide</citetitle
->.</para></listitem>
-</itemizedlist>
-</step>
-</procedure>
-</section>
-</chapter>
-<chapter id="Chapter3">
-<title>Launching TrafCI</title>
-<para>This chapter describes how to launch TrafCI from the Window
-or Linux environment of a client workstation:</para>
-<itemizedlist>
-<listitem><para><xref linkend="i1004799" role="select:quotedtitle page"
-/></para></listitem>
-<listitem><para><xref linkend="i1006229" role="select:quotedtitle page"
-/></para></listitem>
-<listitem><para><xref linkend="i1008715" role="select:quotedtitle page"
-/></para></listitem>
-<listitem><para><xref linkend="i1005070" role="select:quotedtitle page"
-/></para></listitem>
-<listitem><para><xref linkend="i1009121"/></para></listitem>
-</itemizedlist>
-<para>For information about launching TrafCI from Perl or Python,
-see <xref linkend="i1006618" role="select:label page"/>.</para>
-<important>
-<para>Before launching TrafCI, make sure that you have set the Java
-path to the correct location. See <xref
-linkend="Verifying-and-Setting-the-Java-Path"
-role="select:quotedtitle page"/>.</para>
-</important>
-<section id="i1004799">
-<title>Launching TrafCI on a Windows Client Workstation</title>
-<indexterm><primary>Trafodion Command Interface (TrafCI)</primary>
-<secondary>launching on a Windows client workstation</secondary>
-</indexterm>
-<procedure>
-<step><para>Find the Windows launch file, <literal>trafci.cmd</literal
->, in the <literal>bin</literal> folder:</para>
-<mediaobject><imageobject role="pdf"><imagedata contentwidth="6.0in"
-fileref="img/winbin.png"/></imageobject></mediaobject>
-</step>
-<step><para>Double-click the <literal>trafci.cmd</literal> file.</para>
-<para>TrafCI appears, prompting you to enter the host name or IP address
-of the database platform, your user name, and password. See <xref
-linkend="i1008715" role="select:quotedtitle page"/>.</para>
-</step>
-</procedure>
-<section id="i1007549">
-<title>Creating a Shortcut to trafci.cmd</title>
-<indexterm><primary>trafci.cmd, creating a shortcut to</primary>
-</indexterm>
-<para>To enable a user to launch TrafCI from a shortcut icon on the
-desktop:</para>
-<procedure>
-<step><para>Right-click the desktop and select <emphasis role="bold"
->New > Shortcut</emphasis>:</para>
-<mediaobject><imageobject role="pdf"><imagedata contentwidth="4.0in"
-fileref="img/shortct1.png"/></imageobject></mediaobject>
-</step>
-<step><para>Type the location of <literal>trafci.cmd</literal> within
-double quotes (“) or click <emphasis role="bold">Browse</emphasis
-> to locate that file, and then click <emphasis role="bold">Next</emphasis
->:</para>
-<mediaobject><imageobject role="pdf"><imagedata contentwidth="4.0in"
-fileref="img/shortct2.png"/></imageobject></mediaobject>
-<!--WRITER'S NOTE: Update this cross-reference to point to instructions on the wiki:-->
-<para>For the locations of the installed TrafCI software files, see
-the <citetitle>Trafodion Client Installation Guide</citetitle>.</para>
-</step>
-<step><para>Type a name for the shortcut and click <emphasis role="bold"
->Finish</emphasis>:</para>
-<mediaobject><imageobject role="pdf"><imagedata contentwidth="4.0in"
-fileref="img/shortct3.png"/></imageobject></mediaobject>
-</step>
-<step><indexterm><primary>Launch parameters</primary><secondary>presetting
-on Windows</secondary></indexterm><indexterm><primary>Login parameters</primary>
-<secondary>presetting on Windows</secondary></indexterm><para>If desired,
-specify optional launch parameters for the shortcut:</para>
-<substeps>
-<step><para>Right-click the shortcut icon and select <emphasis
-role="bold">Properties</emphasis>:</para>
-<mediaobject><imageobject role="pdf"><imagedata
-fileref="img/shortct4.png"/></imageobject></mediaobject>
-</step>
-<step><para>Select the <emphasis role="bold">Shortcut</emphasis> tab.</para>
-</step>
-<step><para>In the Target box, insert a space after <literal>"...\Trafodion
-Command Interface\bin\trafci.cmd"</literal> and add the optional launch
-parameters:</para>
-<mediaobject><imageobject role="pdf"><imagedata contentwidth="3.0in"
-fileref="img/shortct5.png"/></imageobject></mediaobject>
-<para>For more information, see <xref linkend="i1005070"
-role="select:quotedtitle page"/>.</para>
-</step>
-<step><para>Click <emphasis role="bold">OK</emphasis>.</para></step>
-</substeps>
-</step>
-<step><para>To launch TrafCI, double-click the shortcut icon.</para>
-<para>TrafCI appears. If you did not set the optional launch parameters,
-TrafCI prompts you to enter the host name or IP address of the database
-platform, your user name, and password. See <xref linkend="i1008715"
-role="select:quotedtitle page"/>.</para>
-</step>
-</procedure>
-</section>
-</section>
-<section id="i1006229">
-<title>Launching TrafCI on a Linux Client Workstation</title>
-<indexterm><primary>Trafodion Command Interface (TrafCI)</primary>
-<secondary>launching on a Linux client workstation</secondary>
-</indexterm>
-<para>In the terminal window, enter:</para>
-<programlisting>./<replaceable>trafci‑installation‑directory</replaceable
->/trafci/bin/trafci.sh</programlisting>
-<!--WRITER'S NOTE: Update this cross-reference to point to instructions on the wiki:-->
-<para><replaceable>trafci-installation-directory</replaceable> is
-the directory where you installed the TrafCI software files. For more
-information, see the <citetitle>Trafodion Client Installation Guide</citetitle
->.</para>
-<section id="i1005964">
-<title>Setting the PATH of trafci.sh</title>
-<indexterm><primary>Environment variables</primary><secondary>PATH</secondary>
-</indexterm><indexterm><primary>trafci.sh, setting the path of</primary>
-</indexterm>
-<para>To enable a user to launch TrafCI anywhere on the client workstation:</para>
-<procedure>
-<step><para>Open the user profile (<literal>.profile</literal> or <literal
->.bash_profile</literal> for the Bash shell) in the <literal>/home</literal
-> directory. For example:</para>
-<programlisting>vi .profile</programlisting>
-</step>
-<step><indexterm><primary>User profile</primary><secondary>setting
-the PATH</secondary></indexterm><indexterm><primary>PATH environment
-variable</primary></indexterm><para>In the user profile, set the PATH
-environment variable to include the path of the <literal>trafci.sh</literal
-> file. For example:</para>
-<programlisting>export PATH=/<replaceable>trafci‑installation‑directory</replaceable
->/trafci/bin/:...</programlisting>
-<!--WRITER'S NOTE: Update this cross-reference to point to instructions on the wiki:-->
-<para><replaceable>trafci-installation-directory</replaceable> is
-the directory where you installed the TrafCI software files. For more
-information, see the <citetitle>Trafodion Client Installation Guide</citetitle
->. Check that no space is after the colon (:) in the path.</para>
-<note>
-<para>In the C shell, use the <literal>setenv</literal> command instead
-of <literal>export</literal>.</para>
-</note>
-</step>
-<step><para>To activate the changes, either log out and log in again
-or execute the user profile. For example:</para>
-<programlisting>. .profile</programlisting>
-</step>
-<step><para>On the command line, execute the <literal>trafci.sh</literal
-> file to launch TrafCI:</para>
-<programlisting>trafci.sh</programlisting>
-<para>TrafCI appears, prompting you to enter the host name or IP address
-of the database platform, your user name, and password. See <xref
-linkend="i1008715" role="select:quotedtitle page"/>. </para>
-<note>
-<para>To enable all users to launch TrafCI anywhere on the system,
-create a symbolic link to the <literal>trafci.sh</literal> file in
-the <literal>/usr/bin</literal> or <literal>/usr/local/bin</literal
-> directory:<programlisting>ln -s ./<replaceable>trafci-installation-directory</replaceable
->/trafci/bin/trafci.sh /usr/bin/trafci.sh</programlisting></para>
-</note>
-</step>
-</procedure>
-</section>
-<section id="i1006829">
-<title>Presetting the Optional Launch Parameters</title>
-<indexterm><primary>Login parameters</primary><secondary>presetting
-on Linux or UNIX</secondary></indexterm><indexterm><primary>Launch
-parameters</primary><secondary>presetting on Linux or UNIX</secondary>
-</indexterm>
-<para>To preset the optional launch parameters for each session, use
-an alias in the shell command. For example:</para>
-<programlisting>alias trafci='trafci.sh -h 16.123.456.78:23400 -u user1 -p xxxxxx'</programlisting>
-<para>You can add the alias, <literal>trafci</literal>, to the user
-profile, or you can enter it at a command prompt. For more information
-about the optional launch parameters, see <xref linkend="i1005070"
-role="select:quotedtitle page"/>.</para>
-</section>
-</section>
-<section id="i1008715">
-<title>Logging In to the Database Platform</title>
-<itemizedlist>
-<listitem><para><xref linkend="i1006238" role="select:quotedtitle page"
-/></para></listitem>
-<listitem><para><xref linkend="log_param" role="select:quotedtitle page"
-/></para></listitem>
-<listitem><para><xref linkend="Retrying-the-Login"
-role="select:quotedtitle page"/></para></listitem>
-</itemizedlist>
-<note condition="hidden">
-<para>You must be authorized to log in to the database platform. To
-obtain a user ID to log in to the database, see your cluster security
-administrator.</para>
-</note>
-<section id="i1006238">
-<title>Logging In Without Using Login Parameters</title>
-<note condition="hidden">
-<para>If you launch TrafCI from within HPDM, the TrafCI session inherits
-the connection attributes of the HPDM session.</para>
-</note>
-<para>If you launch TrafCI<phrase condition="hidden"> outside HPDM</phrase
-> and do not specify login parameters on the command line, follow
-these steps:</para>
-<procedure>
-<step><indexterm><primary>Logging in</primary><secondary>default method</secondary>
-</indexterm><para>After you launch TrafCI, TrafCI shows the welcome
-banner and prompts you to enter the host name or IP address of the
-database platform:</para>
-<programlisting>Host Name/IP Address: _</programlisting>
-<indexterm><primary>Host name</primary></indexterm><para>Enter a host
-name:</para>
-<programlisting><replaceable>host-name</replaceable>[.<replaceable
->domain-name</replaceable>][:<replaceable>port-number</replaceable
->]</programlisting>
-<itemizedlist>
-<listitem><para>If you do not specify the domain name, TrafCI uses
-the domain of the client workstation. </para></listitem>
-<listitem><indexterm><primary>Port number, default</primary></indexterm>
-<para>If you do not specify a port number, TrafCI uses the default
-port number, which is 23400.</para></listitem>
-</itemizedlist>
-<indexterm><primary>IP address</primary></indexterm><para>Or enter
-an IP address:</para>
-<programlisting><replaceable>IP-address</replaceable>[:<replaceable
->port-number</replaceable>]</programlisting>
-</step>
-<step><para>Enter your directory-service (or LDAP) user name.</para>
-<para>User names are case-insensitive.</para>
-</step>
-<step><para>Enter your password.</para><para>Passwords are case-sensitive.</para>
-</step>
-<!--WRITER'S NOTE: Data sources are no longer supported.-->
-<step condition="hidden"><para>Enter the name of a data source that
-is available and running (that is, started).</para><para>If you do
-not enter a data source, TrafCI tries to connect to <indexterm><primary
->Admin_Load_DataSource</primary></indexterm><literal>Admin_Load_DataSource</literal
-> by default. If <literal>Admin_Load_DataSource</literal> (or any
-data source that you specify) is not started, TrafCI returns an error
-and prompts you to close the session. If you specify a data source
-that does not exist, TrafCI returns a warning and connects to <indexterm>
-<primary>TDM_Default_DataSource</primary></indexterm><literal>TDM_Default_DataSource</literal
-> instead.</para>
-</step>
-<step><para>After you finish logging in to the database platform,
-the SQL prompt appears:</para>
-<programlisting>Connected to Trafodion
-
-SQL></programlisting>
-<para>At the prompt, you can enter an SQL statement or an interface
-command. For more information, see <xref linkend="Chapter4"
-role="select:label page"/>.</para>
-</step>
-</procedure>
-<note>
-<para>TrafCI allows you to reenter the login values, with a maximum
-of three retries, before it closes the session. For more information,
-see <xref linkend="Retrying-the-Login" role="select:quotedtitle page"
-/>.</para>
-</note>
-</section>
-<section id="log_param">
-<title>Using Login Parameters</title>
-<indexterm><primary>Logging in</primary><secondary>using login parameters</secondary>
-</indexterm><indexterm><primary>Login parameters</primary><secondary
->specifying on the command line</secondary></indexterm>
-<para>To avoid entering a host name, user name, or password each time
-you launch TrafCI, use these login parameters:</para>
-<itemizedlist>
-<listitem><para><literal>‑h</literal> or <literal>‑host</literal></para>
-</listitem>
-<listitem><para><literal>‑u</literal> or <literal>‑user</literal></para>
-</listitem>
-<listitem><para><literal>‑p</literal> or <literal>‑password</literal
-></para></listitem>
-<listitem condition="hidden"><para><literal>‑dsn</literal></para>
-</listitem>
-</itemizedlist>
-<para condition="hidden">To ensure that a specific role is applied
-to the session, use the <literal>-r</literal> or <literal>-role</literal
-> parameter. If you omit the <literal>-r</literal> or <literal>-role</literal
-> parameter, TrafCI applies your default primary role to the session
-and does not prompt you for a role name.</para>
-<note condition="hidden">
-<para>If you launch TrafCI from within HPDM, the TrafCI session inherits
-the connection attributes of the HPDM session<phrase>, including the
-role</phrase>.</para>
-</note>
-<para>For example, on Windows, in the Command Prompt window, enter:</para>
-<programlisting>cd <replaceable>trafci‑installation‑directory</replaceable
->\Trafodion Command Interface\bin
-
-trafci.cmd -h 16.123.456.78:23400 -u user1 ‑p xxxxxx</programlisting>
-<para>For example, on Linux or UNIX, in the terminal window, enter:</para>
-<programlisting>cd <replaceable>trafci‑installation‑directory</replaceable
->/trafci/bin
-
-./trafci.sh -h 16.123.456.78:23400 -u user1 -p xxxxxx</programlisting>
-<para>TrafCI launches and prompts you to enter an SQL statement or
-an interface command:</para>
-<programlisting>Welcome to Apache Trafodion Command Interface 
-Copyright(C) 2015 Apache Software Foundation (ASF)
-
-Connected to Trafodion
-
-SQL></programlisting>
-<para>For more information about the login parameters, see <xref
-linkend="Launch_and_Login_Parameters" role="select:label page"/>.</para>
-<tip>
-<para>You can include these parameters in a shortcut to the <literal
->trafci.cmd</literal> file or in a launch file for the <literal>trafci.sh</literal
-> file. For more information, see <xref linkend="i1007549"
-role="select:quotedtitle page"/> or <xref linkend="i1006829"
-role="select:quotedtitle page"/>, respectively.</para>
-</tip>
-</section>
-<section id="Retrying-the-Login">
-<title>Retrying the Login</title>
-<para>TrafCI allows you to reenter the login values, with a maximum
-of three retries, before it closes the session.</para>
-<para>TrafCI applies the retry logic as follows:</para>
-<itemizedlist>
-<listitem><para>If you specify an invalid host name, TrafCI prompts
-you to reenter the host name. For example:</para>
-<screen><computeroutput>trafci –h dd 
-
-Welcome to Apache Trafodion Command Interface 
-Copyright(C) 2015 Apache Software Foundation
-
-Unknown Host: dd
-
-Host Name/IP Address: </computeroutput><userinput>172.16.1.1
-</userinput><computeroutput>
-User Name: user1
-Password: 
-
-Connected to Trafodion
-
-SQL></computeroutput></screen>
-</listitem>
-<listitem><para>If you specify an invalid user name or password, TrafCI
-prompts you to reenter the user name and password. For example, if
-you specify an invalid password, TrafCI prompts only for your user
-name and password. After three unsuccessful retries, the session is
-terminated:</para>
-<screen><computeroutput>trafci –h 172.16.1.1 –u user1 –p x
- 
-Welcome to Apache Trafodion Command Interface 
-Copyright(C) 2015 Apache Software Foundation
-
-*** ERROR[8837] CLI Authentication : User: user1 : invalid username or password [2014-03-12 16:23:44]
-
-User Name: </computeroutput><userinput>user1</userinput><computeroutput
->
-Password: </computeroutput><computeroutput>
-
-*** ERROR[8837] CLI Authentication : User: user1 : invalid username or password [2014-03-12 16:25:28]
-
-User Name: </computeroutput><userinput>user1</userinput><computeroutput
->
-Password: </computeroutput><computeroutput>
-
-*** ERROR[8837] CLI Authentication : User: user1 : invalid username or password [2014-03-12 16:26:36]
-
-Press any key to close this session
-</computeroutput></screen>
-</listitem>
-<listitem><para>	If all the login parameters that you specify are
-invalid, TrafCI prompts you to enter the host name. When you enter
-a valid host name or IP address, TrafCI prompts you to enter a user
-name and password.</para></listitem>
-<listitem><para>The retry logic applies to the CONNECT and RECONNECT
-commands. For the RECONNECT command, the retry logic applies only
-when no prior connection has been established (<literal>-noconnect</literal
->). This example shows the CONNECT command with a valid user name
-and host name. TrafCI prompts only for the user name and password:</para>
-<screen><computeroutput>SQL></computeroutput><userinput>connect user1/xxx@172.16.1.1</userinput
-><computeroutput>
-
-com.hp.jdbc.HPT4Exception: *** ERROR[8837] CLI Authentication : User: user1 :  invalid username or password [2014-03-12 16:35:15]
-
-User Name: </computeroutput><userinput>user1</userinput><computeroutput
->
-Password: </computeroutput><userinput>abc</userinput><computeroutput
->
-
-Connected to Trafodion
-
-SQL></computeroutput></screen>
-</listitem>
-<listitem><para>TrafCI does not prompt you to reenter the login values
-in these cases:</para>
-<itemizedlist>
-<listitem condition="hidden"><para>If the login fails with an error
-stating that the data source was not started.</para></listitem>
-<listitem><para>When you include the <literal>-q</literal> or <literal
->-version</literal> parameter on the command line. (The <literal>-s</literal
-> parameter permits login retries.)</para></listitem>
-<listitem><para>For a session started using redirected or piped input.</para>
-</listitem>
-</itemizedlist>
-<para>In these cases, TrafCI returns an error message and closes the
-session. You must re-launch the TrafCI session to connect to the Trafodion
-database.</para>
-</listitem>
-</itemizedlist>
-</section>
-</section>
-<section id="i1005070">
-<title>Using Optional Launch Parameters</title>
-<indexterm><primary>Launch parameters</primary><secondary>descriptions
-of</secondary></indexterm>
-<para>To customize how you launch and log in to TrafCI, use the optional
-parameters described in <xref linkend="Launch_and_Login_Parameters"
-role="select:label"/> on the command line:</para>
-<informaltable colsep="0" frame="all" rowsep="0">
-<tgroup cols="1" tgroupstyle="SD  syntax diagram">
-<tbody>
-<row><entry><programlisting>trafci{.sh | .cmd} [<replaceable>optional-parameter</replaceable
->]...</programlisting></entry></row>
-</tbody>
-</tgroup>
-</informaltable>
-<variablelist>
-<varlistentry><term><replaceable>optional-parameter</replaceable></term>
-<listitem><para>is one of the launch or login parameters. For details,
-see <xref linkend="Launch_and_Login_Parameters" role="select:label"
-/>.</para></listitem>
-</varlistentry>
-</variablelist>
-<table frame="topbot" id="Launch_and_Login_Parameters">
-<title>Launch and Login Parameters</title>
-<tgroup cols="2" colsep="0" rowsep="0">
-<colspec colname="col1"/>
-<colspec colname="col2"/>
-<thead>
-<row rowsep="1" valign="bottom"><entry align="left" valign="bottom"
->Launch or Login Parameter</entry><entry align="left" valign="bottom"
->Description</entry></row>
-</thead>
-<tbody>
-<row><entry><indexterm><primary>-h parameter</primary></indexterm
-><indexterm><primary>-host parameter</primary></indexterm><simplelist>
-<member><literal>{-h | -host} <replaceable>host-name</replaceable
->[:<replaceable>port-number</replaceable>]</literal></member>
-<member><literal>{-h | -host} <replaceable>IP-address</replaceable
-><literal>[:</literal><replaceable>port-number</replaceable>]</literal
-></member>
-</simplelist></entry><entry>Specifies the host name or IP address
-of the database platform to which you want the client to connect.
-The <replaceable>host-name</replaceable> should include the domain
-name of the database platform if it is different from the domain of
-the client workstation. If you do not specify a port number, TrafCI
-uses the default port number, which is <phrase>23400</phrase>. For
-an example, see <xref linkend="log_param" role="select:quotedtitle page"
-/>.</entry></row>
-<row><entry><indexterm><primary>-u parameter</primary></indexterm
-><indexterm><primary>-user parameter</primary></indexterm><literal
->{-u | ‑user} <replaceable>username</replaceable></literal> </entry>
-<entry>Specifies the user name for logging in to the database platform.
-The <replaceable>username</replaceable> is case-insensitive. For an
-example, see <xref linkend="log_param" role="select:quotedtitle page"
-/>.</entry></row>
-<row><entry><indexterm><primary>-r parameter</primary></indexterm
-><indexterm><primary>-role parameter</primary></indexterm><literal
->{‑</literal><literal>r| ‑</literal><literal>role} <replaceable>role-name</replaceable
-></literal> </entry><entry><para>Reserved for future use.</para><para
-condition="hidden">Specifies the role to be applied to the TrafCI
-session. A role can be granted to a user, and the role has privileges
-defined for it. Some users are assigned to multiple roles. Using this
-parameter, you can apply a specific role to the session.</para><para
-condition="hidden"><replaceable>role-name</replaceable> is the role
-name, such as DB__USERADMIN. <replaceable>role-name</replaceable> is
-case-insensitive.</para><para condition="hidden">If you omit <replaceable
->role-name</replaceable> when specifying the <literal>-r</literal
-> or <literal>-role</literal> parameter, TrafCI prompts you to enter
-the role name. Enter a role name, or press <guibutton>Enter</guibutton
-> to use your default primary role.</para><para condition="hidden"
->If you omit the <literal>-r</literal> or <literal>-role</literal
-> parameter, TrafCI uses your default primary role and does not prompt
-you for a role name.</para><note condition="hidden">
-<para>If you launch TrafCI from within HPDM, the TrafCI session inherits
-the connection attributes of the HPDM session, including the role.</para>
-</note></entry></row>
-<row><entry><indexterm><primary>-p parameter</primary></indexterm
-><indexterm><primary>-password parameter</primary></indexterm><literal
->{-p | -password} <replaceable>password </replaceable></literal></entry>
-<entry><para>Specifies the password of the user for logging in to
-the database platform. <replaceable>password</replaceable> is case-sensitive.</para
-><para>For an example, see <xref linkend="log_param"
-role="select:quotedtitle page"/>.</para></entry></row>
-<row condition="hidden"><entry><indexterm><primary>-dsn parameter</primary>
-</indexterm><literal>-dsn <replaceable>data-source-name</replaceable
-></literal></entry><entry>Specifies the name of a data source. If <literal
->Admin_Load_DataSource</literal> (or any data source that you specify)
-is not started, TrafCI returns an error and prompts you to close the
-session. If you specify a data source that does not exist, TrafCI
-returns a warning and connects to <literal>TDM_Default_DataSource</literal
-> instead. For an example, see <xref linkend="log_param"
-role="select:quotedtitle page"/>.<note>
-<para>Please avoid using this parameter, as it will be removed in
-a future release.</para>
-</note></entry></row>
-<row><entry><indexterm><primary>-q parameter</primary><secondary>description
-of</secondary></indexterm><indexterm><primary>-sql parameter</primary>
-</indexterm><literal>{-q | -sql} "<replaceable>command</replaceable
->"</literal></entry><entry>Specifies that an SQL statement or an interface
-command be run when launching TrafCI. You cannot specify this parameter
-at the same time as the <literal>‑s</literal> or <literal>‑script</literal
-> parameter. For more information, see <xref linkend="i1005076"
-role="select:quotedtitle page"/>.</entry></row>
-<row><entry><indexterm><primary>-s parameter</primary><secondary>description
-of</secondary></indexterm><indexterm><primary>-script parameter</primary>
-</indexterm><literal>{-s | -script} <replaceable>script-file-name</replaceable
-></literal></entry><entry>Specifies that a script file be run when
-launching TrafCI in interactive mode. You cannot specify this parameter
-at the same time as the <literal>‑q</literal> or <literal>‑sql</literal
-> parameter. For more information, see <xref linkend="i1005079"
-role="select:quotedtitle page"/>.</entry></row>
-<row><entry><indexterm><primary>-noconnect</primary><secondary>description
-of</secondary></indexterm><literal>-noconnect</literal></entry><entry
->Launches an TrafCI session without connecting to the database. For
-more information, see <xref linkend="i1009120"
-role="select:quotedtitle page"/></entry></row>
-<row><entry><indexterm><primary>-version</primary><secondary>description
-of</secondary></indexterm><literal>-version</literal></entry><entry
->Displays the build version of TrafCI and the Trafodion JDBC Type
-4 Driver. Upon completion of the display, the client exits. If any
-other parameters are included with the <literal>-version</literal
-> parameter, they are ignored. For more information, see <xref
-linkend="version" role="select:quotedtitle page"/>.</entry></row>
-<row><entry><indexterm><primary>-help</primary><secondary>description
-of</secondary></indexterm><literal>-help</literal></entry><entry>Displays
-a list of accepted arguments with descriptions and then exits. For
-more information, see <xref linkend="version"
-role="select:quotedtitle page"/>.</entry></row>
-</tbody>
-</tgroup>
-</table>
-<section id="i1005076">
-<title>Running a Command When Launching TrafCI</title>
-<indexterm><primary>Trafodion Command Interface (TrafCI)</primary>
-<secondary>launching and running a command</secondary></indexterm>
-<para>To execute an SQL statement or an interface command when launching
-TrafCI, use the <literal>‑q</literal> or <literal>‑sql</literal> command-line
-parameter. This parameter enables you to run a single command on the
-command line without having to enter commands in TrafCI. </para>
-<note>
-<para>You cannot specify this parameter at the same time as the <literal
->‑s</literal> or <literal>‑script</literal> parameter.</para>
-</note>
-<para>When using <literal>‑q</literal> or <literal>‑sql</literal>,
-you must enclose the command in double quotes. The SQL terminator
-is not required at the end of an SQL statement and is disallowed after
-an interface command. </para>
-<para>Although you can run any of the interface commands with <literal
->‑q</literal> or <literal>‑sql</literal>, the @, OBEY, and PRUN commands
-are the most useful.</para>
-<section>
-<title>Example of Running an SQL Statement With ‑q or ‑sql</title>
-<indexterm><primary>SQL statement</primary><secondary>running when
-launching TrafCI</secondary></indexterm><indexterm><primary>-q parameter</primary>
-<secondary>examples of</secondary></indexterm><indexterm><primary
->CREATE SCHEMA statement, example of</primary></indexterm>
-<para>Use <literal>‑q</literal> or <literal>‑sql</literal> with the
-CREATE SCHEMA statement to create a schema when launching TrafCI:</para>
-<itemizedlist>
-<listitem><para>On Windows, in the Command Prompt window, enter:</para>
-<programlisting><literal>cd </literal><replaceable>trafci-installation-directory</replaceable
-><literal>\Trafodion Command Interface\bin</literal></programlisting>
-<programlisting><literal>trafci.cmd ‑q "create schema persnl"</literal
-></programlisting>
-</listitem>
-<listitem><para>On Linux or UNIX, in the terminal window, enter:</para>
-<programlisting>cd <replaceable>trafci‑installation‑directory</replaceable
->/trafci/bin</programlisting>
-<programlisting>./trafci.sh ‑q "create schema persnl"
-</programlisting>
-</listitem>
-</itemizedlist>
-<note condition="hidden"><indexterm><primary>Schema</primary><secondary
->names (reserved)</secondary></indexterm><indexterm><primary>Reserved
-schema names</primary></indexterm><indexterm><primary>HP_ prefix in
-schema names</primary></indexterm>
-<para>Schema names that begin with HP_ are reserved for use by HP.
-For more information about reserved schema names, see the <citetitle
->Trafodion SQL Reference Manual</citetitle>.</para>
-</note>
-<para>After you enter the SQL statement, TrafCI launches and prompts
-you to log in by default (if you did not specify <literal>‑h</literal
->, <literal>‑u</literal>, and <literal>‑p</literal><phrase
-condition="hidden">, and <literal>‑dsn</literal></phrase> on the command
-line), runs the SQL statement, and then returns to the command prompt:</para>
-<programlisting>Host Name/IP Address: 16.123.456.78:23400
-User Name: user1
-Password:
-
---- SQL operation complete.
-
-C:\Program Files (x86)\Apache Software Foundation\Apache Trafodion Command Interface\bin>_</programlisting>
-</section>
-<section>
-<title>Example of Running an Interface Command With ‑q or ‑sql</title>
-<indexterm><primary>-q parameter</primary><secondary>examples of</secondary>
-</indexterm>
-<para>Use <literal>‑q</literal> or <literal>‑sql</literal> with the
-PRUN command to run multiple script files simultaneously from the
-command line:</para>
-<itemizedlist>
-<listitem><para>On Windows, in the Command Prompt window, enter:</para>
-<programlisting><literal>cd </literal><replaceable>trafci-installation-directory</replaceable
-><literal>\Trafodion Command Interface\bin</literal></programlisting>
-<programlisting><literal>trafci.cmd ‑q "prun"</literal></programlisting>
-</listitem>
-<listitem><para>On Linux, in the terminal window, enter:</para>
-<programlisting>cd <replaceable>trafci‑installation‑directory</replaceable
->/trafci/bin</programlisting>
-<programlisting>./trafci.sh ‑q "prun"</programlisting>
-</listitem>
-</itemizedlist>
-<para>After you enter the interface command, TrafCI launches and prompts
-you to log in by default (if you did not specify <literal>‑h</literal
->, <literal>‑u</literal>, and <literal>‑p</literal><phrase
-condition="hidden">, and <literal>‑dsn</literal></phrase> on the command
-line), and runs the command. The parallel run (PRUN) operation prompts
-you to enter settings and then executes the script files. At the end
-of the PRUN operation, TrafCI returns to the command prompt. For more
-information about the PRUN operation, see <xref linkend="i1005218"
-role="select:quotedtitle page"/>.</para>
-</section>
-</section>
-<section id="i1005079">
-<title>Running a Script File When Launching TrafCI</title>
-<indexterm><primary>Trafodion Command Interface (TrafCI)</primary>
-<secondary>launching and running a script file</secondary></indexterm>
-<indexterm><primary>Script file</primary><secondary>running when launching
-TrafCI</secondary></indexterm>
-<para>To run a script file when launching TrafCI, use the <literal
->‑s</literal> or <literal>‑script</literal> command-line parameter.</para>
-<note>
-<para>You cannot specify this parameter at the same time as the <literal
->‑q</literal> or <literal>‑sql</literal> parameter.</para>
-</note>
-<para>After you launch TrafCI with <literal>‑s</literal> or <literal
->‑script</literal>, TrafCI executes the script file in interactive
-mode. TrafCI remains open until you enter the EXIT, QUIT, or DISCONNECT
-command. To quit the interface immediately after executing a script
-file, include the EXIT, QUIT, or DISCONNECT command at the end of
-the script file.</para>
-<section>
-<title>Example of a Script File</title>
-<indexterm><primary>SET commands, in a script file</primary></indexterm>
-<para>You can create a script file that contains SET commands that
-customize a session when you launch TrafCI:</para>
-<mediaobject><imageobject role="pdf"><imagedata
-fileref="img/launchs1.png"/></imageobject></mediaobject>
-<para>For more information, see <xref linkend="i1004228"
-role="select:quotedtitle page"/>.</para>
-</section>
-<section>
-<title>Example of Running a Script File With -s or -script</title>
-<indexterm><primary>-s parameter</primary><secondary>examples of</secondary>
-</indexterm>
-<itemizedlist>
-<listitem><para>On Windows, in the Command Prompt window, enter:</para>
-<programlisting><literal>cd </literal><replaceable>trafci-installation-directory</replaceable
-><literal>\Trafodion Command Interface\bin</literal></programlisting>
-<programlisting><literal>trafci.cmd ‑s settings.txt</literal></programlisting>
-<para>Specify the full path of the script file if it is outside the
-directory of <literal>trafci.cmd</literal>.</para>
-</listitem>
-<listitem><para>On Linux, in the terminal window, enter:</para>
-<programlisting>cd <replaceable>trafci‑installation‑directory</replaceable
->/trafci/bin</programlisting>
-<programlisting>./trafci.sh ‑s settings.txt</programlisting>
-<para>Specify the full path of the script file if it is outside the
-directory of <literal>trafci.sh</literal>.</para>
-</listitem>
-</itemizedlist>
-<para>TrafCI launches and prompts you to log in by default (if you
-did not specify <literal>‑h</literal>, <literal>‑u</literal>, and <literal
->‑p</literal><phrase condition="hidden">, and <literal>‑dsn</literal
-></phrase> on the command line), and runs the commands in the script
-file:</para>
-<programlisting>Welcome to Apache Trafodion Command Interface 
-Copyright(C) 2015 Apache Software Foundation
-
-Host Name/IP Address: 16.123.456.78:23400
-User Name: user1
-Password:
-
-Connected to Trafodion
-
-SQL>SET IDLETIMEOUT 0
-
-SQL>SET SQLPROMPT *
-
-*SET TIME ON
-
-14:14:57 *SET TIMING ON
-
-2:14:57 PM *SET SQLTERMINATOR .</programlisting>
-</section>
-</section>
-<section id="i1009120">
-<title>Launching TrafCI Without Connecting to the Database</title>
-<indexterm><primary>Trafodion Command Interface (TrafCI)</primary>
-</indexterm>
-<para>To start TrafCI without connecting to a Trafodion database,
-use the <literal>-noconnect</literal> option. See <xref
-linkend="Commands-That-Can-Be-Run-Without-a-Connection"
-role="select:label page"/> for a list of interface commands that can
-be run without a connection.</para>
-<section>
-<title>Example of Launching TrafCI With -noconnect</title>
-<indexterm><primary>-noconnect</primary><secondary>examples of</secondary>
-</indexterm>
-<itemizedlist>
-<listitem><para>On Windows, in the Command Prompt window, enter:</para>
-<programlisting><literal>cd </literal><replaceable>trafci-installation-directory</replaceable
-><literal>\Trafodion Command Interface\bin</literal></programlisting>
-<programlisting><literal>trafci.cmd ‑noconnect</literal></programlisting>
-</listitem>
-<listitem><para>On Linux, in the terminal window, enter:</para>
-<programlisting>cd <replaceable>trafci‑installation‑directory</replaceable
->/trafci/bin</programlisting>
-<programlisting>./trafci.sh ‑noconnect</programlisting>
-</listitem>
-</itemizedlist>
-</section>
-</section>
-<section id="version">
-<title>Running TrafCI With -version</title>
-<indexterm><primary>Trafodion Command Interface (TrafCI)</primary>
-</indexterm>
-<para>To display the build version of TrafCI and the Trafodion JDBC
-Type 4 Driver, use the <literal>-version</literal> option. If other
-parameters are included with the <literal>-version</literal> parameter,
-they are ignored.</para>
-<section>
-<title>Example of Running TrafCI With -version</title>
-<indexterm><primary>-version</primary><secondary>examples of</secondary>
-</indexterm>
-<itemizedlist>
-<listitem><para>On Windows, in the Command Prompt window, enter:</para>
-<programlisting><literal>cd </literal><replaceable>trafci-installation-directory</replaceable
-><literal>\Trafodion Command Interface\bin</literal></programlisting>
-<programlisting><literal>trafci.cmd ‑version</literal></programlisting>
-</listitem>
-<listitem><para>On Linux, in the terminal window, enter:</para>
-<programlisting>cd <replaceable>trafci‑installation‑directory</replaceable
->/trafci/bin</programlisting>
-<!--WRITER'S NOTE: Updated based on the current behavior (2/4/2014):-->
-<programlisting>./trafci.sh ‑version
-
-Welcome to Apache Trafodion Command Interface 
-Copyright(C) 2015 Apache Software Foundation
-
-Trafodion JDBC Type 4 Driver    : Traf_JDBC_Type4_Build_40646
-Trafodion Command Interface     : TrafCI_Build_40646</programlisting>
-</listitem>
-</itemizedlist>
-</section>
-</section>
-<!--WRITER'S NOTE: Verify with Anu that -help is supported in beta version:-->
-<section id="helpoption">
-<title>Running TrafCI With -help</title>
-<indexterm><primary>Trafodion Command Interface (TrafCI)</primary>
-</indexterm>
-<para>To display a list of acceptable list of parameters, including
-proper usage information, use the <literal>-help</literal> option.
-After displaying this information the application exits. </para>
-<section>
-<title>Example of Running TrafCI With -help</title>
-<indexterm><primary>-help</primary><secondary>examples of</secondary>
-</indexterm>
-<itemizedlist>
-<listitem><para>On Windows, in the Command Prompt window, enter:</para>
-<programlisting><literal>cd </literal><replaceable>trafci-installation-directory</replaceable
-><literal>\Trafodion Command Interface\bin</literal></programlisting>
-<programlisting><literal>trafci ‑help</literal></programlisting>
-</listitem>
-<listitem><para>On Linux, in the terminal window, enter:</para>
-<programlisting>cd <replaceable>trafci‑installation‑directory</replaceable
->/trafci/bin</programlisting>
-<programlisting>./trafci.sh ‑help</programlisting>
-</listitem>
-</itemizedlist>
-</section>
-</section>
-</section>
-<section id="i1009121">
-<title>Exiting TrafCI</title>
-<indexterm><primary>Trafodion Command Interface (TrafCI)</primary>
-<secondary>exiting, quitting, or disconnecting</secondary></indexterm>
-<para>To exit TrafCI, enter one of these commands at a prompt:</para>
-<itemizedlist>
-<listitem><para>EXIT</para></listitem>
-<listitem><para>QUIT</para></listitem>
-</itemizedlist>
-<para>For example: </para>
-<programlisting>SQL>quit</programlisting>
-<para>These commands are not case-sensitive and do not require a terminator
-before you press Enter. After you enter one of these commands, TrafCI
-immediately quits running and disappears from the screen.</para>
-</section>
-</chapter>
-<chapter id="Chapter4">
-<title>Running Commands Interactively in TrafCI</title>
-<para>After launching TrafCI, you can run SQL statements and interface
-commands in the command-line interface.</para>
-<itemizedlist>
-<listitem><para><xref linkend="i1004442" role="select:quotedtitle page"
-/></para></listitem>
-<listitem><para><xref linkend="i1004399" role="select:quotedtitle page"
-/></para></listitem>
-<listitem><para><xref linkend="i1004560" role="select:quotedtitle page"
-/></para></listitem>
-<listitem><para><xref linkend="i1006598" role="select:quotedtitle page"
-/></para></listitem>
-</itemizedlist>
-<section id="i1004442">
-<title>User Interface</title>
-<indexterm><primary>Trafodion Command Interface (TrafCI)</primary>
-<secondary>description of</secondary></indexterm>
-<itemizedlist>
-<listitem><para><xref linkend="i1005602" role="select:quotedtitle page"
-/></para></listitem>
-<listitem><para><xref linkend="i1005606" role="select:quotedtitle page"
-/></para></listitem>
-<listitem><para><xref linkend="i1005610" role="select:quotedtitle page"
-/></para></listitem>
-<listitem><para><xref linkend="i1005615" role="select:quotedtitle page"
-/></para></listitem>
-</itemizedlist>
-<section id="i1005602">
-<title>Product Banner</title>
-<indexterm><primary>Trafodion Command Interface (TrafCI)</primary>
-<secondary>product banner</secondary></indexterm><indexterm><primary
->Product banner</primary></indexterm><indexterm condition="hidden">
-<primary>Data source connection</primary></indexterm>
-<para>After you launch TrafCI and connect to the database platform,
-the product banner appears in the command-line interface:</para>
-<!--WRITER'S NOTE: Update this illustration to exclude the data source:-->
-<mediaobject><imageobject role="pdf"><imagedata contentwidth="6in"
-fileref="img/VST401.png" role="pdf"/></imageobject></mediaobject>
-</section>
-<section id="i1005606">
-<title>Interface Prompt</title>
-<indexterm><primary>Trafodion Command Interface (TrafCI)</primary>
-<secondary>prompt</secondary></indexterm><indexterm><primary>Standard
-prompt</primary><secondary>description of</secondary></indexterm>
-<indexterm><primary>Prompt</primary></indexterm><indexterm><primary
->SQL prompt</primary><secondary>description of</secondary></indexterm>
-<para>The standard prompt is <literal>SQL></literal>. You can change
-the prompt, <literal>SQL></literal>, to something else by using the
-SET SQLPROMPT or SET PROMPT command. For more information, see the <xref
-linkend="i1004585" role="select:quotedtitle page"/>.</para>
-</section>
-<section id="i1005610">
-<title>Breaking the Command Line</title>
-<indexterm><primary>Command line, breaking</primary></indexterm>
-<indexterm><primary>Trafodion Command Interface (TrafCI)</primary>
-<secondary>breaking across lines</secondary></indexterm>
-<para>You cannot break an interface command over multiple lines. Each
-interface command must be entered on one line. If you accidentally
-break an interface command across more than one line, enter the SQL
-terminator and then reenter the command on one line.</para>
-<indexterm><primary>SQL statement</primary><secondary>breaking across
-lines</secondary></indexterm>
-<para>You can continue any SQL statement over multiple lines, breaking
-that statement at any point except within a word, a numeric literal,
-or a multicharacter operator (for example, &lt;=). To break a string
-literal in a DML statement, use a concatenation operator (||). For
-more information, see the concatenation operator in the <citetitle
->Trafodion SQL Reference Manual</citetitle>. </para>
-<indexterm><primary>SQL statement</primary><secondary>terminating</secondary>
-</indexterm>
-<para>To terminate an SQL statement that spans multiple lines, use
-the SQL terminator for the session. You can also include several SQL
-statements on the same command line provided that each one is terminated
-by the SQL terminator. For more information, see <xref
-linkend="i1004589" role="select:quotedtitle page"/>.</para>
-</section>
-<section id="i1005615">
-<title>Case Sensitivity</title>
-<indexterm><primary>Case sensitivity</primary></indexterm><indexterm>
-<primary>Trafodion Command Interface (TrafCI)</primary><secondary
->case sensitivity</secondary></indexterm>
-<para>In the command-line interface, you can enter SQL statements
-and interface commands in uppercase, lowercase, or mixed-case characters.
-All parts of statements and commands are case-insensitive except for
-parts that you enclose in single-quotes (') or double-quotes (").</para>
-</section>
-</section>
-<section id="i1004399">
-<title>Using the Interface Commands</title>
-<para>The interface commands allow you to customize TrafCI (for example,
-by using SET commands) or return information about the interface settings
-or database objects (for example, by using SHOW commands):</para>
-<itemizedlist>
-<listitem><para><xref linkend="Showing-Session-Attributes"
-role="select:quotedtitle page"/></para></listitem>
-<listitem><para><xref linkend="i1006792" role="select:quotedtitle page"
-/></para></listitem>
-<listitem><para><xref linkend="i1004585" role="select:quotedtitle page"
-/></para></listitem>
-<listitem><para><xref linkend="i1004589" role="select:quotedtitle page"
-/></para></listitem>
-<listitem><para><xref linkend="i1004593" role="select:quotedtitle page"
-/></para></listitem>
-<listitem><para><xref linkend="i1004597" role="select:quotedtitle page"
-/></para></listitem>
-<listitem><para><xref linkend="Limiting-Result-Set"
-role="select:quotedtitle page"/></para></listitem>
-<listitem condition="hidden"><para><xref
-linkend="Showing-Info-DB-Objects" role="select:quotedtitle page"/></para>
-</listitem>
-<listitem><para><xref linkend="Displaying-Executed-Commands"
-role="select:quotedtitle page"/></para></listitem>
-<listitem><para><xref linkend="Editing-Reexecuting"
-role="select:quotedtitle page"/></para></listitem>
-<listitem><para><xref linkend="Clearing-Interface"
-role="select:quotedtitle page"/></para></listitem>
-<listitem><para><xref linkend="Obtaining-Help"
-role="select:quotedtitle page"/></para></listitem>
-</itemizedlist>
-<para>For more information about the interface commands, see <xref
-linkend="i1008451" role="select:label page"/>.</para>
-<note>
-<para>Each interface command must be entered on one line. If you accidentally
-break an interface command across more than one line, enter the SQL
-terminator and then reenter the command on one line.</para>
-</note>
-<section id="Showing-Session-Attributes">
-<title>Showing the Session Attributes</title>
-<para>To display the attributes and settings of the current TrafCI
-session, use the ENV, SHOW SESSION, or SESSION command. For example,
-this SESSION command displays the session attributes:</para>
-<!--WRITER'S NOTE: Updated output based on current behavior (2/4/2014):-->
-<programlisting>SQL>session
-
-COLSEP          " "
-<phrase condition="hidden">DATASOURCE      TDM_Default_DataSource
-</phrase>HISTOPT         DEFAULT [No expansion of script files]
-IDLETIMEOUT     0 min(s) [Never Expires]
-LIST_COUNT      0 [All Rows]
-LOG FILE        c:\session.txt
-LOG OPTIONS     APPEND,CMDTEXT ON
-MARKUP          RAW
-PROMPT          SQL>
-SCHEMA          SEABASE
-SERVER          sqws135.houston.hp.com:23400
-SQLTERMINATOR   ;
-STATISTICS      OFF
-TIME            OFF
-TIMING          OFF
-USER            user1
-
-SQL></programlisting>
-<para>For more information, see the <xref linkend="ENV"
-role="select:quotedtitle page"/> or <xref linkend="SESSION"
-role="select:quotedtitle page"/>.</para>
-</section>
-<section id="i1006792">
-<title>Setting and Showing the Idle Timeout Value for the Session</title>
-<indexterm><primary>Idle timeout value</primary></indexterm><indexterm>
-<primary>Timeout, idle session</primary></indexterm><indexterm><primary
->Session</primary></indexterm><indexterm><primary>SET IDLETIMEOUT
-command</primary><secondary>example of</secondary></indexterm>
-<para>The idle timeout value of a session determines when the session
-expires after a period of inactivity. To set the idle timeout value
-of a session, enter the SET IDLETIMEOUT command. For example, this
-SET IDLETIMEOUT 0 command sets the idle timeout to an infinite amount
-of time so that the session never expires:</para>
-<programlisting>SQL>set idletimeout 0
-
-SQL></programlisting>
-<indexterm><primary>SHOW IDLETIMEOUT command</primary><secondary>example
-of</secondary></indexterm>
-<para>To show the idle timeout value that is in effect for the session,
-enter the SHOW IDLETIMEOUT command. For example, this SHOW IDLETIMEOUT
-command displays an idle timeout of zero minutes, which means that
-the session never expires:</para>
-<programlisting>SQL>show idletimeout
-IDLETIMEOUT 0 min(s) [Never Expires]
-
-SQL></programlisting>
-<para>For more information, see the <xref linkend="i1008731"
-role="select:quotedtitle page"/> and the <xref linkend="i1009114"
-role="select:quotedtitle page"/>.</para>
-</section>
-<section id="i1004585">
-<title>Customizing the Standard Prompt</title>
-<indexterm><primary>Standard prompts</primary><secondary>customizing</secondary>
-</indexterm>
-<para>To change the standard prompt in the command-line interface,
-use one or both of these commands:</para>
-<itemizedlist>
-<listitem><para><xref linkend="SET-PROMPT"
-role="select:quotedtitle page"/></para></listitem>
-<listitem><para><xref linkend="i1004724" role="select:quotedtitle page"
-/></para></listitem>
-</itemizedlist>
-<section id="i1004720">
-<title>SET PROMPT Command</title>
-<indexterm><primary>SET PROMPT command</primary><secondary>example
-of</secondary></indexterm>
-<para>The SET PROMPT command changes the default prompt to a specified
-character or string. For example, this SET PROMPT command changes
-the prompt to the current user (<literal>user1</literal>) and <literal
->ENTER></literal>:</para>
-<programlisting>SQL>set prompt "%USER ENTER>"
-
-user1 ENTER></programlisting>
-<para>For more information, see the <xref linkend="SET-PROMPT"
-role="select:quotedtitle page"/>.</para>
-</section>
-<section id="i1004724">
-<title>SET TIME Command</title>
-<indexterm><primary>SET TIME command</primary><secondary>examples
-of</secondary></indexterm><indexterm><primary>Standard prompts</primary>
-<secondary>displaying the current time</secondary></indexterm>
-<para>The SET TIME ON command causes the current time of the client
-workstation to be displayed in the prompt:</para>
-<programlisting>SQL ENTER>set time on
-
-20:32:26 SQL ENTER></programlisting>
-<para>The SET TIME OFF command removes the current time from the prompt:</para>
-<programlisting>20:32:26 SQL ENTER>set time off
-
-SQL ENTER></programlisting>
-<para>For more information, see the <xref linkend="i1005242"
-role="select:quotedtitle page"/>.</para>
-</section>
-</section>
-<section id="i1004589">
-<title>Setting and Showing the SQL Terminator</title>
-<indexterm><primary>SQL terminator</primary><secondary>setting</secondary>
-</indexterm><indexterm><primary>SET SQLTERMINATOR command</primary>
-<secondary>example of</secondary></indexterm><indexterm><primary>INSERT
-statement, example of</primary></indexterm>
-<para>The SQL terminator symbolizes the end of an SQL statement. By
-default, the SQL terminator is a semicolon (;).</para>
-<para>To change the SQL terminator, enter the SET SQLTERMINATOR command.
-For example, this SET SQLTERMINATOR command sets the SQL terminator
-to a period (.):</para>
-<programlisting>SQL>set sqlterminator .
-
-SQL>insert into sales.custlist
-+>(select * from invent.supplier
-+>where suppnum=8).
-
---- 1 row(s) inserted.
-
-SQL></programlisting>
-<indexterm><primary>SQL terminator</primary><secondary>showing</secondary>
-</indexterm>
-<para>To show the SQL terminator that is in effect for the session,
-enter the SHOW SQLTERMINATOR command. For example, this SHOW SQLTERMINATOR
-command displays <literal>SQLTERMINATOR .</literal>, where the period
-(.) is the SQL terminator for the session:</para>
-<programlisting>SQL>show sqlterminator
-SQLTERMINATOR .
-
-SQL></programlisting>
-<para>For more information, see the <xref linkend="i1005238"
-role="select:quotedtitle page"/> and the <xref linkend="i1005270"
-role="select:quotedtitle page"/>.</para>
-</section>
-<section id="i1004593">
-<title>Displaying the Elapsed Time</title>
-<indexterm><primary>Elapsed time, displaying</primary></indexterm>
-<indexterm><primary>SQL statement</primary><secondary>displaying the
-elapsed time</secondary></indexterm><indexterm><primary>SET TIMING
-command</primary><secondary>examples of</secondary></indexterm>
-<para>By default, TrafCI does not display the elapsed time of an SQL
-statement after the statement executes. To display the elapsed time
-after each SQL statement executes, enter the SET TIMING ON command:</para>
-<programlisting>SQL>set timing on
-
-SQL>select suppname, street, city, state, postcode
-+>from invent.supplier
-+>where suppnum=3;
-
-SUPPNAME          STREET               CITY           STATE        POSTCODE
------------------ -------------------- -------------- ------------ ----------
-HIGH DENSITY INC  7600 EMERSON         NEW YORK       NEW YORK     10230
-
---- 1 row(s) selected.
-
-Elapsed :00:00:00.111
-
-SQL></programlisting>
-<para>To prevent the elapsed time from being displayed after each
-SQL statement executes, enter the SET TIMING OFF command:</para>
-<programlisting>SQL>set timing off
-
-SQL>/
-
-SUPPNAME          STREET               CITY           STATE        POSTCODE
------------------ -------------------- -------------- ------------ ----------
-HIGH DENSITY INC  7600 EMERSON         NEW YORK       NEW YORK     10230
-
---- 1 row(s) selected.
-
-SQL></programlisting>
-<para>For more information, see the <xref linkend="i1005246"
-role="select:quotedtitle page"/>.</para>
-</section>
-<section id="i1004597">
-<title>Setting and Showing the Current Schema</title>
-<indexterm><primary>Default schema</primary></indexterm><indexterm>
-<primary>SET SCHEMA statement, example of</primary></indexterm>
-<indexterm><primary>Schema</primary><secondary>setting the current
-schema</secondary></indexterm>
-<para>By default, the schema of the session is USR. The SQL statement,
-SET SCHEMA, allows you to set the schema for the TrafCI session. For
-example, this SET SCHEMA statement changes the default schema to PERSNL
-for the session:</para>
-<programlisting>SQL>set schema persnl;
-
---- SQL operation complete.
-
-SQL>delete from employee
-+>where first_name='TIM' and
-+>last_name='WALKER';
-
---- 1 row(s) deleted.
-
-SQL></programlisting>
-<para>The schema that you specify with SET SCHEMA remains in effect
-until the end of the session or until you execute another SET SCHEMA
-statement.</para>
-<para>If you execute this statement in a script file, it affects not
-only the SQL statements in the script file but all subsequent SQL
-statements that are run in the current session. If you set the schema
-in a script file, reset the default schema for the session at the
-end of the script file.</para>
-<para>For more information about the SET SCHEMA statement, see the <citetitle
->Trafodion SQL Reference Manual</citetitle>.</para>
-<indexterm><primary>SHOW SCHEMA command</primary><secondary>example
-of</secondary></indexterm><indexterm><primary>Schema</primary>
-<secondary>showing the current schema</secondary></indexterm>
-<para>The SHOW SCHEMA command displays the current schema for the
-session. For example, this SHOW SCHEMA command displays <literal>SCHEMA PERSNL</literal
->, where PERSNL is the name of the current schema for the session:</para>
-<programlisting>SQL>show schema
-SCHEMA PERSNL
-
-SQL></programlisting>
-<para>For more information, see the <xref linkend="i1005258"
-role="select:quotedtitle page"/>.</para>
-</section>
-<section id="Limiting-Result-Set">
-<title>Limiting the Result Set of a Query</title>
-<para>To set the maximum number of rows to be returned by SELECT statements
-that are executed in the session, enter the SET LIST_COUNT command.
-For example, this SET LIST_COUNT command limits the result set of
-queries to 20 rows:</para>
-<programlisting>SQL>set list_count 20</programlisting>
-<para>To show the limit that is in effect for the session, enter the
-SHOW LIST_COUNT command. For example, this SHOW LIST_COUNT command
-shows that the number of rows returned by SELECT statements is unlimited:<programlisting
->SQL>show list_count
-LISTCOUNT 0 [All Rows]</programlisting></para>
-<para>For more information, see the <xref linkend="SET-LIST-COUNT"
-role="select:quotedtitle page"/> and the <xref linkend="SHOW-LIST-COUNT"
-role="select:quotedtitle page"/>.</para>
-</section>
-<section condition="hidden" id="Showing-Info-DB-Objects">
-<title>Showing Information About SQL Database Objects</title>
-<itemizedlist>
-<listitem><para><xref linkend="i1005377" role="select:quotedtitle page"
-/></para></listitem>
-<listitem><para><xref linkend="i1004959" role="select:quotedtitle page"
-/></para></listitem>
-<listitem><para><xref linkend="i1009685" role="select:quotedtitle page"
-/></para></listitem>
-<listitem><para><xref linkend="i1009772" role="select:quotedtitle page"
-/></para></listitem>
-<listitem><para><xref linkend="i1009892" role="select:quotedtitle page"
-/></para></listitem>
-</itemizedlist>
-<section id="i1005377">
-<title>Showing the Schemas</title>
-<indexterm><primary>SHOW SCHEMAS command</primary><secondary>example
-of</secondary></indexterm><indexterm><primary>Schema</primary>
-<secondary>showing all schemas in the default catalog</secondary>
-</indexterm>
-<para>The SHOW SCHEMAS command displays the schemas that exist in
-the default catalog:</para>
-<programlisting>SQL>show schemas
-
-SCHEMA NAMES
---------------------------------------------------------------------------------
-HP_DEFINITION_SCHEMA   HP_TRANSPORTER         HP_USTAT               PUBLIC_ACCESS_SCHEMA
-HP_INFORMATION_SCHEMA  
-
-SQL></programlisting>
-<para>For more information, see the <xref linkend="i1005262"
-role="select:quotedtitle page"/>.</para>
-</section>
-<section id="i1004959">
-<title>Showing the Tables in a Schema</title>
-<indexterm><primary>Tables</primary><secondary>showing all tables
-in a schema</secondary></indexterm><indexterm><primary>SHOW TABLES
-command</primary><secondary>example of</secondary></indexterm>
-<para>The SHOW TABLES command displays the tables that exist in the
-current schema. For example, this SHOW TABLES command displays all
-the tables in the current schema, PERSNL:</para>
-<programlisting>SQL>show schema
-SCHEMA PERSNL
-
-SQL>show tables
-
-TABLE NAMES
-----------------------------------------------------------------
-DEPT      EMPLOYEE  JOB       PROJECT
-
-SQL></programlisting>
-<para>For more information, see the <xref linkend="i1005274"
-role="select:quotedtitle page"/>.</para>
-</section>
-<section id="i1009685">
-<title>Showing the Dependent Objects of a Table</title>
-<indexterm><primary>Indexes, showing all indexes of a table</primary>
-</indexterm><indexterm><primary>SHOW TABLE command</primary><secondary
->example of</secondary></indexterm>
-<para>The SHOW TABLE command displays information about the indexes,
-materialized views, or synonyms of a specified table. For example,
-this SHOW TABLE command with the INDEXES option displays information
-about each index of the EMPLOYEE table:</para>
-<programlisting>SQL>show table persnl.employee, indexes
-
-COLUMN NAME                     ORDER INDEX TYPE UNIQUE CARDINALITY POSITION 
-------------------------------- ----- ---------- ------ ----------- -------- 
-
-Index 1 :EMPLOYEE
------------------
-EMPNUM                          ASC   Other      Yes              0        1 
-
-Index 2 :XEMPDEPT
------------------
-DEPTNUM                         ASC   Other      No               0        1 
-
-Index 3 :XEMPNAME
------------------
-LAST_NAME                       ASC   Other      No               0        1 
-FIRST_NAME                      ASC   Other      No               0        2 
-
-
-SQL></programlisting>
-<para>For more information, see the <xref linkend="i1009180"
-role="select:quotedtitle page"/>.</para>
-</section>
-<section id="i1009772">
-<title>Showing the Views in a Schema</title>
-<indexterm><primary>Views</primary><secondary>showing all views in
-a schema</secondary></indexterm><indexterm><primary>SHOW VIEWS command</primary>
-<secondary>example of</secondary></indexterm>
-<para>The SHOW VIEWS command displays the views that exist in the
-current schema. For example, this SHOW VIEWS command displays all
-the views in the current schema, INVENT:</para>
-<programlisting>SQL>set schema invent;
-
---- SQL operation complete.
-
-SQL>show schema
-SCHEMA INVENT
-
-SQL>show views
-
-VIEW NAMES
-----------------------------------------------------------------
-VIEW207   VIEW207N  VIEWCS    VIEWCUST  
-
-SQL></programlisting>
-<para>For more information, see the <xref linkend="i1009184"
-role="select:quotedtitle page"/>.</para>
-<indexterm><primary>Materialized views</primary><secondary>showing
-all materialized views in a schema</secondary></indexterm><indexterm>
-<primary>SHOW MVS command</primary><secondary>example of</secondary>
-</indexterm>
-<para>The SHOW MVS command displays the materialized views that exist
-in the current schema. For example, this SHOW MVS command displays
-all the materialized views in the current schema, PERSNL:</para>
-<programlisting>SQL>set schema persnl;
-
---- SQL operation complete.
-
-SQL>show schema
-SCHEMA PERSNL
-
-SQL>show mvs;
-
-MATERIALIZED VIEW NAMES
--------------------------------------------------------------
-mvemp1  mvemp2  mvemp3  mvjobdesc
-
-SQL></programlisting>
-<para>For more information, see the <xref linkend="i1011926"
-role="select:quotedtitle page"/>.</para>
-</section>
-<section id="i1009892">
-<title>Showing the Synonyms in a Schema</title>
-<indexterm><primary>Synonyms</primary><secondary>showing all synonyms
-in a schema</secondary></indexterm><indexterm><primary>SHOW SYNONYMS
-command</primary><secondary>example of</secondary></indexterm>
-<para>The SHOW SYNONYMS command displays the synonyms that exist in
-the current schema. For example, this SHOW SYNONYMS command displays
-all the synonyms in the current schema, SALES:</para>
-<programlisting>SQL>set schema sales;
-
---- SQL operation complete.
-
-SQL>show schema
-SCHEMA SALES
-
-SQL>show synonyms
-
-SYNONYM NAMES
--------------------------------------------------------------
-CUST  DTLS  ORDR  PRTS  
-
-SQL></programlisting>
-<para>For more information, see the <xref linkend="i1012014"
-role="select:quotedtitle page"/>.</para>
-</section>
-</section>
-<section id="Displaying-Executed-Commands">
-<title>Displaying Executed Commands</title>
-<para>To display commands that were recently executed in the TrafCI
-session, enter the HISTORY command. The HISTORY command associates
-each command with a number that you can use to reexecute or edit the
-command with the FC command. See <xref linkend="Editing-Reexecuting"
-role="select:quotedtitle page"/>.</para>
-<para>For example, this HISTORY command displays a maximum of 100
-commands that were entered in the session:</para>
-<programlisting>SQL>history
-1>      set idletimeout 0
-2>      set schema persnl;
-3>      select * from project;
-
-SQL></programlisting>
-<para>To save the session history in a user-specified file, enter
-the SAVEHIST command. For example, this SAVEHIST command saves the
-session history in a file named <literal>history.txt</literal> in
-the local directory where you are running TrafCI:<programlisting>SQL>savehist history.txt</programlisting
-></para>
-<para>For more information, see the <xref linkend="i1013406"
-role="select:quotedtitle page"/> and the <xref linkend="SAVEHIST"
-role="select:quotedtitle page"/>.</para>
-</section>
-<section id="Editing-Reexecuting">
-<title>Editing and Reexecuting a Command</title>
-<para>To edit and reexecute a command in the history buffer of an
-TrafCI session, enter the FC command. To display the commands in the
-history buffer, use the HISTORY command. See <xref
-linkend="Displaying-Executed-Commands" role="select:quotedtitle page"
-/>.</para>
-<para>For example, this FC command and its delete (D) editing command
-correct a SELECT statement that was entered incorrectly:</para>
-<programlisting>SQL>fc
-SQL>selecct * from employee;
-....    d
-SQL>select * from employee;
-....</programlisting>
-<para>Pressing Enter executes the corrected SELECT statement.</para>
-<para>For more information, see the <xref linkend="i1011597"
-role="select:quotedtitle page"/>.</para>
-</section>
-<section id="Clearing-Interface">
-<title>Clearing the Interface Window</title>
-<para>After entering commands in TrafCI, you can clear the interface
-window by using the CLEAR command. For example, this CLEAR command
-clears the interface window so that only the prompt appears at the
-top of the window:</para>
-<programlisting>SQL>clear</programlisting>
-<para>For more information, see the <xref linkend="CLEAR-Command"
-role="select:quotedtitle page"/>.</para>
-</section>
-<!--WRITER'S NOTE: Verify with Anu that the help is working in the beta version.-->
-<section id="Obtaining-Help">
-<title>Obtaining Help</title>
-<para>To display help text for an interface command that is supported
-in TrafCI, enter the HELP command. For example, this HELP command
-displays syntax and examples of the FC command:</para>
-<programlisting>SQL>help fc</programlisting>
-<para>For more information, see the <xref linkend="HELP"
-role="select:quotedtitle page"/>.</para>
-</section>
-</section>
-<section id="i1004560">
-<title>Running SQL Statements</title>
-<indexterm><primary>SQL statement</primary><secondary>running in TrafCI</secondary>
-</indexterm>
-<para>In TrafCI, you can run SQL statements interactively. <phrase
->TrafCI supports all the SQL statements, SQL utilities, and other
-SQL-related commands that the Trafodion database engine supports.
-For more information about those SQL statements, see the <citetitle
->Trafodion SQL Reference Manual</citetitle>.</phrase></para>
-<para>This subsection shows examples of:</para>
-<itemizedlist>
-<listitem><para><xref linkend="i1006242" role="select:quotedtitle page"
-/></para></listitem>
-<listitem><para><xref linkend="i1006246" role="select:quotedtitle page"
-/></para></listitem>
-<listitem><para><xref linkend="i1006983" role="select:quotedtitle page"
-/></para></listitem>
-<listitem condition="hidden"><para><xref linkend="CREATE-TRIGGER"
-role="select:quotedtitle page"/></para></listitem>
-</itemizedlist>
-<para>To run SQL statements from script files in TrafCI, see <xref
-linkend="Chapter5" role="select:label page"/>.</para>
-<section id="i1006242">
-<title>Executing an SQL Statement</title>
-<indexterm><primary>SELECT statement, example of</primary></indexterm>
-<para>For example, you can query the EMPLOYEE table and return an
-employee’s salary by executing this SELECT statement in TrafCI:</para>
-<programlisting>SQL>select salary
-+>from persnl.employee
-+>where jobcode=100;
-
-SALARY     
----------- 
- 175500.00 
- 137000.10 
- 139400.00 
- 138000.40 
-  75000.00 
-  90000.00 
- 118000.00 
-  80000.00 
-  70000.00 
-  90000.00 
-  56000.00 
-
---- 11 row(s) selected.
-
-SQL></programlisting>
-<para>If the SQL statement executes successfully, TrafCI returns a
-message indicating that the SQL operation was successful, followed
-by the standard prompt. If a problem occurs during the execution of
-the SQL statement, TrafCI returns an error message.<indexterm><primary
->Error messages</primary></indexterm></para>
-</section>
-<section id="i1006246">
-<title>Repeating an SQL Statement</title>
-<indexterm><primary>SQL statement</primary><secondary>repeating</secondary>
-</indexterm><indexterm><primary>/ command</primary><secondary>example
-of</secondary></indexterm>
-<para>To run a previously executed SQL statement, use the /, RUN,
-or REPEAT command.</para>
-<programlisting>SQL>/
-
-SALARY     
----------- 
- 175500.00 
- 137000.10 
- 139400.00 
- 138000.40 
-  75000.00 
-  90000.00 
- 118000.00 
-  80000.00 
-  70000.00 
-  90000.00 
-  56000.00 
-
---- 11 row(s) selected.
-
-SQL></programlisting>
-<para>For more information, see the <xref linkend="i1005310"
-role="select:quotedtitle page"/>, <xref linkend="i1008105"
-role="select:quotedtitle page"/>, or <xref linkend="i1014853"
-role="select:quotedtitle page"/>.</para>
-</section>
-<section id="i1006983"

<TRUNCATED>

Mime
View raw message