DRDA/DB2 Compatibility Matrix

DRDA/DB2 Compatibility Matrix

Comprehensive compatibility reference for HeliosDB’s IBM DB2 DRDA protocol implementation.

Overall Compatibility: 95%

Category	Coverage	Result
DRDA Protocol	95%	Level 5
SQL Language	95%	DB2 syntax
Data Types	100%	All DB2 types
Stored Procedures	85%	SQL procedures

DRDA Protocol Support

Protocol Levels

Level	Coverage	Features
Level 3	100%	Basic operations
Level 4	100%	Extended features
Level 5	90%	Advanced features

DRDA Commands

Command	Result	Notes
ACCRDB	Supported	Access database
ACCRDBRM	Supported	Access reply
EXCSAT	Supported	Exchange attributes
EXCSATRD	Supported	Exchange reply
SECCHK	Supported	Security check
SECCHKRM	Supported	Security reply
PRPSQLSTT	Supported	Prepare statement
EXCSQLSTT	Supported	Execute statement
OPNQRY	Supported	Open query
CNTQRY	Supported	Continue query
CLSQRY	Supported	Close query
SQLSTT	Supported	SQL statement

SQL Language Support

Data Definition (DDL)

Statement	Result	Notes
CREATE TABLE	Supported	All options
CREATE INDEX	Supported
CREATE VIEW	Supported
CREATE SEQUENCE	Supported
CREATE PROCEDURE	Supported	SQL procedures
CREATE FUNCTION	Supported	SQL functions
CREATE TRIGGER	Supported
ALTER TABLE	Supported
DROP *	Supported	All objects
TRUNCATE	Supported
COMMENT	Supported

Data Manipulation (DML)

Statement	Result	Notes
SELECT	Supported	Full DB2 syntax
INSERT	Supported
UPDATE	Supported
DELETE	Supported
MERGE	Supported
TRUNCATE	Supported

DB2-Specific Syntax

Feature	Result	Notes
FETCH FIRST N ROWS	Supported
WITH UR/CS/RS/RR	Supported	Isolation levels
OFFSET… FETCH	Supported	Pagination
FOR UPDATE	Supported	Row locking
OPTIMIZE FOR N ROWS	Supported	Query hints
WITH HOLD	Supported	Cursor hold

Common Table Expressions (CTEs)

Feature	Result	Notes
Basic CTE	Supported	WITH clause
Recursive CTE	Supported	WITH RECURSIVE
Multiple CTEs	Supported
CTE in INSERT	Supported
CTE in UPDATE	Supported
CTE in DELETE	Supported

Data Types

Numeric Types

Type	Result	Notes
SMALLINT	Supported	2-byte integer
INTEGER	Supported	4-byte integer
BIGINT	Supported	8-byte integer
DECIMAL	Supported	Fixed precision
NUMERIC	Supported	Same as DECIMAL
REAL	Supported	4-byte float
DOUBLE	Supported	8-byte float
DECFLOAT	Supported	Decimal float

String Types

Type	Result	Notes
CHAR	Supported	Fixed length
VARCHAR	Supported	Variable length
CLOB	Supported	Character LOB
GRAPHIC	Supported	Double-byte
VARGRAPHIC	Supported	Variable double-byte
DBCLOB	Supported	Double-byte CLOB

Binary Types

Type	Result	Notes
BLOB	Supported	Binary LOB
BINARY	Supported	Fixed binary
VARBINARY	Supported	Variable binary

Date/Time Types

Type	Result	Notes
DATE	Supported	Calendar date
TIME	Supported	Time of day
TIMESTAMP	Supported	Date and time

Special Types

Type	Result	Notes
XML	Partial	Basic support
ROW	Supported	Composite type
BOOLEAN	Supported	DB2 11.1+

Functions

String Functions

Function	Result	Notes
SUBSTR	Supported	Substring
LENGTH	Supported	String length
CONCAT	Supported	Concatenation
UPPER	Supported	Uppercase
LOWER	Supported	Lowercase
TRIM	Supported	Trim whitespace
LTRIM	Supported	Left trim
RTRIM	Supported	Right trim
LEFT	Supported	Left substring
RIGHT	Supported	Right substring
LOCATE	Supported	Find position
REPLACE	Supported	Replace string
COALESCE	Supported	First non-null
NULLIF	Supported	Null if equal

Numeric Functions

Function	Result	Notes
ABS	Supported	Absolute value
CEIL/CEILING	Supported	Round up
FLOOR	Supported	Round down
ROUND	Supported	Round
TRUNCATE	Supported	Truncate
MOD	Supported	Modulo
POWER	Supported	Power
SQRT	Supported	Square root
SIGN	Supported	Sign
RAND	Supported	Random

Date/Time Functions

Function	Result	Notes
CURRENT DATE	Supported	Current date
CURRENT TIME	Supported	Current time
CURRENT TIMESTAMP	Supported	Current timestamp
DATE	Supported	Extract date
TIME	Supported	Extract time
TIMESTAMP	Supported	Create timestamp
YEAR	Supported	Extract year
MONTH	Supported	Extract month
DAY	Supported	Extract day
HOUR	Supported	Extract hour
MINUTE	Supported	Extract minute
SECOND	Supported	Extract second
DAYS	Supported	Days between
TIMESTAMPDIFF	Supported	Time difference

Aggregate Functions

Function	Result	Notes
COUNT	Supported
SUM	Supported
AVG	Supported
MIN	Supported
MAX	Supported
STDDEV	Supported
VARIANCE	Supported
LISTAGG	Supported	String aggregation

OLAP Functions

Function	Result	Notes
ROW_NUMBER	Supported
RANK	Supported
DENSE_RANK	Supported
NTILE	Supported
LAG	Supported
LEAD	Supported
FIRST_VALUE	Supported
LAST_VALUE	Supported
SUM OVER	Supported	Running sum
AVG OVER	Supported	Running average

Stored Procedures

Feature	Result	Notes
SQL Procedures	Supported
IN Parameters	Supported
OUT Parameters	Supported
INOUT Parameters	Supported
Result Sets	Supported
CALL Statement	Supported
Dynamic SQL	Supported
Exception Handling	Supported

Triggers

Feature	Result	Notes
BEFORE Triggers	Supported
AFTER Triggers	Supported
INSTEAD OF Triggers	Supported
Row Triggers	Supported
Statement Triggers	Supported
Transition Tables	Supported

Transaction Control

Statement	Result	Notes
COMMIT	Supported
ROLLBACK	Supported
SAVEPOINT	Supported
RELEASE SAVEPOINT	Supported
SET TRANSACTION	Supported

Driver Compatibility

JDBC

Driver	Version	Result
IBM DB2 Driver	11.5+	Full
JDBC Type 4	4.x	Full

ODBC

Driver	Version	Result
IBM DB2 ODBC	11.x	Full

Python

Driver	Version	Result
ibm_db	3.x	Full
ibm_db_sa (SQLAlchemy)	0.3+	Full

###.NET

Driver	Version	Result
IBM.Data.DB2	11.x	Full
IBM.Data.DB2.Core	3.x	Full

Known Limitations

Not Supported

Feature	Reason
External Procedures	Use SQL procedures
DB2 Connect	Direct connection only
Federation	Use HeliosDB federation
MQT	Use materialized views

Behavioral Differences

1. Catalog: Uses HeliosDB catalog structure
2. Bufferpool: Different memory management
3. Tablespaces: Abstracted by HeliosDB
4. Logging: Uses HeliosDB WAL

---

Related: README.md | CONFIGURATION.md | EXAMPLES.md