Table of Contents Table of Contents Title and Copyright Information Preface Audience Documentation Accessibility Diversity and Inclusion Related Resources Conventions 1 Understand the IBM DB2 Adapter IBM DB2 Adapter Capabilities Supported Data Types for SQL Stored Procedures IBM DB2 Adapter Restrictions What Application Version Is Supported? About IBM DB2 Adapter Use Cases Workflow to Create and Add an IBM DB2 Adapter Connection to an Integration 2 Create an IBM DB2 Adapter Connection Prerequisites for Creating a Connection Create a Connection Configure Connection Properties Configure Connection Security Configure an Agent Group Test the Connection 3 Add the IBM DB2 Adapter Connection to an Integration Basic Information Page Trigger Polling Page Polling Page Manage Tables Page Table Relationships Page Attributes Filtering Page Polling Strategy and Options Page Invoke Stored Procedure Operation Page Invoke SQL Statement Page Table Operation Page Import Tables Page Relationships Page Create Relationship Page Attribute Filtering Page Operations on Table Page Summary Page 4 Implement Common Patterns Using the IBM DB2 Adapter Define a Select Operation on Database Tables