Focal Point Banner


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.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Using Match Files in PDF Painter

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Using Match Files in PDF Painter
 Login/Join
 
Platinum Member
posted
I am having a problem getting a perfectly good report to run inside the pdf painter. Here is the result when I run the fex "standalone"

MATCH FILE VIEW_4
PRINT *
BY PS_ID NOPRINT
BY PS_ID NOPRINT
-REPEAT MTCHLOOP FOR Q FROM 3 TO 3;
-SET &S=3-1;
RUN
FILE VIEW_3
SUM *
BY PS_ID NOPRINT
BY Industry NOPRINT
-REPEAT MTCHLOOP FOR Q FROM 3 TO 3;
-MTCHLOOP;
AFTER MATCH HOLD OLD-OR-NEW
END
-RUN
0 NUMBER OF RECORDS SELECTED= 178 LINES= 178
0 NUMBER OF RECORDS SELECTED= 34 LINES= 34
0 LINES OF MATCH OUTPUT = 178
TABLE FILE HOLD
PRINT *
ON TABLE HOLD AS DETAILS FORMAT FOCUS
END
-RUN
0 NUMBER OF RECORDS IN TABLE= 178 LINES= 178
-GOTO GOTMATCH;
-GOTMATCH
TABLE FILE DETAILS
PRINT *
END
-RUN
0 NUMBER OF RECORDS IN TABLE= 178 LINES= 178

WebFOCUS Version 7.6.1 compiled and linked on Fri Apr 20 13:32:38 EDT 2007 (Gen branch761_hotfix:7)
-->

Here is what I get when I -INCLUDE that same fex into the pdf painter:

MATCH FILE VIEW_4
PRINT *
BY PS_ID NOPRINT
BY PS_ID NOPRINT
-REPEAT MTCHLOOP FOR Q FROM 3 TO 3;
-SET &S=3-1;
RUN
FILE VIEW_3
SUM *
BY PS_ID NOPRINT
BY Industry NOPRINT
-REPEAT MTCHLOOP FOR Q FROM 3 TO 3;
-MTCHLOOP;
AFTER MATCH HOLD OLD-OR-NEW
END
-RUN
0 NUMBER OF RECORDS SELECTED= 178 LINES= 178
0 NUMBER OF RECORDS SELECTED= 34 LINES= 34
0 LINES OF MATCH OUTPUT = 178
TABLE FILE HOLD
PRINT *
ON TABLE HOLD AS DETAILS FORMAT FOCUS
END
-RUN
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: HOLD
BYPASSING TO END OF COMMAND
-GOTO GOTMATCH;
-GOTMATCH
TABLE FILE DETAILS
PRINT *
END
-RUN
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: DETAILS
BYPASSING TO END OF COMMAND
COMPOUND END

WebFOCUS Version 7.6.1 compiled and linked on Fri Apr 20 13:32:38 EDT 2007 (Gen branch761_hotfix:7)
-->

I tried a cut and paste to put the code directly into the pdf painter, same result.

The really bad part is that I have not been able to recreate the problem using the EMPLOYEE and EMPDAT files.

Any Ideas?


Robert F. Bowley Jr.
Owner
TaRa Solutions, LLC

In WebFOCUS since 2001
 
Posts: 132 | Location: Gadsden, Al | Registered: July 22, 2005Report This Post
Master
posted Hide Post
quote:
-REPEAT MTCHLOOP FOR Q FROM 3 TO 3;
-SET &S=3-1;
RUN
FILE VIEW_3
SUM *
BY PS_ID NOPRINT
BY Industry NOPRINT
-REPEAT MTCHLOOP FOR Q FROM 3 TO 3;
-MTCHLOOP;


I'm not sure why this wouldn't work in PDF painter if it works outside of it. But why do you have the -REPEAT MTCHLOOP twice? Also, is it really from 3 to 3 which will run it once. And remove the ; from the tag
-MTCHLOOP


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
 
Posts: 755 | Location: TX | Registered: September 25, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Using Match Files in PDF Painter

Copyright © 1996-2020 Information Builders