IMS JDBC Map Case enhancement

The JDBC Map Case enhancement provides an optional removeInvalidCaseFields connection property to return only valid map case columns and fields in a SQL result set.

If you use a SQL SELECT * statement and a WHERE clause with the IMS Universal JDBC driver to retrieve map case fields from a segment, the returned results include all fields by default. You can simplify your results by using the removeInvalidCaseFields property to remove case fields from the result set that do not satisfy the DEPENDINGON field condition in the WHERE clause. To learn more, see Using the removeInvalidCaseFields property.

Documentation changes

The following table lists the publications that contain new or changed topics for the JDBC Map Case enhancement.

Table 1. Links to topics that have new or changed content for this enhancement
Publication	New or changed topics
Release planning	IMS 15 system continuous delivery functions IMS JDBC Map Case enhancement (new) (this topic)
Application programming	Connecting using the IMS Universal Database resource adapter in a managed environment Connecting using the IMS Universal JCA/JDBC driver in a managed environment Connecting to an IMS database using the JDBC DataSource interface Connecting to an IMS database by using the JDBC DriverManager interface Using the removeInvalidCaseFields property