Sets the row threshold for rejecting queries based on estimated size of result set.
Any integer
0
DBA permissions are not required to set this option. Can be set temporary, for an individual connection, or for the PUBLIC group. Takes effect immediately.
If Sybase IQ receives a query that has an estimated number of result rows greater than the value of QUERY_ROWS_RETURNED_LIMIT, it rejects the query with this message:
Query rejected because it exceeds resource: Query_Rows_Returned_Limit
If you set this option to zero (the default), there is no limit and no queries are ever rejected based on the number of rows in their output.
