Row Count

If the gateway or DBMS has support for limiting the number of rows returned in a single result set, the IDS_AUX_SETROWCOUNT string contains the SQL statement sent to the gateway with the count appended. If the IDS_AUX_SETROWCOUNT string is empty, the SQLSetStmtOption SQL_MAX_ROWS option returns SQL_ERROR with a SQL State of S1C00. If there is a non-infinite default that limits the number of rows returned, be sure to include the proper initialization string to set an infinite row count in the gateway. For more information, see Gateway Initialization.