How to change SAP Hana Sql Output results are limited to 5000 Records

How to change SAP Hana Sql Output results are limited to 5000 Records

These are quick fixes that are often overlooked because the products come with standard configurations.


The SAP Hana SQL Output results in ECLIPSE, for example, have a limit of 5000 records.


With the following setup, you can change this number to a higher one.

Windows Tab - > Preference -> General - > Runtime - > Result -> Maximum number of rows displayed in results. 

2147483647 is usually the maximum record that can be achieved.

No comments: