Optimized a SQL statement using SQL Optimizer for DB2 LUW. When executing, the original query returns 2 rows and optimized query returns 0 rows.
Auto Commit when finished editing has been checked.
Turn off Auto Commit when finished editing.
Click on File | Options | General | Result Set | Remove check mark at Auto Commit when finished editing.
The Result Set page of the General tab on the Options window allows you to set option for editing data.
Auto Commit when finished editing
Automatically commit the changes after each record is changed when editing the data in the Database Explorer window.