Stopping SQL scripts

 

You can stop or cancel a running SQL script from iSeries™ Navigator. To stop or cancel SQL scripts that are running, select one of the following options from the Run menu:

• Stop After Current: Stop running the SQL script after the currently running statement ends.

• Cancel Request: Request that the system cancel the current SQL statement. However, because not all SQL statements can be canceled, an SQL statement might continue to completion even after this option is used. SQL statements that have already completed host processing before Cancel Request is pressed also continue to completion. For example, SELECT statements that have already completed query processing but have not returned results to the client typically cannot be canceled.

 

Parent topic:

Querying your database by running SQL scripts