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.
TABLE FILE DDT001
SUM
COMPUTE AMT/P17.2BC =
IF (EDIT(DDROW,'999$') NE 'FTE') THEN BALNIE / 1000 ELSE BALNIE;
BY SUMDIV
BY SUMDIV_NAME
ACROSS YRMTH
BY ROWPREFIX
BY ROWPREFIX3
BY DDROW
FOR DDROW
NIE01A LABEL NIE01A OVER
NIE01B LABEL NIE01B OVER
RECAP NIE01HIGH/P17.2BC = NIE01A + NIE01B; LABEL NIE01HIGH
WHERE DDROW NE 'N/A';
WHERE (YRMTH GE '201011' AND YRMTH LE '201102');
ON TABLE HOLD AS H001
END
This code has no error:
TABLE FILE DDT001
SUM
COMPUTE AMT/P17.2BC =
IF (EDIT(DDROW,'999$') NE 'FTE') THEN BALNIE / 1000 ELSE BALNIE;
BY SUMDIV
BY SUMDIV_NAME
ACROSS YRMTH
BY ROWPREFIX
BY ROWPREFIX3
BY DDROW
FOR DDROW
NIE01A LABEL NIE01A OVER
NIE01B LABEL NIE01B
WHERE DDROW NE 'N/A';
WHERE (YRMTH GE '201011' AND YRMTH LE '201102');
ON TABLE HOLD AS H001
END
It seems to have something to do with label names or row values that are different in size, i.e. NIE01A and NIE01B are the same length, but NIE01HIGH is longer.
Any ideas?
Thanks,This message has been edited. Last edited by: Francis Mariani, April 11, 2011 02:44 PM
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
SET ASNAMES=ON
SET HOLDLIST=PRINTONLY
SET HOLDFORMAT=ALPHA
TABLE FILE CAR
SUM SALES
BY SEATS
FOR COUNTRY
JAPAN LABEL JAPAN OVER
ENGLAND LABEL ENGLAND OVER
RECAP JPEN/I5 = JAPAN + ENGLAND; OVER
ITALY
ON TABLE HOLD AS H001
END
-RUN
?FF H001
-RUN
TABLE FILE H001
PRINT
SALES
BY SEATS
BY E02
END
-RUN
As shown in this example, I have an intermediary HOLD file and, when created using FML, you have to be careful.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
It's strange behaviour. It's a combination of RECAP with format AND with the COMPUTE statement - even though the formats are the same. If I remove the COMPUTE, it works. I'll move the COMPUTE out of this piece of code.
I will open a case for this.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
did you open a case for this? If I open another case I'll scream. I have code that works fine in 7.6.1 but not in 7.7.03 I have a define field that has the same format and never changes but I'm getting that error.
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005