SQR cycle

[Michael Bower <MB0526@AOL.COM>]

Hello,
I am running an SQR that does a begin-select from a table.  I then want to
process those records selected but I do not want the select to continuously
run every time a new record is needed.  For example:

Begin-Select

Customer,
Customer_Number

  Do Main-Processing  (which includes a commit statement)

 From
  Customer_Table

 Where  Customer_Number = 0

End-Select

When you place the processing routine within the select doesn't sqr utilize
its own cycle so that the select does not run every time a new record is
needed?  Right now the SQR is running extremely slow and I am just wondering
if the cycle is being utilized.  Also, if it is being utilized, since the a
commit is being done after a certain number of records, does that force the
select to be executed again afterwards?  Thank You in advance for everyone's
help.

Michael Bower
MB0526@aol.com

P.S.  Our DBA is saying that the select is executing every time a new record
is needed for processing.  This is why I have this question.