Focal Point
Sending cancellation request to Webfocus reporting server

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

June 23, 2008, 09:11 AM
<Bhuvaneswari>
Sending cancellation request to Webfocus reporting server
Hi,

We are using Webfocus 7.6.4 for generating the reports.

In the client side we invoke WFServlet passing the parameters as query parameters to run the report. Is there a way to send a cancellation request to webfocus?

Any help is greatly appreciated.

Thanks,
Bhuvana
June 23, 2008, 11:21 AM
Darin Lee
By cancellation request, I assume you are wanting to stop a query in mid-processing. There isn't really such a thing in WF. You can go to the WF server console and stop an agent which, in essence, cancels any further processing on the WF server.

However, in most cases, this does not do anything on the database side. Most, if not all, DMBSs provide tools to allow for a cancellation. There is also a server parameter NONBLOCK that will check after each n records processed to see if the requestor (in this case, the WF server) is still waiting for a response. If not, the query is cancelled in the DBMS. It appears, however, that this parameter should be used carefully as there are reports of mixed results. You can probably do a search on "cancel request" or "nonblock" and see additional info regarding use of the parameter.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat