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