Supported DB2 Versions

11.x

Encoding Support

Automatically detects the encoding for MySQL by default, and also supports manual setting. Manual settings only support Java-style encoding names from the list below.

Connection Preview Support

Supports regular tables and views that can be listed by the SHOW TABLES command.

SQL Query Dataset Support for SQL

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

DB2 Authentication Method Support

Supports username and password methods. Does not support SSL and other authentication methods.

Unsupported Field Types

The following types of columns in DB2 tables cannot be processed correctly. If you need other fields from this table, you can input a SELECT statement in the SQL query, excluding this field.

• GRAPHIC
• VARGRAPHIC
• LONG VARGRAPHIC
• CURSOR
• XML
• ARRAY
• Anchored types
• User-Defined types