Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]how to set limits on the number of records retrieve?
Go
New
Search
Notify
Tools
Reply
  
[SOLVED]how to set limits on the number of records retrieve?
 Login/Join
 
Platinum Member
posted
Hi,

My objective is to limit number of records that user can retrieve from DB in report. Reason for doing this is to avoid user try to retrieve huge amount of record from DB without set any filter.

I read about this following page:
https://infocenter.information...ce%2FRECORDLIMIT.htm

and by using
 WHERE READLIMIT EQ n  
did the trick, but some user may not want to coding in their .fex. Therefore, is there a way to set limitation and force only certain amount of records can be retrieve? or better if to have this limitation setting apply for certain user as well?

*User mention is the one on WebFOCUS user.

This message has been edited. Last edited by: nox,


WebFOCUS v8.2.06 , Windows
 
Posts: 117 | Registered: August 29, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
If I remember well DBA security setting in master file will allow you that


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2388 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Virtuoso
posted Hide Post
See: Describing Data With WebFOCUS Language Manual
Chapter on Data Source Security


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1975 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
I read up about DBA, but what I understand in DBA section can set limitation base on a field or column value to print the result, but what I looking for is more like set only MAX of 1,000 records can be retrieve without base on any column. Or is it there a way can be done in DBA section? if yes, then please provide some coding or where I should look into?


WebFOCUS v8.2.06 , Windows
 
Posts: 117 | Registered: August 29, 2019Reply With QuoteReport This Post
Gold member
posted Hide Post
this is the poor man's Resource Governor solution:

DBA=STEVE, $
USER=TOM,ACCESS=R, $
USER=SWIFT,ACCESS=R,RESTRICT=VALUE,NAME=SYSTEM,VALUE=RECORDLIMIT EQ 10, $

SET USER=TOM will print everything; SET USER=SWIFT will only print the first ten records.

-* NOTE!! - READLIMIT and RECORDLIMIT work differently depending on whether you are using RELATIONAL or FOCUS files.


WebFOCUS 8
Windows, All Outputs
 
Posts: 66 | Registered: May 29, 2015Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Hi sh98110,

your solution may be poor man's resource governor, but it get the job done, thank you all for your support.


WebFOCUS v8.2.06 , Windows
 
Posts: 117 | Registered: August 29, 2019Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]how to set limits on the number of records retrieve?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.