<?xml version='1.0' encoding='ISO-8859-1' ?>

<WebWorksHelpTOC version="4.0">
 <i t="Preface" l="1">
  <i t="What Is DataDirect SequeLink&#174;?" l="2" />
  <i t="Using This Book" l="3" />
  <i t="Other SequeLink&#174; Documentation" l="4">
   <i t="HTML Version" l="4#wp1055960" />
   <i t=" PDF Version" l="4#wp1055978" />
  </i>
  <i t="Typographical Conventions" l="5" />
  <i t="Environment-Specific Information" l="6" />
  <i t="Contacting Technical Support" l="7" />
 </i>
 <i t="Part 1: Developing ODBC Applications" l="8" />
 <i t="1  Using the ODBC Client" l="9">
  <i t="About the ODBC Client" l="10" />
  <i t="Using the ODBC Administrator" l="11" />
  <i t="Configuring ODBC Client Data Sources on Windows" l="12">
   <i t="Configuring ODBC User and System Client Data Sources" l="12#wp997337" />
   <i t="Configuring ODBC File Client Data Sources" l="12#wp1011551" />
   <i t="ODBC Connection Dialogs" l="12#wp527051" />
   <i t="Testing ODBC Connections on Windows" l="12#wp530582" />
  </i>
  <i t="Configuring ODBC Client Data Sources on Linux and UNIX" l="13">
   <i t="Configuring the System Information File" l="13#wp531342" />
   <i t="Example: odbc.ini for Solaris" l="13#wp531203" />
   <i t="Example: odbc64.ini for Solaris" l="13#wp1090111" />
   <i t="Setting Environment Variables" l="13#wp527183" />
   <i t="Using a Centralized System Information File" l="13#wp1025868" />
  </i>
  <i t="Connecting Using a Connection String" l="14">
   <i t="DSN-less Connections in Linux and UNIX" l="14#wp1052625" />
  </i>
  <i t="ODBC Connection Attributes" l="15" />
  <i t="Configuring Connection Failover" l="16">
   <i t="Connection Failover Properties" l="16#wp1070835" />
  </i>
  <i t="Using Client Load Balancing" l="17" />
  <i t="Using Connection Retry" l="18" />
 </i>
 <i t="2  Developing ODBC Applications" l="19">
  <i t="Required ODBC Libraries and Header Files" l="20" />
  <i t="Compiler Requirements" l="21" />
  <i t="ODBC API Functions" l="22">
   <i t="Binding SQL Statements" l="22#wp55064" />
   <i t="Support for Unicode ODBC W (Wide) Function Calls" l="22#wp49113" />
  </i>
  <i t="SQL Escape Sequences" l="23" />
  <i t="Data Types and Isolation Levels" l="24" />
  <i t="Threading" l="25">
   <i t="Threading Architecture" l="25#wp14658" />
   <i t="Cancelling Functions in Multithreaded Applications" l="25#wp14173" />
  </i>
  <i t="Using Scrollable Cursors" l="26">
   <i t="Static and Keyset-Driven Cursors" l="26#wp12867" />
   <i t="Using Static Scrollable Cursors" l="26#wp12913" />
   <i t="Using Keyset-Driven Scrollable Cursors" l="26#wp15010" />
  </i>
  <i t="Using Stored Procedures with Oracle" l="27" />
  <i t="Specifying Application IDs" l="28">
   <i t="Specifying Application IDs Explicitly" l="28#wp17563" />
   <i t="Generating Application IDs Automatically" l="28#wp13037" />
  </i>
  <i t="Sending Arrays of Parameters" l="29" />
  <i t="Persisting a Result Set as an XML Data File" l="30" />
  <i t="Error Handling" l="31">
   <i t="SequeLink&#174; for ODBC Driver Errors" l="31#wp80571" />
   <i t="SequeLink&#174; Client Errors" l="31#wp80577" />
   <i t="SequeLink&#174; Server Errors" l="31#wp80587" />
   <i t="Database Errors" l="31#wp80606" />
  </i>
  <i t="Developing Performance-Optimized ODBC Applications" l="32">
   <i t="Catalog Functions" l="32#wp13229" />
   <i t="Retrieving Data" l="32#wp13297" />
   <i t="Selecting ODBC Function" l="32#wp70986" />
   <i t="Managing Connections and Updates" l="32#wp63429" />
  </i>
 </i>
 <i t="Part 2: Developing ADO Applications" l="33" />
 <i t="3  Using the ADO Client" l="34">
  <i t="About the ADO Client" l="35" />
  <i t="Using the DataDirect Configuration Manager" l="36">
   <i t="Working with the DataDirect Configuration Manager" l="36#wp1055259" />
   <i t="Displaying Data Source Properties" l="36#wp1055397" />
  </i>
  <i t="Configuring ADO Client Data Sources" l="37">
   <i t="Creating an ADO Client Data Source" l="37#wp1055460" />
   <i t="Modifying an ADO Client Data Source" l="37#wp1055576" />
   <i t="Renaming an ADO Client Data Source" l="37#wp1055584" />
   <i t="Deleting an ADO Client Data Source" l="37#wp1055601" />
   <i t="Copying an ADO Client Data Source" l="37#wp1055612" />
   <i t="Changing Data Source Directories" l="37#wp1055628" />
   <i t="Defining Default Setup Options" l="37#wp1055651" />
  </i>
  <i t="Connecting to an ADO Client" l="38">
   <i t="Testing ADO Connections" l="38#wp1055726" />
   <i t="ADO Connection Dialogs" l="38#wp1055744" />
   <i t="Connecting with a Provider String" l="38#wp1055899" />
   <i t="ADO Connection Attributes" l="38#wp1055916" />
  </i>
  <i t="Configuring Connection Failover" l="39">
   <i t="Connection Failover Properties" l="39#wp1056149" />
  </i>
  <i t="Using Client Load Balancing" l="40" />
  <i t="Using Connection Retry" l="41" />
 </i>
 <i t="4  Developing ADO Applications" l="42">
  <i t="OLE DB Objects and Interfaces" l="43" />
  <i t="Supported Schema Rowsets" l="44" />
  <i t="Supported OLE DB Property Groups" l="45">
   <i t="Data Source Property Group" l="45#wp546089" />
   <i t="Data Source Information Property Group" l="45#wp596674" />
   <i t="Initialization Property Group" l="45#wp546437" />
   <i t="Rowset Property Group" l="45#wp591733" />
   <i t="Session Property Group" l="45#wp546857" />
  </i>
  <i t="OLE DB Interfaces Supported in ADO" l="46" />
  <i t="Mapping ADO Methods and Properties" l="47">
   <i t="ADO Command Object" l="47#wp533648" />
   <i t="Connection Object" l="47#wp534039" />
   <i t="Recordset Object" l="47#wp539865" />
  </i>
  <i t="Data Shaping" l="48" />
  <i t="Persisting Information" l="49" />
  <i t="Using Rowsets" l="50" />
  <i t="Mapping Data Types" l="51" />
  <i t="Specifying Application IDs" l="52">
   <i t="Specifying Application IDs Explicitly" l="52#wp555470" />
   <i t="Generating Application IDs Automatically" l="52#wp553810" />
  </i>
  <i t="Error Handling" l="53">
   <i t="SequeLink&#174; for ADO Provider Errors" l="53#wp627299" />
   <i t="SequeLink&#174; Client Errors" l="53#wp627306" />
   <i t="SequeLink&#174; Server Errors" l="53#wp627317" />
   <i t="Database Errors" l="53#wp627336" />
  </i>
 </i>
 <i t="Part 3: Developing JDBC Applications" l="54" />
 <i t="5  Using the JDBC Client" l="55">
  <i t="About the JDBC Client" l="56">
   <i t="JDBC Driver" l="56#wp1041142" />
   <i t="SequeLink&#174; Proxy Server" l="56#wp1041151" />
   <i t="DataDirect Spy&#8482;" l="56#wp1041228" />
   <i t="DataDirect Test&#8482;" l="56#wp1041243" />
   <i t="DataDirect Connection Pool Manager" l="56#wp1041254" />
   <i t="J2EE Connector Architecture (JCA) Resource Adapter" l="56#wp1041262" />
   <i t="JDBC Client Directory Structure" l="56#wp1041276" />
  </i>
  <i t="Registering the JDBC Driver" l="57" />
  <i t="Specifying JDBC Driver Connection URLs" l="58" />
  <i t="Configuring JDBC Data Sources" l="59">
   <i t="Creating and Managing JDBC Data Sources" l="59#wp1041567" />
   <i t="Calling a Data Source in an Application" l="59#wp1074773" />
   <i t="Using JNDI for Naming Databases" l="59#wp1041592" />
   <i t="Using Connection Pooling" l="59#wp1041608" />
  </i>
  <i t="Using the Java Transaction API" l="60" />
  <i t="J2EE Connector Architecture Resource Adapter" l="61">
   <i t="Using the Resource Adapter with an Application Server" l="61#wp1041729" />
   <i t="Using the Resource Adapter from an Application" l="61#wp1041732" />
  </i>
  <i t="Specifying Connection Properties" l="62" />
  <i t="JDBC Connection Properties" l="63" />
  <i t="Configuring Connection Failover" l="64" />
  <i t="Using Client Load Balancing" l="65" />
  <i t="Using Connection Retry" l="66" />
  <i t="Testing JDBC Connections" l="67" />
  <i t="Using the JDBC Client on a Java 2 Platform" l="68" />
 </i>
 <i t="6  Using DataDirect Test&#8482;" l="69">
  <i t="DataDirect Test&#8482; Tutorial" l="70">
   <i t="Configuring DataDirect Test&#8482;" l="70#wp116017" />
   <i t="Starting DataDirect Test&#8482;" l="70#wp116528" />
   <i t="Connecting Using DataDirect Test&#8482;" l="70#wp75413" />
   <i t="Executing a Simple Select Statement" l="70#wp75445" />
   <i t="Executing a Prepared Statement" l="70#wp75461" />
   <i t="Retrieving Database Metadata" l="70#wp75495" />
   <i t="Scrolling Through a Result Set" l="70#wp75518" />
   <i t="Batch Execution on a Prepared Statement" l="70#wp110635" />
   <i t="Returning ParameterMetaData" l="70#wp120482" />
   <i t="Establishing Savepoints" l="70#wp120495" />
   <i t="Updatable Result Sets" l="70#wp121083" />
   <i t="LOB Support" l="70#wp121252" />
  </i>
 </i>
 <i t="7  Tracking JDBC Calls" l="71">
  <i t="About DataDirect Spy&#8482;" l="72" />
  <i t="Enabling DataDirect Spy&#8482;" l="73">
   <i t="Using the JDBC Driver Manager" l="73#wp75501" />
   <i t="Using JDBC Data Sources" l="73#wp75531" />
   <i t="Using the DataDirect Spy&#8482; URL" l="73#wp75568" />
  </i>
  <i t="Registering the DataDirect Spy&#8482; JDBC Driver" l="74">
   <i t="DataDirect Spy&#8482; Attributes" l="74#wp68496" />
  </i>
  <i t="Using DataDirect Spy&#8482; with JDBC Data Sources" l="75" />
  <i t="Checking the DataDirect Spy&#8482; Version" l="76" />
 </i>
 <i t="8  Developing JDBC Applications" l="77">
  <i t="JDBC 3.0 Support" l="78" />
  <i t="JCA Resource Adapter Class" l="79" />
  <i t="SQL Support" l="80">
   <i t="Binding SQL Statements" l="80#wp549369" />
  </i>
  <i t="Data Types and Isolation Levels" l="81" />
  <i t="Threading" l="82">
   <i t="Threading Architecture" l="82#wp528345" />
   <i t="Cancelling Functions in Multithreaded Applications" l="82#wp528126" />
  </i>
  <i t="Using Scrollable Cursors" l="83">
   <i t="Result Set Types" l="83#wp526079" />
   <i t="Concurrency Types" l="83#wp526088" />
   <i t="Using Scrollable Cursors" l="83#wp526096" />
  </i>
  <i t="Specifying Application IDs" l="84" />
  <i t="Parameter Metadata Support" l="85">
   <i t="INSERT and UPDATE Statements" l="85#wp555412" />
   <i t="Select Statements" l="85#wp555326" />
  </i>
  <i t="ResultSet Metadata Support" l="86" />
  <i t="Unicode Support" l="87" />
  <i t="Rowset Support" l="88" />
  <i t="Error Handling" l="89">
   <i t="Driver Errors" l="89#wp551035" />
   <i t="SequeLink&#174; Server Errors" l="89#wp551045" />
   <i t="Database Errors" l="89#wp551058" />
  </i>
  <i t="Fine-Tuning JDBC Application Performance" l="90">
   <i t="Reducing Download Time" l="90#wp524709" />
   <i t="Fetching BigDecimal Objects" l="90#wp524746" />
   <i t="Using Database Metadata Methods" l="90#wp529229" />
   <i t="Retrieving Data" l="90#wp529277" />
   <i t="Selecting JDBC Objects and Methods" l="90#wp529294" />
   <i t="Using get Methods Effectively" l="90#wp550145" />
   <i t="Designing JDBC Applications" l="90#wp529318" />
   <i t="Updating Data" l="90#wp529335" />
  </i>
 </i>
 <i t="Part 4: Developing .NET Applications" l="91" />
 <i t="9  Using the .NET Client" l="92">
  <i t="About the .NET Client" l="93" />
  <i t="Using Connection Pooling" l="94">
   <i t="Creating a Connection Pool" l="94#wp1171368" />
   <i t="Adding Connections to a Pool" l="94#wp1171395" />
   <i t="Removing Connections from a Pool" l="94#wp1171403" />
   <i t="Handling Dead Connection in a Pool" l="94#wp1171408" />
   <i t="Handling Distributed Transactions in a Pool" l="94#wp1171416" />
   <i t="Tracking Connection Pool Performance" l="94#wp1171425" />
  </i>
  <i t="Specifying Connection Options" l="95" />
  <i t="Using Connection Failover" l="96" />
  <i t="Client Load Balancing" l="97" />
  <i t="Using .NET Objects" l="98" />
  <i t="Assemblies" l="99" />
  <i t="Parameter Markers" l="100" />
  <i t="Parameter Arrays" l="101" />
  <i t="Stored Procedures" l="102" />
  <i t="Transaction Support" l="103">
   <i t="Using Local Transactions" l="103#wp1171722" />
   <i t="Using Distributed Transactions" l="103#wp1171728" />
  </i>
  <i t="Connecting to a Database" l="104" />
 </i>
 <i t="10  Developing .NET Applications" l="105">
  <i t="Namespace" l="106" />
  <i t="Data Types" l="107">
   <i t="Mapping Parameter Data Types" l="107#wp928141" />
  </i>
  <i t="Isolation Levels" l="108" />
  <i t="Threading" l="109" />
  <i t="Event Handling" l="110" />
  <i t=".NET Public Objects/Interfaces Supported" l="111">
   <i t="SequeLinkCommand Object" l="111#wp945956" />
   <i t="SequeLinkCommandBuilder Object" l="111#wp934442" />
   <i t="SequeLinkConnection Object" l="111#wp934470" />
   <i t="SequeLinkDataAdapter Object" l="111#wp943825" />
   <i t="SequeLinkDataReader Object" l="111#wp934567" />
   <i t="SequeLinkError Object" l="111#wp934575" />
   <i t="SequeLinkErrorCollection Object" l="111#wp934631" />
   <i t="SequeLinkException Object" l="111#wp934666" />
   <i t="SequeLinkInfoMessageEventArgs Object" l="111#wp934711" />
   <i t="SequeLinkParameter Object" l="111#wp943322" />
   <i t="SequeLinkTrace Object" l="111#wp961666" />
   <i t="SequeLinkTransaction Object" l="111#wp941707" />
  </i>
  <i t="Setting .NET Security Permissions" l="112">
   <i t="Code Access Permissions" l="112#wp938684" />
   <i t="Security Attributes" l="112#wp938687" />
  </i>
  <i t="Error Handling" l="113">
   <i t=".NET Errors" l="113#wp940583" />
   <i t="ADO.NET Data Provider Errors" l="113#wp954776" />
   <i t="SequeLink&#174; Server Errors" l="113#wp954791" />
   <i t="Database Errors" l="113#wp954814" />
  </i>
  <i t="Diagnostic Support" l="114">
   <i t="Tracing Method Calls" l="114#wp955876" />
   <i t="PerfMon Support" l="114#wp955923" />
  </i>
  <i t="Designing .NET Applications for Performance" l="115">
   <i t="Selecting .NET Objects and Methods" l="115#wp958592" />
   <i t="Designing .NET Applications" l="115#wp958689" />
   <i t="Retrieving Data" l="115#wp935457" />
   <i t="Updating Data" l="115#wp935354" />
  </i>
  <i t="For More Information" l="116" />
 </i>
 <i t="Part 5: Reference" l="117" />
 <i t="A  SQL Escape Sequences" l="118">
  <i t="Date, Time, and Timestamp Escape Sequences" l="119" />
  <i t="Scalar Functions" l="120">
   <i t="String Functions" l="120#wp25116" />
   <i t="Numeric Functions" l="120#wp17819" />
   <i t="Date and Time Functions" l="120#wp17964" />
   <i t="System Functions" l="120#wp18096" />
  </i>
  <i t="Like Predicate Escape Characters" l="121" />
  <i t="Outer Join Escape Sequences" l="122" />
  <i t="Procedure Call Escape Sequences" l="123" />
 </i>
 <i t="B  Data Types and Isolation Levels" l="124">
  <i t="Supported Data Types" l="125">
   <i t="DB2 UDB on z/OS" l="125#wp1084865" />
   <i t="DB2 UDB on Linux, UNIX, and Windows" l="125#wp939244" />
   <i t="Informix" l="125#wp958513" />
   <i t="Microsoft SQL Server" l="125#wp783999" />
   <i t="Oracle" l="125#wp784274" />
   <i t="Sybase" l="125#wp1046437" />
  </i>
  <i t="Isolation Levels" l="126">
   <i t="Using Snapshot Isolation Level (Microsoft SQL Server 2005 Only)" l="126#wp1062762" />
  </i>
 </i>
 <i t="C  JDBC Support" l="127">
  <i t="JDBC Compatibility" l="128" />
  <i t="Supported Functionality" l="129" />
 </i>
 <i t="D  JDBC Connection Pool Manager" l="130">
  <i t="Creating a Data Source" l="131">
   <i t="Creating a DataDirect SequeLink&#174; Data Source Object" l="131#wp73468" />
   <i t="Creating a Data Source Using the DataDirect&#174; Connection Pool Manager" l="131#wp73583" />
  </i>
  <i t="Connecting to a Data Source" l="132" />
  <i t="Closing the Connection Pool" l="133" />
 </i>
 <i t="E  Troubleshooting Using DataDirect Spy&#8482;" l="134">
  <i t="Generating a DataDirect Spy&#8482; Log" l="135">
   <i t="Turning On and Off DataDirect Spy&#8482; Logging" l="135#wp615519" />
   <i t="ExtLogControl Class" l="135#wp616206" />
   <i t="DataDirect Spy&#8482; Log Example" l="135#wp615908" />
  </i>
 </i>
 <i t="F  Developing ODBC Applications for Internationalization" l="136">
  <i t="Unicode and Non-Unicode ODBC Drivers" l="137">
   <i t="Function Calls" l="137#wp113127" />
   <i t="Data" l="137#wp113693" />
  </i>
  <i t="Developing ODBC Applications on Linux/UNIX" l="138">
   <i t="Using Double-Byte Character Sets on Linux/UNIX" l="138#wp113816" />
   <i t="Using UTF-16 for your Applications on Linux/UNIX" l="138#wp113840" />
  </i>
  <i t="The Driver Manager on Linux/UNIX" l="139" />
  <i t="Values for IANAAppCodePage Connection String Attribute" l="140">
   <i t="Solaris" l="140#wp114723" />
   <i t="HP" l="140#wp114855" />
   <i t="AIX" l="140#wp114945" />
   <i t="Linux" l="140#wp115107" />
   <i t="Windows" l="140#wp115263" />
  </i>
 </i>
 <i t="G  .NET Code Examples" l="141">
  <i t="Sample Tables Used in the Code Examples" l="142">
   <i t="Sample Tables for Oracle" l="142#wp74410" />
   <i t="Sample Tables for Sybase" l="142#wp71080" />
  </i>
  <i t="Retrieving Data Using a DataReader" l="143" />
  <i t="Using a Local Transaction With a DataReader" l="144" />
  <i t="Using a Distributed Transaction" l="145" />
  <i t="Using the CommandBuilder" l="146" />
  <i t="Retrieving a Result Set Using a DataAdapter Object" l="147" />
  <i t="Limiting the Rows Returned by a Select Statement" l="148" />
  <i t="Updating Data in a DataSet" l="149" />
  <i t="Calling a Stored Procedure" l="150" />
  <i t="Retrieving Warning Information" l="151" />
  <i t="Retrieving a Scalar Value" l="152" />
 </i>
</WebWorksHelpTOC>
