I developed a client-server application using Borland C++ Builder that use DB2 Connect to access an OS/400 DB2 Database. My DB2 UDB version is 7.1 Enterprise Edition.
I read from a table defined in the DB2400, the clause that I use is a SELECT clause and never I'm doing any kind of table update. If someone is entering data to the same file at the time that my application runs the select query, my application stops responding until the other people release the record.
I tried to use a Dirty Read but with no results. Any of you can help to solve this problem????