Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 3 Tools : $RPTOCCLIMIT

$RPTOCCLIMIT
Limits the number of occurrences used to generate the report. (C)
Invocation
CALL $RPTOCCLIMIT(reportname, occlimit)
 
The name of the report to be printed. Its syntax is C (fixed-length character string) with length 16.
Usage Notes
Only the specified number of occurrences are used and the output for the report is based on this limited number of occurrences.
Example
The following rule uses a limited number of occurrences and sends the results to the message log:

RULE EDITOR ===> SCROLL: P
RPTOCCLIMIT_1;
_
_ ---------------------------------------------------------------------------
_ ------------------------------------------------------------+--------------
_ CALL $RPTOCCLIMIT('EMPLOYEE_RPT', 4); | 1
_ FORALL EMPLOYEE WHERE DEPTNO >= 30 : | 2
_ EMPL_RPT.* = EMPLOYEE.*; |
_ INSERT EMPL_RPT('EMPLOYEE_RPT'); |
_ END; |
_ CALL $RPTPRINT('EMPLOYEE_RPT', 'SCR'); | 3
_ ---------------------------------------------------------------------------

 
Resulting Output
Pressing PF2 after executing this rule displays the following screen:

 
------------------------- INFORMATIONAL MESSAGE LOG -----------------
COMMAND ===> SCROLL ===> P
====NEW PAGE FOR REPORT "EMPLOYEE_RPT"================================
Employees by Department Page 1
LNAME EMPNO DEPTNO
---------------------- ------- ------
GARZA 80004 30
PASTARINA 80019 50
ROTERDAM 80002
TOWNSEND 80014 70

 

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved