Using SQL in Productions Introduction to SQL Adapters Using an SQL Business Service Specifying the Data Source Name Specifying Inbound Queries SQL Procedure Settings About Messages Using an SQL Business Operation Specifying the Data Source Name Specifying a Query Specifying Other Runtime Settings SQL Procedure Settings About Response Messages More About Messages Incoming Streams Incoming Strings More About Procedures Custom Business Services Overall Behavior Creating a Business Service to Use the Adapter Implementing the OnProcessInput() Method Using the Default Snapshot Object Initializing the Adapter Adding and Configuring the Business Service Processing Only New Rows Reprocessing Rows Examples That Use Query Settings Specifying Other Runtime Settings Resetting Rows Previously Processed by the Inbound Adapter Custom Business Operations Default Behavior Creating a Business Operation to Use the Adapter Creating Methods to Perform SQL Operations Handling Multiple SQL Statements per Message Adding and Configuring the Business Operation Creating Adapter Methods for SQL Overview and Context Using Parameters Executing Queries Performing Updates, Inserts, and Deletes Executing Stored Procedures Specifying Statement Attributes Managing Transactions Managing the Database Connection Using Result Sets Creating and Initializing a Result Set Getting Basic Information about the Result Set Navigating the Result Set Examining the Current Row of the Result Set Using Snapshots Creating a Snapshot Getting Basic Information about the Snapshot Navigating the Snapshot Examining the Current Row of the Snapshot Resetting a Snapshot
