MVSFORUMS.com

[SureshKumar]

Hi folks,
One of my DBA's told me that there is a technique to Commit intermitently within a SPUFI. He did not let me know what it is and just not able to figure it out. Here is an example
Update ABC
SET X = y
WHERE a = :A

lets say 100 thousand rows qualify. according to my DBA there may be some change he may do to the SQL and it would commit every update. I am not sure as to the technique and how it works. Have any of you any idea about this. Thanks