You can set the maximum number of rows in the resulting group of a query by using the ODBC SET OPTION command. You pass the ODBC MAX ROWS constant and the max number of rows desired as parameters. Below is a sample code that shows how to limit the max rows to 100:
SQLStmt:="SELECT * FROM Employee"
ODBC SET OPTION(ODBC Max Rows ;100)
ODBC LOAD RECORD(ODBC All Records )