on 02-09-2019 11:38 AM
hi,
i have following doubt in my mind since long back .
can any one give a brief explanation on where will be the OPEN SQL got executed/ processed. either in Application Layer or Database layer ?
if an ABAP program executed and it contains a select query , then what will happen unless the data comes in internal table/ work area i.e. process flow chart of an OPEN SQL. can any one provide with clear picture or processing of OPEN SQL Query Statement?
Clear picture (and description) here : SAP Library - Database Accesses of the NetWeaver AS ABAP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I.e processing done in both app and db servers.
(1) ABAP SQL statement ---exec---> (2) Kernel DataBase Interface (BC-DBI) ---exec---> (3) Kernel DataBase Shared Library (DBSL) ---exec---> (4) SQL statement at database level
(1) (2) (3) are at the SAP application server level; they build the SQL statement so that its syntax is valid/recognized by the type of database at (4) (i.e. HANA, Oracle, etc.); there is one DBI common to all database types; there is one DBSL per database type.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.