> 1. Unlike PostgreSQL and Firebird, SAP DB does not use a > versioning engine > for transactions. I wonder if an "exclusive locked" row or > table is not > readable anymore by SELECT's that are NOT part of a > transaction (or are all > SQL statements automatically a transaction, even if not declared?)
Every SQL occurs in a transaction. > Example: 'SELECT name FROM people WHERE record_id=11' and > record_id 11 is > exclusive locked. Gives no result? I'd say that this transaction blocks until the other transaction is commited or a lock timout occurs. > > 2. There are 5 Database Instance Types. Can I use all SQL > commands and data > types in any of them? Is the difference between them mainly > the way the > database is physically organized in RAM/Storage? see http://www.faqts.com/knowledge_base/view.phtml/aid/19504/fid/1113 Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
