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