cancel
Showing results for 
Search instead for 
Did you mean: 

HANA ODBC doesn't return max rows

former_member67937
Participant
460

We're using ngdbc.jar which came from the HANA Client install, and we can connect to HANA and run queries just fine. However, even if the query template's max rows is set for 1,000,000, the maximum rows returned is always 120,000. What is causing MII to limit the rows returned? I can run the same query in Excel with the same driver, and I can return the full rows.

Thanks,

Todd

View Entire Topic
former_member185280
Active Contributor
0 Kudos

Under 'System Properties' there is a global 'Max Row Count' property that you probably need to change.

https://help.sap.com/viewer/d70c3ac3566b41dd896cd7cecc94e14a/15.2.0/en-US/4c983e3a311160c4e10000000a...

Regards,
Christian

former_member67937
Participant
0 Kudos

Thank you, that was the answer!