For the rare case that you need to restrict the number of records returned in a synonym, here’s the syntax to add to the synonym in the text editor :
USER=, ACCESS=R, RESTRICT=VALUE, NAME=SYSTEM, VALUE=READLIMIT EQ 100;, $
I’ve highlighted the ‘100’ to show you where you set the limit.
For more information on this, check out the following WebFOCUS documentation. Search for “Providing Data Source Security: DBA”