|
Go
 |
New
|
Search
|
Notify
|
Tools
|
Reply
|
|
|
Member |
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. Edgar Plain VMS Focus 6.9.8 |
||
|
|
Gold member |
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. |
|||
|
|
Expert |
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 Env 1: WebFOCUS 5.3.2 Servlet - MRE/BID/Self Service/ReportCaster - MS Windows Server 2003 - IIS/New Atlanta ServletExec - MS SQL Server 2000 - DataMigrator 5.3.4 Env 2: WebFOCUS 7.6.5 Servlet - MRE/BID/Self Service - MS Windows XP SP2 - Apache Tomcat/5.5.25 - MS SQL Server 2000 Env 3: WebFOCUS 5.3.3 CGI - Self Service - AIX 5.2 - IBM DB2 Output formats: HTML, Excel 2000 and PDF |
|||
|
|
Member |
Thanks Worked Great! Edgar Plain VMS Focus 6.9.8 |
|||
|
| Previous Topic | Next Topic | powered by eve community |
 | Please Wait. Your request is being processed... |
|
|||
| Site | Focal Point | ||
| Servlet | eve2da016 | ||
| Version | 1.2.22 build 9062 | ||
| Module | Forums 4.0.3 | ||
| Stylesheet | "ibi" | ||
| Wordlet Set | "Default Wordlet Set" | ||
|
Copyright © 1996-2008 Information Builders, leaders in enterprise business intelligence.