The DB2 UDB Options for CICS and IMS support these features:
Translation between DB2 and Sybase datatypes and error codes.
DB2 catalog queries.
31-digit decimals; the DB2 UDB Options for CICS and IMS support the DB2 extension to its decimal datatype, DECIMAL(31,31).
LONG VARCHARs (literal strings greater than 254 bytes) can be embedded in an insert or update language statement.
Only the DB2 UDB Option for CICS supports these features:
Cursors
Access to relational and nonrelational data
Some features are described in the following subsections.
(For CICS only) The DB2 UDB Option for CICS supports user-defined, long-running transactions. Because transactions can remain active after all results are sent, multiple requests can participate in the same unit of work. Therefore, you have more control over individual or group commit or rollback operations on mainframe databases.
The Server Options for CICS and IMS provide character sets that you can customize if you want to change languages. You can create up to 99 new character sets by modifying the shipped base tables.
The DB2 UDB Options for CICS and IMS support these access features:
Updates and inquiries against DB2 data using DB2 dynamic SQL
Dynamic access to DB2 data
Only the DB2 UDB Option for CICS supports cursor and
dynamic events.
Client applications can process user datatypes that return descriptive information about DB2 columns.
The DB2 UDB Options for CICS and IMS provide request, result, and parse exit routines.
