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     [CLOSED] cannot create two hold tables in same fex file

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] cannot create two hold tables in same fex file
 Login/Join
 
Chan1980
Member
posted
I need to create a two hold tables in same fex file,whatever i am using at first is giving result,the second table is not at all giving any result.anyone please advise how can we create a two hold tables in same .fex file.

This message has been edited. Last edited by: Kerry,


Webfocus 7.1,Z/OS,Webpage
 
Posts: 8 | Registered: December 23, 2010Report This Post
MichaelBalle
Gold member
posted Hide Post
Send your code please


WebFOCUS 7.6, 7.7
Windows, All Output formats
 
Posts: 90 | Location: Stuttgart | Registered: October 20, 2010Report This Post
Prarie
Virtuoso
posted Hide Post
Does the second one run by itself? Are you calling each hold file something different or trying to append the data?
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Waz
Expert
posted Hide Post
Definitely post your code, as we have nothing to go on to help you.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
T.Peters
Platinum Member
posted Hide Post
Are we talking something like:
TABLE FILE CAR
PRINT CAR
ON TABLE HOLD AS CARHOLD1

TABLE FILE CAR
PRINT CAR
ON TABLE HOLD AS CARHOLD2


Or more along the lines of

 
TABLE FILE CAR
PRINT MODEL
BY LOWEST CAR
ON TABLE HOLD AS CARHOLD2

TABLE FILE CAR
PRINT CAR
ON TABL HOLD AS CARHOLD1


WebFOCUS: 7702
O/S : Windows
Data Migrator: 7702
 
Posts: 127 | Location: San Antonio | Registered: May 29, 2009Report This Post
Waz
Expert
posted Hide Post
We will have to wait as see.



Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Chan1980
Member
posted Hide Post
table file filename1 (refering .mas file)
PRINT
COMPUTE cinfo/a100 = '
 
Posts: 8 | Registered: December 23, 2010Report This Post
T.Peters
Platinum Member
posted Hide Post
I don't claim to be a FOCUS expert, so can you explain what you're trying to accomplish with your COMPUTE?


WebFOCUS: 7702
O/S : Windows
Data Migrator: 7702
 
Posts: 127 | Location: San Antonio | Registered: May 29, 2009Report This Post
Arif
Guru
posted Hide Post
quote:
I don't claim to be a FOCUS expert,

Usually you will use hold table as temptable to extract data into your final report.

What are you trying to do? If you just want output of two computes, why do you need hold table?


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Report This Post
Francis Mariani
Expert
posted Hide Post
You shouldn't have any problems creating two HOLD files in one fex, unless there are syntax errors or no data is retrieved...


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Tom Flynn
Expert
posted Hide Post
quote:

in html i am calling like below,

!ibi.fil.holdaa
!ibi.fil.holdvv

That is incorrect, code s/b:

!IBI.FIL.HOLDAA;
!IBI.FIL.HOLDVV;


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Francis Mariani
Expert
posted Hide Post
Working example:

SET ASNAMES=ON
SET HOLDLIST=PRINTONLY
SET HOLDFORMAT=ALPHA
-RUN

TABLE FILE CAR
SUM 
COMPUTE AA/A20 = COUNTRY | '<br />';
BY COUNTRY NOPRINT
ON TABLE HOLD AS HAA
END
-RUN

TABLE FILE CAR
SUM
COMPUTE BB/A50 = COUNTRY | MODEL | '<br />';
BY COUNTRY NOPRINT
BY MODEL NOPRINT
ON TABLE HOLD AS HBB
END
-RUN

-HTMLFORM BEGIN

!IBI.FIL.HAA;
<br />
!IBI.FIL.HBB;

-HTMLFORM END

Music


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
jgelona
Master
posted Hide Post
Chan1980. First your fex is missing END statements after the ON TABLE HOLD statements.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 975 | Location: Oklahoma City | Registered: October 27, 2006Report This Post
Vinay Kumar
Platinum Member
posted Hide Post
chan1980, i don't seem any problem in creating 2 hold's for a single master file.
Could you please share the error which you are getting.


WebFOCUS 7.6.4, Mainframe Focus
Windows XP, All Output Formats
 
Posts: 135 | Registered: November 30, 2010Report 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     [CLOSED] cannot create two hold tables in same fex file

Copyright © 1996-2020 Information Builders