It is quite rare requirement but you can face it none the less and can act as good information.
To restrict the number of records fetched by BC should return when we execute a query against that BC.
To set the Maximum Cursor Size property of that BC to the number of records we want to retrieve for example if we want a BC to return only 100 records then we will set the Maximum Cursor Size property of that BC to 100.
There is a parameter called MaxCursorSize available in CFG file which is set to -1 by default.
-1 here means fetch records while End of file (EOF) is not reached. If you set the property to a positive number it is going to affect the whole application not a particular BC.
If you want to restrict just a particular BC then set the Maximum Cursor Size property of that BC.
Important thing to note here is Maximum Cursor Size at BC level will override MaxCursorSize parameter specified in CFG file.