cancel
Showing results for 
Search instead for 
Did you mean: 

MaxDB and Open SQL ?

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

alexander_schroeder
Participant
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

So i can use open sql commands and sap db understands them directly ??