<!-- START doctoc generated TOC please keep comment here to allow auto update -->
<!-- DON'T EDIT THIS SECTION, INSTEAD RE-RUN doctoc TO UPDATE -->
**Table of Contents**  *generated with [DocToc](https://github.com/thlorenz/doctoc)*

- [Supported DB2 Versions](#supported-db2-versions)
- [Encoding Support](#encoding-support)
- [Connection Preview Support](#connection-preview-support)
- [Support for SQL in SQL Query Data Sets](#support-for-sql-in-sql-query-data-sets)
- [Supported DB2 Authentication Methods](#supported-db2-authentication-methods)
- [Unsupported Field Types](#unsupported-field-types)

<!-- END doctoc generated TOC please keep comment here to allow auto update -->


### Supported DB2 Versions

11.x

### Encoding Support

Automatically detects MySQL encoding by default, but also supports manual setting. Manual settings only support encoding names in the Java style listed below.

### Connection Preview Support

Supports regular tables and views, including tables listed by the `show tables` command.

### Support for SQL in SQL Query Data Sets

Only supports the SELECT statement, supports all SELECT-related features supported by the connected DB2. Users need to ensure that the syntax complies with DB2 standards.

### Supported DB2 Authentication Methods

Supports username and password methods, does not support authentication methods like SSL.

### Unsupported Field Types

The following column types from DB2 tables cannot be correctly processed. If you need other fields from this table, you can enter the SELECT statement in the SQL query, excluding that specific field:
- GRAPHIC
- VARGRAPHIC
- LONG VARGRAPHIC
- CURSOR
- XML
- ARRAY
- Anchored types
- User-Defined types