Progress/400
Product Guide


Transactions

The Progress RDBMS and the Progress/400 DataServer process records differently before a transaction completes or is committed. The differences are as follows:

This difference is illustrated in Table 2–5, where a Progress transaction deletes RECORD A before the transaction is committed. In this example, RECORD A means a record with a specific key, such as CUSTOMER WHERE CUST-NUM = 300.

Table 2–5: Standard Progress and Progress/400 Transactions
User 2 Activity
Standard Progress
Progress/400
Available
Locked
View
Available
Locked
View
Inserts Record A
No
Yes
Locked
No
Yes
Locked
Reads Record A, SHARE-
LOCK
No
Yes
Locked
No
No
Deleted
Reads Record A, EXCLU-
SIVE-
LOCK
No
Yes
Locked
No
No
Deleted
Reads Record A, NO-LOCK
No
No
Deleted
No
No
Deleted


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095