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 firstname.lastname@example.org for further assistance. Reference the community FAQ to learn more about the community.
I am working on the SQL code of a Web-focus DEFINE based procedure. --------------------------------------------------------------------- ENGINE INT CACHE SET ON
-*COMPONENT=Define_TABLE1 DEFINE FILE TABLE1 Define_1/D3=2; END -DEFAULTH &WF_SUMMARY='Summary'; -DEFAULTH &WF_TITLE='WebFOCUS Report'; TABLE FILE TABLE1 PRINT CLIENT_CD Define_1 ON TABLE PCHOLD FORMAT HTML ON TABLE NOTOTAL ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET SQUEEZE ON ON TABLE SET EMPTYREPORT ON ON TABLE SET HTMLCSS ON ON TABLE SET HTMLENCODE ON ON TABLE SET CACHELINES 100 ON TABLE SET TRACEOFF ALL0 ON TABLE SET TRACEON SQLCALL ON TABLE SET TRACEON SQLTRANS ON TABLE SET TRACEON 'SQLAGGR//CLIENT' ON TABLE SET TRACEON 'STMTRACE//CLIENT' ON TABLE SET TRACESTAMP OFF ON TABLE SET TRACEWRAP 78 ON TABLE SET TRACEUSER ON ON TABLE SET STYLE * INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$ TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $ ENDSTYLE END ------------------------------ Its returning me the SQL code -
< !-- FOC2590 - AGGREGATION NOT DONE FOR THE FOLLOWING REASON: FOC2594 - AGGREGATION IS NOT APPLICABLE TO THE VERB USED SELECT T1."CLIENT_CD" FROM EDW.TABLE1 T1; 0 NUMBER OF RECORDS IN TABLE= 10 LINES= 10 0 HOLDING HTML FILE ON PC DISK ... -->
But it should select the DEFINE field also in the SQL SELECT section. and its not including the DEFINE based filter also.
can any one help me on my both point that how can I generate the SQL code with DEFINE field.This message has been edited. Last edited by: <Kathryn Henning>,
WebFOCUS 8105, Dev Studio 8105, Windows 7, ALL Outputs
As your procedure only has PRINT VERB, there is no request passed to RDBMS to do aggregation. Change to SUM and try. Moreever, its just a message, not an errors. Reports ran successfully in my past expereince, though i got this at the source.
However, as you mentioned specifically in IA, will these errors stopped to execute the reports?
WebFOCUS 7.7.x and 8.x
Posts: 406 | Location: India | Registered: June 13, 2013