reports

[Former Member]

Hi,

What does an EXEC SQL stmt do in ABAP? What is the disadvantage of using it?

[Former Member]

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/content.htm

http://help.sap.com/saphelp_46c/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/content.htm

[Former Member]

Hi Madhu,

Open SQL allows you to access database tables declared in the ABAP Dictionary regardless of the database platform that you R/3 System is using. Native SQL allows you to use database-specific SQL statements in an ABAP program. This means that you can use database tables that are not administered by the ABAP Dictionary, and therefore integrate data that is not part of the R/3 System.

As a rule, an ABAP program containing database-specific SQL statements will not run under different database systems. If your program will be used on more than one database platform, only use Open SQL statements.

for more info refer to this link

http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/content.htm

Kindly Reward Points If You Found The Reply Helpfull

Cheers,

Chaitanya.

[Former Member]

Hi,

Basically that is Native SQL statement in SAP.

SAp itself has its OPEN SQL Satement,to diiferentiate from Open SQL Statement from Native one to the Syatem,its the Convention.

Check this link-

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/content.htm

http://help.sap.com/saphelp_46c/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/content.htm

regards,

sujit