Transaction

[ank123]

Hi,

I am new to progress so please help me ot write a query for below requirement.

There is a table having thousands of the records and i want to update all the records so i want to write a query so that 200 records get committed at a time.Once changes made for these 200 record then another 200 records should be committed and so on.. Please let me know the ways to write such kind of query.

 

[TomBascom]

define variable i as integer no-undo.

outer: do for customer transaction while true:
  inner: do i = 1 to 100:
    find next customer exclusive-lock no-error.
    discount = 0.
  end.
  if not available customer then leave outer.
end.