Focal Point
[CLOSED] Reusing SAVE files

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6707047016

October 06, 2011, 12:47 PM
Jan1
[CLOSED] Reusing SAVE files
Hi,

I have a couple of variables to be read from SAVE files. I want to reuse the variables instead of running the 7-8 SAVE files everytime that i have in a fex .

for example ,

  

Table file A 
print 
lst_5_weeks
on table save as sav_week
end

-READ sav_week &WK1.A10. &WK2.A10. &WK3.A10. &WK4.A10. &WK5.A10.



i have several files like this .

When we use hold files , i can use APP HOLD hold dir and i can reuse those FOCUS files .

How can we achieve the same way using SAVE ?
i want the Save files to be saved in the application directory , and the i can read it everytime from the fex ..

Thanks!

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


WebFOCUS 7.6.9
Windows
Excel, HTML, PDF
October 06, 2011, 01:38 PM
njsden
You could either:

FILEDEF MYFILE DISK /mypath/myfile.ftm
-RUN
TABLE FILE CAR
PRINT COUNTRY AND CAR
ON TABLE SAVE AS MYFILE
END


or

APP HOLDDATA mypath
-RUN
TABLE FILE CAR
PRINT COUNTRY AND CAR
ON TABLE HOLD AS MYFILE FORMAT ALPHA
END




Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
October 06, 2011, 01:57 PM
Jan1
HI,

i tried the below method

  

APP HOLDDATA test
-RUN
TABLE FILE test1
PRINT week_Dt
ON TABLE HOLD AS MYFILE FORMAT ALPHA
END


from another fex , 

app path test

-read MYFILE week_Dt.a10



This did not work . although myfile.ftm file got saved in the 'others' subfolder under app folder.


WebFOCUS 7.6.9
Windows
Excel, HTML, PDF
October 06, 2011, 02:06 PM
njsden
APP PATH determines where to find procedures (.fex) and synonyms (.mas/.acx).

For data files you still need to let FOCUS know where to find them.

FILEDEF MYFILE DISK test/myfile.ftm
-RUN
-READ MYFILE &week_Dt.A10.




Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
October 07, 2011, 10:25 PM
ABT
Why is this not as simple as writing the code once, saving it in the Applications folder, and -MRNOEDIT -INCLUDE ing it? Sorry, am I over simplifying it?

- ABT


------------------------------------
WF Environment:
------------------------------------
Server/Client, ReportCaster, Dev Studio: 7.6.11
Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist
OS: Windows Server 2003
Application/Web Server: Tomcat 5.5.25
Java: JDK 1.6.0_03
Authentication: LDAP, MRREALM Driver
Output: PDF, EXL2K, HTM

------------------------------------
Databases:
------------------------------------
Oracle 10g
DB2 (AS/400)
MSSQL Server 2005
Access/FoxPro