Consultor Eletrônico



Kbase P28260: Table is locked after transaction.
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   10/15/2008
Status: Unverified

FACT(s) (Environment):

Progress 9.1D

SYMPTOM(s):

Performing a find on a table results in a table being locked.

Transaction ends with a SHARE-LOCK from an EXCLUSIVE-LOCK.

CAUSE:

A SHARE-LOCK has been left on the table after the transaction.

FIX:

Fetch the table with a NO-LOCK.

Example code snippet:

FIND CURRENT table NO-LOCK.