Using SQL Adapters with Ensemble
Contents
 
   
Server:docs2
Instance:LATEST
User:UnknownUser
 
-
Go to:
Search:    

 
Contents

Preface : 
 
 
Chapter 1: 
 
  • 1.1 Basic Tools
  • 1.2 Helper Classes
  • 1.3 General Use
  • Chapter 2: 
     
  • 2.1 Overall Behavior
  • 2.2 Creating a Business Service to Use the Adapter
  • 2.3 Implementing the OnProcessInput() Method
  • 2.4 Using the Default Snapshot Object
  • 2.5 Initializing the Adapter
  • 2.5.1 Initializing Persistent Values
  • 2.5.2 Examples
  • 2.6 Adding and Configuring the Business Service
  • 2.7 Specifying the Data Source Name
  • 2.8 Specifying Inbound Queries
  • 2.8.1 Specifying the Query
  • 2.8.2 Specifying Parameters
  • 2.9 Processing Only New Rows
  • 2.9.1 Available Tools
  • 2.9.2 Practical Ways to Not Reprocess Rows
  • 2.10 Reprocessing Rows
  • 2.11 Examples That Use Query Settings
  • 2.11.1 Example 1: Using KeyFieldName
  • 2.11.2 Example 2: Using &%LastKey or %LastKey
  • 2.11.3 Example 3: Using DeleteQuery
  • 2.11.4 Example 4: Working with a Composite Key
  • 2.11.5 Example 5: No KeyFieldName
  • 2.12 Specifying Other Runtime Settings
  • 2.13 Resetting Rows Previously Processed by the Inbound Adapter
  • Chapter 3: 
     
  • 3.1 Default Behavior
  • 3.2 Creating a Business Operation to Use the Adapter
  • 3.3 Creating Methods to Perform SQL Operations
  • 3.4 Handling Multiple SQL Statements per Message
  • 3.5 Adding and Configuring the Business Operation
  • 3.5.1 Specifying the Data Source Name
  • 3.5.2 Specifying Other Runtime Settings
  • Chapter 4: 
     
  • 4.1 Overview and Context
  • 4.2 Using Parameters
  • 4.2.1 Parameter Attributes
  • 4.2.2 Specifying Parameters in a Caché Multidimensional Array
  • 4.3 Executing Queries
  • 4.3.1 Use Modes
  • 4.3.2 Syntax for the Methods
  • 4.3.3 Example
  • 4.4 Performing Updates, Inserts, and Deletes
  • 4.4.1 Example
  • 4.4.2 Example with ExecuteUpdateParmArray
  • 4.5 Executing Stored Procedures
  • 4.5.1 Example
  • 4.6 Specifying Statement Attributes
  • 4.7 Managing Transactions
  • 4.8 Managing the Database Connection
  • 4.8.1 Properties
  • 4.8.2 Methods
  • Chapter 5: 
     
  • 5.1 Creating and Initializing a Result Set
  • 5.2 Getting Basic Information about the Result Set
  • 5.3 Navigating the Result Set
  • 5.4 Examining the Current Row of the Result Set
  • Chapter 6: 
     
  • 6.1 Creating a Snapshot
  • 6.1.1 Creating a Snapshot from a Live Connection
  • 6.1.2 Creating a Snapshot from Static Data
  • 6.1.3 Creating a Snapshot Manually
  • 6.2 Getting Basic Information about the Snapshot
  • 6.3 Navigating the Snapshot
  • 6.4 Examining the Current Row of the Snapshot
  • 6.5 Resetting a Snapshot