The SQLTransact function requests a commit or rollback operation for all active operations on all statements that are associated with the connection. All open server cursors remain open after this operation if SQL_PRESERVE_CURSORS has been set to SQL_PC_ON. By default, cursors are closed on commit or rollback.