About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
New SQL 99 support is coming in a release of DVM in 1H 2021. We will continue to add more capability in this area QtQ and if any customer has the interest to provide early validation prior to delivery into the product, please contact me directly to enroll in our continuous early program.
IBM recognizes the value of an updated ANSI SQL base to better service newer SQL function. IBM will be working to identify specific SQL scenarios and work to support those, as opposed to a complete ANSI SQL compliance for the latest release. Customers can leverage Db2 for z/OS to leverage ANSI SQL 2016 compliance by leveraging DVM for z/OS ability to create UDTFs/Views in a Db2 for z/OS database server to establish mappings to z/OS sources.
This approach would redirect applications through Db2 for z/OS to access DVM for z/OS generated UDTF/Views that would then traverse through DVM for z/OS to access data. Inbound client applications would be able to parse more currency with SQL through the Db2 for z/OS parser and send along execution strings to DVM for z/OS for access to underlying z/OS data sources.
Alternatively, IBM is targeting specific high use case SQL statement requirements and addressing these individually, as we work to consider a more complete leveling of currency to ANSI SQL 2016.