Commit Problem not only in DB2

[td <tdelia@EROLS.COM>]

In regard to the COMMIT problem in DB2 where the SELECT cursor is
closed  when the COMMIT is executed is not limited to DB2. I'm
developing a large-scale Oracle process but due to system limitations
(like an available work-station, userids, network access, etc) I was
forced to begin developing a prototype in SQLBase. I encountered the
same problem - Once the Commit is executed any subsequent fetches return
an error. Since I was testing a low volume of data (and don't use
SQLBase that much) I had the luxury of simply changing my commit count
and moving along. Just thought some of the group could use this info for
future reference.
                                          -Tony DeLia
                                           AnswerThink Consulting Group
                                           PeopleSoft Solutions Practice