Troubleshooting
Problem
How to control the number of rows returned on a SQL query using the Data Virtualization Manager ODBC driver?
Symptom
How to control the number of rows returned from a single query when using the DVM ODBC driver?
Resolving The Problem
Use the Maximum Rows (keyword MR) option on the 'advanced' setting of the DVMODBC driver and set it to the number of rows that need to be returned from a single query.
Note: If no value or zero is specified, no restriction is placed on the number of rows returned.
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS4NKG","label":"IBM Data Virtualization Manager for z\/OS"},"Component":"","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
11 May 2021
UID
ibm16256822