Focal Point
[Solved] 7.7.04 - Trying to map and now getting syntax error

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

October 23, 2012, 02:00 PM
Vivian
[Solved] 7.7.04 - Trying to map and now getting syntax error
I have the following code that used to work like clockwork in 7.6.xx

-SET &HLDFLE1 = 'Joined Tables from WebFOCUS';
-SET &HLDFLE2 = &HLDFLE1 || '.xls';
-SET &HLDFLE3 = 'JNDTBLS';
APP MAP DOWNLOAD '\\servername\folder\Reporting\Production\Catalog\Report Catalog\Linked Files\'
APP FI &HLDFLE3 DISK "DOWNLOAD/&HLDFLE2"

This is the error message:

APP FI JNDTBLS DISK "DOWNLOAD/Joined Tables from WebFOCUS.xls"
(FOC224) SYNTAX ERROR: "
----------------v


Now, we have just installed 7.7.04 on the server and I get the above syntax error on the double quotation marks --- Any clues or how to fix this?

Thanks
Vivian

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


Vivian Perlmutter
Aviter, Inc.


WebFOCUS Keysheet Rel. 8.0.2
(Almost) 1001 Ways to Work with Dates thru Rel. 8.0.2
Focus since 1982
WebFOCUS since the beginning
Vivian@aviter.com

October 23, 2012, 02:41 PM
Francis Mariani
Developing Reporting Applications > Managing Applications > Output Redirection Commands

"APP FI[LEDEF] - The APP FI[LEDEF] command has been deprecated and aliased to FILEDEF. For information, see the Stored Procedure Reference." - v7.7.03.

Also, I've never seen double quotes used in an APP command.


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
October 23, 2012, 03:09 PM
Vivian
Nothing like deprecations! Changing it to FILEDEF worked perfectly -- Thank you Francis -- the reason for the double quotation marks is that the variable assignment has spaces ---


Vivian Perlmutter
Aviter, Inc.


WebFOCUS Keysheet Rel. 8.0.2
(Almost) 1001 Ways to Work with Dates thru Rel. 8.0.2
Focus since 1982
WebFOCUS since the beginning
Vivian@aviter.com

October 23, 2012, 03:50 PM
Francis Mariani
Glad it worked out! I'll be checking my code and preempt the deprecation.


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