You need to execute the DISCONNECT. I often have below functionality + error handling in my transaction base class.

// of_Disconnect: Encapsulates embedded SQL
if this.DBHandle() = 0 then return // Already disconnected => DONE
DISCONNECT USING this;
// -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
// Destructor: Auto-disconnect if you want that safety
this.of_Disconnect()