Setting this attribute limits the number of rows returned to the application. This can be used to avoid an application from being overwhelmed with a very large result set generated inadvertently, especially for applications on clients with limited memory resources.
Note: | The full result set is still generated at the server, DB2 CLI will only fetch up to SQL_ATTR_MAX_ROWS rows. |