Report Definition's generated query is not having row count even though “Maximum number of rows to retrieve” is set to a small num
We have a report definition with the setting “Maximum number of rows to retrieve” as 1000. The pxResults count is 1000 and we have 1000 results in memory/clipboard. But, the generated query monitored by DBAs doesn’t have the row limit count (they are expecting something like ‘fetch first 1000 rows only’ at the end of SQL query).
Environment: PRPC 7.1.8, App server: WAS, Databse: DB2
We have traced multiple Report Definitions, captured generated query in tracer, DBAs captured the queries at database end. Both the quires are same and do not have ‘fetch first 100 rows only’ at the end of query.
Can you please share your comments/experience, Does JDBC connection take care of stopping the query execution after receiving first 1000 records? If yes, what happens to the query execution at database side?
***Edited by Moderator Marissa to update Platform Capability tags****
Pegasystems Inc.
US
I don't believe the "Maximum number of rows to retrieve" setting affects the query. It just limits the number of rows that are staged on the clipboard.
On the other hand, I believe the setting at the bottom of the Query tab may actually change the query:
Updated: 14 Jun 2021 7:38 EDT
Pegasystems Inc.
IN
Please find the below article which might be helpful.
https://collaborate.pega.com/question/max-records-query-report-definition