SQR SQL Commit

[Chris Snow <chris_snow@EMAIL.MSN.COM>]

Hello Everyone,

I have an SQR report that performs about six table update or insert commands
for each record it selects during its report.  Since there is no implicit
sql commit, and doing an explicit commit destroys the cursors, it places
locks on all the tables in its DML statements.  This of course locks all the
users from these tables until the report is complete which in some cases
could be several minutes (and is not acceptable).

Is there a way to modify my code so that it performs an implicit commit
somehow?  I mean, is there a function or subroutine that SQR does that
would, in effect, cause a commit without destroying the active cursors in my
report?

Any help at all is greatly appreciated.

__________________________________
Chris Snow, Integrity Information Services
800-724-5939 pgr.
chris_snow@msn.com
'As knowledge increases, wonder deepens'
                                           Charles Morgan