Question Re: on which layer OPEN SQL query got's executed in Technology Q&A

on which layer OPEN SQL query got's executed

Balu483 — Sat, 09 Feb 2019 11:38:18 GMT

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?

Re: on which layer OPEN SQL query got's executed

Sandra_Rossi — Sat, 09 Feb 2019 13:16:07 GMT

Clear picture (and description) here : SAP Library - Database Accesses of the NetWeaver AS ABAP

Re: on which layer OPEN SQL query got's executed

matt — Sat, 09 Feb 2019 13:30:09 GMT

I.e processing done in both app and db servers.

Re: on which layer OPEN SQL query got's executed

Sandra_Rossi — Sun, 10 Feb 2019 06:44:56 GMT

(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.