Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Transactions and isolation levels » Isolation level tutorials


Tutorial: Understanding phantom rows

In this tutorial, you will observe the appearance of a phantom row.


For this tutorial to work properly, the Automatically Release Database Locks option must not be selected in Interactive SQL (Tools » Options » SQL Anywhere).

Lesson 1: Creating phantom rows
Lesson 2: Avoiding phantom rows