Since I'm about to switch from PostgreSQL to SAP DB, I have a few questions:
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?) Example: 'SELECT name FROM people WHERE record_id=11' and record_id 11 is exclusive locked. Gives no result? 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? Thanks a lot -Zavier _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
