Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Checking logic prior to execution
Go
New
Search
Notify
Tools
Reply
  
Checking logic prior to execution
 Login/Join
 
<Edgare>
posted
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.
 
Reply With QuoteReport This Post
Gold member
posted Hide Post
If 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.
 
Posts: 76 | Registered: October 28, 2003Reply With QuoteReport This Post
Expert
posted Hide Post
The 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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
<Edgare>
posted
quote:
SET XRETRIEVAL = OFF

Thanks Worked Great!
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Checking logic prior to execution

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.