Category Archives: Uncategorized

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”

So what happened to my previous postings?

For those who have visited my blog before, you’ll notice that I don’t have any posts before November 2013. Well, that’s because my old hosting service decommissioned the server without letting me know.

Always the eternal optimist, I see this as an opportunity to reboot my blog. I’m going to revisit a few concepts including some data visualization techniques and WebFOCUS specific examples.

I hope to have something new up later this week.