on 12-08-2005 12:00 PM
Hello, my question is about the use of open sql and maxdb:
i read that the sapdb/maxdb "knows" this dialects:
- SAPs inhouse : Internal
- SQL92
- IBMs DB2 Version 4
- Oracle7
But can i access via Open Sql (or via native sql) on the database directly, or will there be a translation of the open sql code (over a database-interface for example) to
a kind of standard sql ?
Thx
H.
Open SQL is an abstraction layer applied on top of the native SQL dialects in the SAP WebAS.
However, as Open SQL is defined to be basically SQL 92 plus 'LEFT JOINS' plus 'SELECT ... FOR UPDATE' commands, there is no translation necessary or done for MaxDB here.
If you use OpenSQL from Java, your SQL is checked against the logical catalog. Also, OpenSQL limits some functionality that is optional and not implemented by all supported database systems - e.g. all result sets in OpenSQL are forward-only.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
these dialects are known in the database kernel/server. Therefore there is no special client to understand/translate them. Every interface can use them.
Elke
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.