Focal Point
[SOLVED] query from held file

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

June 08, 2010, 09:02 AM
Mark1
[SOLVED] query from held file
I run this to create my hold file:

APP HOLD HELDFILES
APP HOLDMETA HELDFILES
APP HOLDDATA HELDFILES
-RUN
FILEDEF MYFILE DISK \\HURSTPOINT\C$\IBI\APPS\HELDFILES\MYFILE.FTM
TABLE FILE PEOPLESOFT
PRINT *
ON TABLE HOLD AS MYFILE FORMAT ALPHA
END
-EXIT

Then I look out on Windows Explorer and I see the FTM file and the Master file in the directory. However, when I try to query it, WF says it cannot find the file. I try like this:

SET ASNAMES = ON
SET ALL=ON
-RUN
FILEDEF MYFILE DISK \\HURSTPOINT\C$\IBI\APPS\HELDFILES\MYFILE.FTM
-RUN
TABLE FILE MYFILE
PRINT *
END

Any thoughts? I'm about ready to chuck my PC out the window.

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


Windows version 768
June 08, 2010, 09:33 AM
njsden
Try:
APP MAP HELDFILES \\HURSTPOINT\C$\IBI\APPS\HELDFILES
APP HOLD HELDFILES
-RUN
FILEDEF MYFILE DISK HELDFILES/MYFILE.FTM
TABLE FILE PEOPLESOFT
PRINT *
ON TABLE HOLD AS MYFILE FORMAT ALPHA
END
-EXIT


If you want to use it later:
APP MAP HELDFILES \\HURSTPOINT\C$\IBI\APPS\HELDFILES
APP APPENDPATH HELDFILES
-RUN
FILEDEF MYFILE DISK HELDFILES/MYFILE.FTM
-RUN
TABLE FILE MYFILE
PRINT *
END


If the second section runs in the same "context" or session then you won't need to issue APP MAP twice.



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.
June 08, 2010, 09:50 AM
Mark1
That worked! Thank you so much!


Windows version 768
June 08, 2010, 11:50 AM
njsden
You're welcome. I'm glad it helped! Smiler



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.
June 09, 2010, 05:15 PM
GinnyJakes
You don't need the FILEDEF in the first TABLE request. The APP HOLD takes care of where to put both the .mas and the .ftm files.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google