IBM Support

QSYS2.FIND_AND_CANCEL_QSQSRVR_SQL and QSYS2.CANCEL_SQL procedures

News


Abstract

QSYS2.FIND_AND_CANCEL_QSQSRVR_SQL and QSYS2.CANCEL_SQL procedures

Content

You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Database Engineer (DBE) Enhancements > QSYS2.FIND_AND_CANCEL_QSQSRVR_SQL and QSYS2.CANCEL_SQL procedures

QSYS2.CANCEL_SQL procedure

The procedure, QSYS2.CANCEL_SQL(), can be called to request the cancellation of an SQL statement for a target job.

SQL cancel support provides an alternative to end job immediate when deciding how to deal with an orphaned or runaway process. End job immediate is a hammer, where SQL cancel is more like a tap on the shoulder. Prior to this improvement, the SQL cancel support was only available to ODBC, JDBC, and SQL CLI applications. The CANCEL_SQL() procedure extends the SQL cancel support to all application and interactive SQL environments.


See IBM Documentation for details: CANCEL_SQL procedure
Enhanced with IBM i 7.5 SF99950 Level 5 & IBM i 7.4 SF99704 Level 26:
  • No authority required to cancel your own jobs

QSYS2.FIND_AND_CANCEL_QSQSRVR_SQL procedure

 

The FIND_AND_CANCEL_QSQSRVR_SQL() procedure uses the QSYS2/FIND_QSQSRVR_JOBS and QSYS2/CANCEL_SQL() procedures to derive the set of jobs which have active SQL activity. Each job found is made a target of an SQL cancel request.

See IBM Documentation for details: FIND_AND_CANCEL_QSQSRVR_SQL procedure

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000001go6AAA","label":"IBM i Db2-\u003ESQL Services \/ table functions"}],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"6.1.0;and future releases"}]

Document Information

Modified date:
06 October 2023

UID

ibm11169698

Page Feedback