Monthly Archives: June 2015

Limit records return on a synonym

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 :

END

DBA=DBA, $

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”