 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. New TIBCO Community Coming Soon What You Need to Know about Our New Community During the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage. | |||||
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED]how to set limits on the number of records retrieve? Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED]how to set limits on the number of records retrieve? | Login/Join |
| Platinum Member |
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 ndid 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 | ||
|
| Virtuoso |
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 | |||
|
| Virtuoso |
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 | |||
|
| Platinum Member |
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 | |||
|
| Gold member |
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 | |||
|
| Platinum Member |
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 | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only Topic Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED]how to set limits on the number of records retrieve? | View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |