April 25, 2007, 01:17 PM
<Edgare>Checking logic prior to execution
Hi
Is there a way to have focus check the entire logic of the query before it runs it? I have a huge query with dozen sections that create data dump files... Usually it executes then half way down it find an error with something. Is there a way for it to check the entire code before executing it?
Thanks
Edgar
Running focus FOCUS 6.9.8 on Open VMS.
April 25, 2007, 01:32 PM
RBIf you just want to check for the general coding errors, add
SET XRETRIEVAL = OFF on the first line of your query
this would not execute the query and just checks for the coding errors.
April 25, 2007, 01:49 PM
Francis MarianiThe only problem I've found with SET XRETRIEVAL=OFF is that the agent crashes when a complex program has MORE FILE - I cannot reproduce the error at the moment...
Very annoying, so hopefully this has been fixed in versions newer than 5.3.2.
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