Open Sql and Native Sql

[Former Member]

Hi all,

Can anyone explain me the diference between open sql and native sql ? The select statements we use belongs to which category ?

Regards,

Varun.

[Former Member]

HI VARUN,

OPEN SQL STMTS ARE THE ONE WHICH ARE DATABASE INDEPENDENT QUERIES. YOU CAN USE THESE STMTS IN YOUR ABAP PROG. REGARDLESS OF THE DATABASE.

NATIVE SQL ARE THE QUERIES FOR THAT PARTICULAR DBASE USED, WHICH WE RARELY USE IN ABAP.

BUT MAJORITY OF THE TIMES ABAP PRG.USES THE OPEN SQL AND WE DONOT NEED TO BOTHERED BY THE NATIVE SQL AND ABOUT THE DATABASE TOO, WHEN YOU ARE USING OPEN SQL.

YOU WANT TO KNOW MORE.LET ME KNOW.

REGARDS,

RAVI.