change Max no of Rows shows for a particular query

[former_member217468]

hi all, My HANA studio has a limit set of 1000 for the max no of results displayed for a sql query, and wanted to check if it was possible to view all the records for a particular query without changing this value in studio, ie if i want just one particular query to show me all the records .

Thank you

Jonu Joy

[sreelatha_reddy2]

Hi Jonu,

You can increase the limit from 1000 to a bigger number.

Window -->Preferences--> SAP HANA -->Runtime -->Result --> Maximum number of rows displayed in Result

[lbreddemann]

That wasn't the question.

Jonu asked for a per query setting and that's not an available function.

[Former Member]

Use "LIMIT n" as in

select COMP_CODE, CURRENCY from "SAPBWX"."/BI0/PCOMP_CODE"

where OBJVERS = 'A'

LIMIT 10

(I tried and it works - but it needs to tested on more complex sql statements)

This may help  if the query in question has less records than the maximum setting, not the other way around.

[former_member313946]

HI,

SAP Hana Studio -> Preferences -> SAP HANA -> Modeler -> Data Preview ( No Limit )

[lbreddemann]

Nope, there's no such possibility.