In this enhanced implementation, CS, where possible, avoids a read operation waiting for a row to commit before returning a value. CS now returns the currently committed result, ignoring what might happen to an uncommitted operation. Some exceptions, such as updatable cursors, exist; currently committed results cannot be returned immediately when the row might be updated based upon its previous contents. CS behavior is determined through the Concurrent Access Resolution (CAR) connection option.
Table 20. Cursor Stability Examples SELECT col1, col3, col4 FROM T2 WHERE col2 >= ? SELECT col1, col5, FROM T1 WHERE col5 = ? AND col2 = ?
![]() |
© 2013 Progress Software Corporation and/or its subsidiaries or affiliates. |