D
dbeavon
Guest
OE-SQL92 and OE-ABL are totally different. They share low-level database resources, but resolve queries in different ways. In promon you will often see lock types which are specifically there to support SQL92 features, while ABL would not otherwise have any use for them. (Whereas OE-ABL must respect SQL92 locks - and sometimes even take SQL92-style locks in order to coexist - ABL doesn't have the ability to take and use the full set of locks that are possible - see knowledgebase.progress.com/.../P37194) There are other differences beyond locking types. SQL92 can also do some cool things to resolve queries from index data alone, while ABL doesn't really have anything like that. We use SQL92 primarily for reporting purposes but it has many other uses too. Your idea about "2 paths to the same database engine" is not accurate. That was probably the way SQL89 was built (which is now deprecated). SQL89 always felt like an ugly SQL syntax layer that was built on top of the same AVM and it probably used the exact same database engine features as it would have been used in ABL.
Continue reading...
Continue reading...