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     [SOLVED] create hold file on disk with mfd

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] create hold file on disk with mfd
 Login/Join
 
Spence
Platinum Member
posted
I need to save the hold to disk and create the mfd
so that the file can be reported against with other
queries. This should be easy but I can't get this to work!!

FILEDEF CarHold DISK E:\APPS\TEMPFILES\CarHold.TXT;
APP HOLD TEMPFILES

TABLE FILE CAR
PRINT CAR
BY COUNTRY
ON TABLE HOLD AS CarHold FORMAT ALPHA
END

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


WF 8 version 8.2.04. Windows.
In focus since 1990.
 
Posts: 189 | Location: pgh pa | Registered: October 06, 2004Report This Post
Waz
Expert
posted Hide Post
When you say you can't get it to work, what doesn't work?

The APP HOLD TEMPFILES should force the master and the hold file to the TEMPFILES directory.


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
Spence
Platinum Member
posted Hide Post
the mfd is not being saved to disk.


WF 8 version 8.2.04. Windows.
In focus since 1990.
 
Posts: 189 | Location: pgh pa | Registered: October 06, 2004Report This Post
Waz
Expert
posted Hide Post
Does E:\APPS\TEMPFILES exist ?

Where is the fex running, is it on your PC or on a server?


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
Computix
Silver Member
posted Hide Post
quote:
Originally posted by Spence:
...
FILEDEF CarHold DISK E:\APPS\TEMPFILES\CarHold.TXT;
APP HOLD TEMPFILES

TABLE FILE CAR
PRINT CAR
BY COUNTRY
ON TABLE HOLD AS CarHold FORMAT ALPHA
END


Hi,
just to be sure, do you have -RUN after the FILEDEF and before the TABLE request?

kind regards,
Markus


WF 7.6.6 (MRE,BID, DevStudio, partly RC) on Windows 2003 /Apache/Tomcat
Output: HTML,Excel,PDF,PPT
Adapters: SQL Server, DB2, Oracle
 
Posts: 38 | Location: Austria, Linz | Registered: June 19, 2009Report This Post
<JG>
posted
You see the file because of the FILEDEF but not the master because TEMPFILES is not in your APP PATH.

The problem with using APP HOLD is it will also save any other work files to that location, not a good idea.

1. There should not be a ; at the end of the FILEDEF
2. When you do issue an APPHOLD the FILEDEF is not needed
3. For APPHOLD to work TEMPFILES must be part of your application path
(if not issue APP APPENDPATH TEMPFILES - probabley the reason you do not see the master)
4. A better way to do it would be

TABLE FILE CAR
PRINT CAR
BY COUNTRY
ON TABLE HOLD AS TEMPFILES/CarHold FORMAT FOCUS
END

Use FORMAT FOCUS and you do not need to issue a FILEDEF to use the file later.
(Assuming TEMPFILES is in your APP PATH
 
Report This Post
Spence
Platinum Member
posted Hide Post
tempfiles is in the app path.
i did remove the ; at the end of the filedef.
there is a -RUN after the filedef.
i do need the format as alpha and not a focus db.
the fex is running from a server.
CarHold.ftm is making it to TEMPFILES, not the MFD.
i ended up hardcoding a mfd for the CarHold.ftm - primitive but it's working.

thanks for everyones help.

FILEDEF CarHold DISK E:\Wesco\TEMPFILES\CarHold.ftm
APP HOLD TEMPFILES

-RUN

TABLE FILE CAR
PRINT CAR
BY COUNTRY
ON TABLE HOLD AS TEMPFILES FORMAT ALPHA
END


WF 8 version 8.2.04. Windows.
In focus since 1990.
 
Posts: 189 | Location: pgh pa | Registered: October 06, 2004Report This Post
jimbo
Silver Member
posted Hide Post
try this instead of app hold
 APP HOLDMETA myappPath


7.7.04
Win2K3, Unix
Oracle 10G,SQL2K,XFOCUS,ESRI,BID,MRE,SELF-SERVICCE
 
Posts: 36 | Location: Melville,NY | Registered: August 09, 2004Report This Post
Spence
Platinum Member
posted Hide Post
jimbo - still no mfd.


WF 8 version 8.2.04. Windows.
In focus since 1990.
 
Posts: 189 | Location: pgh pa | Registered: October 06, 2004Report This Post
Francis Mariani
Expert
posted Hide Post
Amazing this post is still active after almost two weeks - it's WebFOCUS 001.

Hard to believe this does not work:

APP HOLDMETA BASEAPP
-*APP HOLDDATA BASEAPP

TABLE FILE CAR
SUM SALES
BY COUNTRY
ON TABLE HOLD AS HCAR01 FORMAT ALPHA
END
(HOLDMETA for metadata, HOLDDATA for data)


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
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] create hold file on disk with mfd

Copyright © 1996-2020 Information Builders