Using SQL Adapters with Ensemble
Contents
[Home]  [Next]
InterSystems: The power behind what matters   
Class Reference   
Search:    

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