Dear IBO users

What is the best my of doing commit that still leaves the dataset open?

I read that commitretaining/rollbackretaining isn't a good practice
cause it consume much more memory + prodcue some OAT problems.

How about if I need to close and open a dataset due to some changes in
the SQL statement. Will refresh do the trick?

jtsiy