Data retrieval enhancements
The Db2® 11.5.8 release contains enhancements that improve data retrieval.
Attention: This mod pack release is currently available for
the following Db2 products:
- Db2 on-premises
- The single container deployments of Db2 Warehouse and IBM Integrated Analytics System (IIAS).
- The container micro-service deployment of Db2 on Red Hat OpenShift, the Amazon Elastic Kubernetes Service (EKS), the Red Hat OpenShift Service on AWS (ROSA), and the Azure Kubernetes Service (AKS).
- Db2 for cloud service providers
- Db2 on Cloud
- Db2 Warehouse on Cloud
The following table lists data retrieval enhancements that have been added to Db2
11.5.8:
| Enhancement | Description |
|---|---|
| Enhanced registry variable for making the Multi-row Fetch (MRF) feature behave as it does in Db2 for z/OS. | The DB2_CURSOR_MRF_ZOS registry variable can now make Db2 behave like Db2 for z/OS when the multi-row fetch (MRF) feature is used. When set to FALSE, the registry variable behaves as it was designed in previous versions: The final fetch returns 0 rows and a sqlcode of 100. When set to TRUE, it now behaves like Db2 for z/OS when running a multi-row fetch; The final fetch returns a sqlcode of 100 and the number of rows fetched. The exception to this result is when there is an edge case, where the number of rows is equal to the array size. |