Supported Data Types

This section lists the supported data types for the RDBMS Event Generator for the Trigger Event Scheme and the Intrusive Event Query Scheme. The non-supported data types are also listed.

Supported Data Types - Trigger Event Scheme

Table A-1 summarizes the supported data types for the RDBMS Event Generator (Trigger Event Scheme).

Table A-1 Supported Data Types (Trigger Event Scheme)
Oracle	Microsoft SQL Server	DB2 UDB	Informix Dynamic Server	Sybase Adaptive Server
`BLOB` `CHAR` `CLOB` `DATE` `DECIMAL` `FLOAT` `INTEGER` `NUMBER` `NUMERIC` `RAW` `REAL` `SMALLINT` `VARCHAR2` `NCLOB` `NVARCHAR2` `NCHAR`	`BIGINT` `BIT` `CHAT` `DATETIME` `DECIMAL` `FLOAT` `INT` `MONEY` `NCHAR` `NUMERIC` `NVARCHAR` `REAL` `SMALLDATETIME` `SMALLINT` `SMALLMONEY` `TINYINT` `VARCHAR`	`BIGINT` `BLOB` `CHARACTER` `CLOB` `DATE` `DECIMAL` `DOUBLE` `INTEGER` `LONGVARCHAR` `REAL` `SMALLINT` `TIME` `TIMESTAMP` `VARCHAR`	`BLOB` `BOOLEAN` `BYTE` `CHAR` `CLOB` `DATE` `DATETIME` `DECIMAL` `FLOAT` `INT` `INT8` `INTEGER` `MONEY` `NCHAR` `NVARCHAR` `SMALLFLOAT` `SMALLINT` `TEXT` `VARCHAR`	`BINARY` `BIT` `CHAR` `DATETIME` `DECIMAL` `DOUBLE` `FLOAT` `INTEGER` `NCHAR` `NUMERIC` `NVARCHAR` `REAL` `SMALLDATETIME` `SMALLINT` `TINYINT` `VARBINARY` `VARCHAR` `MONEY` `SMALLMONEY`

Supported Data Types - Intrusive Query Event Scheme

In addition to the data types supported by the Trigger Event scheme listed above, the Intrusive Query Event scheme supports the data types listed in Table A-2.

Table A-2 Supported Data Types (Intrusive Query Event Scheme)
Oracle	Microsoft SQL Server	DB2 UDB	Informix Dynamic Server	Sybase Adaptive Server
`LONG`	`BINARY` `TIMESTAMP` `UNIQUEIDENTIFIER` `VARBINARY`

Non-Supported Data Types for RDBMS

Table A-3 summarizes the non-supported data types for the RDBMS Event Generator (Trigger Event Scheme).

Table A-3 Non-Supported Data Types (Trigger Event Scheme)
Oracle	Microsoft SQL Server	DB2 UDB	Informix Dynamic Server	Sybase Adaptive Server
`REFCURSOR` `LONGRAW` `INTERVAL DAY (day_precision) TO SECOND` `INTERVAL YEAR (year_precision) TO MONTH` `TIMESTAMP` `ROWID` `UROWID` `BFILE`	`NTEXT` `IMAGE` `TEXT` `TIMESTAMP` `UNIQUEIDENTIFIER` `VARBINARY` `BINARY` `SQL_VARIANT`		`SERIAL` `SERIAL8` `INTERVAL` `LVARCHAR`	`TEXT` `IMAGE` `TIME` `TIMESTAMP` `DATE` `SYSNAME` `UNICHAR` `UNIVARCHAR`

RDBMS Event Generator User Guide

Supported Data Types