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] FOCCACHE location

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] FOCCACHE location
 Login/Join
 
Prince Joseph
Silver Member
posted
Is there any way to get the actual path to the foccache folder which is created when a procedure is running? I understand that it is located in edatemp and I can reference anything from it by using 'FOCCACHE/FILENAME' but I have to run a dos command to execute a batch file which is in FOCCACHE and so I need the full path. Any help is appreciated.

Thanks,
Prince

This message has been edited. Last edited by: Prince Joseph,


Webfocus 8, All Outputs

 
Posts: 47 | Location: Atlanta, GA | Registered: June 09, 2011Report This Post
Waz
Expert
posted Hide Post
Here is a technique that should get the location.

TABLE FILE CAR
PRINT COUNTRY
ON TABLE HOLD AS FOCCACHE/FC_CTRY
END

SQLFMI SET SYSFILES MASTER

TABLE FILE SYSFILES
PRINT *
WHERE FILENAME EQ 'fc_ctry'
END


SYSFILES will give the location of the file type, in this case MASTER file. Other types are supported.

If you know that a file exists in FOCCACHE, then this should work.

I have seen a limit with the number of characters stored in the location though. So if its a long path and or loing name, there may be issues.


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
Prince Joseph
Silver Member
posted Hide Post
That works great. Thanks!


Webfocus 8, All Outputs

 
Posts: 47 | Location: Atlanta, GA | Registered: June 09, 2011Report This Post
Twanette
Platinum Member
posted Hide Post
Darn, this technique no longer works in WF 8.0.01 gen 705.
I have logged a HOTTRACK case. Perhaps 8.0 has a more direct solution.


WebFOCUS 8.2.06 mostly Windows Server
 
Posts: 195 | Location: Johannesburg, South Africa | Registered: September 13, 2008Report This Post
Waz
Expert
posted Hide Post
Is it still defined the same way in 8 ?

7.7 doco says:

foccache_dir = operating system specific pathname
Internal default: /edatemp
It defines the location of Foccache.


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
Alex
Platinum Member
posted Hide Post
[...]ibi\srv80\wfs\edatemp\foccache


WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF
 
Posts: 175 | Location: Pomona, NY | Registered: August 06, 2003Report This Post
Twanette
Platinum Member
posted Hide Post
In 7.7 we used SYSFILES to get the full path name to the sub-directory of FOCCACHE for that session.
In 8.0.01 PHNAME just contains e.g. foccache/fc_ctry.mas


WebFOCUS 8.2.06 mostly Windows Server
 
Posts: 195 | Location: Johannesburg, South Africa | Registered: September 13, 2008Report This Post
Waz
Expert
posted Hide Post
Twanette, let us know if IBI has a solution.

You are in the box seat with an installation of WF8.


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
Twanette
Platinum Member
posted Hide Post
Hi everyone,
Just an update.
What I have been able to determine is that the change in behaviour in fact has to do with SYSFILES, and is not necessarily restricted to FOCCACHE.
In 8.0.01 and 8.0.02 the PHNAME field of SYSFILES contains the appname/filename, and not the Physical File name as it did previously.
I will keep you posted ;-)


WebFOCUS 8.2.06 mostly Windows Server
 
Posts: 195 | Location: Johannesburg, South Africa | Registered: September 13, 2008Report This Post
Waz
Expert
posted Hide Post
Hoping there is a SET command to revert it back.


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
David Briars
Master
posted Hide Post
Twanette-

As you indicate, in WF 8, PHNAME contains app/filename, as 
APP PREPENDPATH IBISAMP
TABLE FILE GGSALES
PRINT *
ON TABLE HOLD AS FOCCACHE/HLDSALES
END
-RUN
TABLE FILE SYSFILES
PRINT FILENAME
      PHNAME
IF FILENAME EQ hldsales
END
Yields:
PAGE 1 
 
FILENAME PHNAME 
hldsales foccache/hldsales.mas

Did you ever determine if there is a way to obtain the full path name in WF 8, like there was in WF 7?

-Dave

This message has been edited. Last edited by: David Briars,
 
Posts: 822 | Registered: April 23, 2003Report This Post
David Briars
Master
posted Hide Post
APP PREPENDPATH IBISAMP
TABLE FILE GGSALES
PRINT *
ON TABLE HOLD AS FOCCACHE/HLDSALES
END
-RUN
WHENCE HLDSALES MASTER
? PATH  
-EXIT

WHENCE and ? PATH seem to provide the full path name for FOCCACHE, but how to get the results into an amper variable, rather than a display?
 
Posts: 822 | Registered: April 23, 2003Report This Post
Tom Flynn
Expert
posted Hide Post
Search on TEMPDIR


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
dhagen
Virtuoso
posted Hide Post
Until the problem gets fixed, this will work:

-DEFAULTH &APPLOC = ' '
-* put a file in the foccache
TABLE FILE CAR PRINT *
ON TABLE HOLD AS FOCCACHE/TOUT FORMAT ALPHA
END
-RUN
 
TABLEF FILE _EDAHOME/CATALOG/SYSAPPS 
-* apploc is the fully qualified directory name
PRINT APPLOC
WHERE FNAME EQ 'tout';
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SET ASNAMES ON
ON TABLE HOLD AS TDIRNAME
END
-RUN
-READFILE TDIRNAME
-TYPE Dir is &APPLOC


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Report This Post
David Briars
Master
posted Hide Post
Thanks dhagen!

Indeed _EDAHOME/CATALOG/SYSAPPS.APPLOC contains the full path name for the FOCCACHE file in question in WF 8.0.06.
 
Posts: 822 | Registered: April 23, 2003Report 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] FOCCACHE location

Copyright © 1996-2020 Information Builders