HEX and binary literal support in JDBC SQL queries

In IMS 15, IMS Universal JDBC Drivers support the usage of HEX and binary literals in the SQL syntax. This enhancement is delivered with APAR PH25586/ UI 71410 for IMS15 and PH 25585/ UI71424 for IMS14.

IMS Universal JDBC drivers support the usage of HEX and binary literals in the SQL syntax. The supported SQL statements for literals include SELECT, INSERT, UPDATE, DELETE, and fields within the WHERE clause. This enhancement would enable an application developer to specify a standard way to specify the HEX or binary literals values in an SQL (INSERT, UPDATE, DELETE or SELECT) call. This enhancement is delivered with APAR PH25586/ UI 71410 for IMS15 and PH 25585/ UI71424 for IMS14.

Requirements

To enable the use of HEX or binary literals in JDBC SQL queries, UserTypeConverters must be updated to support setBytes() and getBytes().

Documentation changes

The following table lists the publications that contain new or changed topics for the HEX and binary literal support in JDBC SQL queries. Publications that are not impacted by this enhancement are not included in the table.

Table 1. Links to topics that have new or changed content for this enhancement
Publication	New or changed topics
Release planning	General planning information for IMS 15 IMS 15 enhancements IMS 15 system continuous delivery functions HEX and binary literal support in JDBC SQL queries (new) (this topic)
Application programming	HEX and binary literals usage