HANA ODBC doesn't return max rows

[former_member67937]

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

[lbreddemann]

That's not ODBC related at all. ngdbc.jar is the JDBC driver (Java).

[former_member67937]

Yes, thank you, I meant to say JDBC.

[former_member185280 · Accepted solution]

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 · Accepted solution]

Thank you, that was the answer!