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,

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.

That works great. Thanks!

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.

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.

[...]ibi\srv80\wfs\edatemp\foccache

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

Twanette, let us know if IBI has a solution.

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

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 ;-)

Hoping there is a SET command to revert it back.

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,

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?

Search on TEMPDIR

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  

Thanks dhagen!

Indeed _EDAHOME/CATALOG/SYSAPPS.APPLOC contains the full path name for the FOCCACHE file in question in WF 8.0.06.