How to handle a sql query (behind a portlet) that returns more than 200 rows?

Add the server.conf parameter com.kintana.core.server.PORTLET_MAX_ROWS_RETURNED
Add the following parameter to your server.conf:com.kintana.core.server.PORTLET_MAX_ROWS_RETURNED=
Run the kUpdateHtml.sh in the /bin directory
Restart the ITG Application
Once this parameter is in place, portlets will return rows up to the limit specified.
Note: This will change the limit for all portlets, so there may be a performance impact if this limit is set particularly high (approximately greater than 500.) An increase in the timeout limit of certain existing portlets may also be required, since their queries may take more time to complete as they are returning a higher number of rows.In 5.5, all the rows for a query are returned.
Another Note: In 6.0 the portlet_max_rows_returned is required to be changed so that it would return the desired number of rows.
http://kb-web.mercury.com/top5/kblinkExtern.asp?Conceptid=31525;Product=kintana
http://kb-web.mercury.com/top5/kblinkExtern.asp?Conceptid=42044;Product=kintana