Focal Point
[CLOSED] Issue with Reading HOLD File

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

November 21, 2017, 01:52 PM
AMC
[CLOSED] Issue with Reading HOLD File
I am having an issue with reading my HOLD file below. I have it defined as ALPHA and I get the following:

(FOC224) SYNTAX ERROR: &F_PERCTOT.D12.2.&M_PERCTOT.D12.2.&F_AUMPERC.D12.2.&M_AUMPERC.D12.2.&F_T12PERC.D12.2.&M_T12PERC.D12.2.
-------------------vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
-READFILE HOLDCNTS &F_PERCTOT.D12.2.&M_PERCTOT.D12.2.&F_AUMPERC.D12.2.&M_AUMPERC.D12.2.&F_T12PERC.D12.2.&M_T12PERC.D12.2.


The code is here below. Any ideas, please let me know.


TABLE FILE HOLDCNT
SUM F_PERCTOT
    M_PERCTOT
    F_AUMPERC
    M_AUMPERC
    F_T12PERC
	M_T12PERC
ON TABLE HOLD AS HOLDCNTS FORMAT ALPHA
END

-*?FF HOLDCNTS
-*-EXIT

-READFILE HOLDCNTS &F_PERCTOT.D12.2.&M_PERCTOT.D12.2.&F_AUMPERC.D12.2.&M_AUMPERC.D12.2.&F_T12PERC.D12.2.&M_T12PERC.D12.2.
-*-TYPE &F_PERCTOT
-*-TYPE &M_PERCTOT
-*-TYPE &F_AUMPERC
-*-TYPE &M_AUMPERC
-*-TYPE &F_T12PERC
-*-TYPE &M_T12PERC
-EXIT

 

This message has been edited. Last edited by: FP Mod Chuck,


WF 8.1.05
Windows
SQL Server 2014
HTML, PDF, EXCEL
November 21, 2017, 01:54 PM
AMC
Please let me know.


WF 8.1.05
Windows
SQL Server 2014
HTML, PDF, EXCEL
November 21, 2017, 01:56 PM
Francis Mariani
Check the manual - when you use -READFILE, you do not specify any variable names. -READFILE uses the metadata (.mas) to determine the HOLD file columns and the subsequent variables.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server