Try OpenEdge Now
skip to main content
SQL Development
Data Control Language and Transaction Behavior : Transactions and isolation levels : Phantom read
 

Phantom read

A phantom read occurs when one user is repeating a read operation on the same records, but has new records in the results set, as shown in the following example.
User A executes:
SELECT * FROM State;
User B executes:
INSERT INTO pub.State (state, state_name, region)
VALUES (‘CT', 'Connecticut', ‘Northeast');
COMMIT WORK;
User A re-executes:
SELECT * FROM pub.State;
User 1 has new records in the results set.