Can someone point me in the right direction please I would like to save a HOLD file that can be called from seperate fex files.

Im trying to create an html page and it would be nice if I could run the SQL once and save the data in a global hold file rather than running it for every fex in my html wrapper code.

Thanks.

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

You can do an APP HOLD to save it in a permanent directory. You will have to APP FI or FILEDEF it in the programs in which you want to use it or have a permanent master with a DATASET parameter in it with the directory either in the APP PATH of the program or in the global profile.

I have uppercased some keywords that you can use in a search vehicle.

I suggest looking into "FOCCACHE"

WebFOCUS/iWay New Features > Server Enhancements > Core Server and Client Features > Foccache: Persistent Directory for Caching Files

LEnderby's on 7.6.4, I think FOCCAHE only came in in 7.6.5

Following on from Ginny's suggestion if you create the hold file as FORMAT FOCUS then
there will be no need to add any filedefs to your code providing it is in the APP PATH.

Thanks for the replies, I'll have a look. I'm actually on 769 we upgraded last week.