query

[Former Member]

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

[Former Member]

Hi,

To use a Native SQL statement, you must precede it with the EXEC SQL statement, and follow it

with the ENDEXEC statement as follows:

EXEC SQL [PERFORMING <form>].

<Native SQL statement>

ENDEXEC.

Dis advantage of using native sql is its is database specific.

[Former Member]

Hi Vennila,

All native SQL commands cann be written in between......

EXEC SQL [PERFORMING form].

................

Native SQL stetements.......

...........

ENDEXEC.

<b>One important point is, these NATIVE SQL statements are directly executed in the underlying database.</b>

Go through the following link for complete details:

http://help.sap.com/saphelp_nw04s/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/frameset.htm

<b>

Reward all helpful answers</b>

Regards,

V.Raghavender.

http://help.sap.com/saphelp_nw04s/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/frameset.htm

[Former Member]

http://www.sapdb.org/7.4/htmhelp/d2/b685c05725bc4db947d0856daae9b1/content.htm

Rewards ifhelpful

[Former Member]

answered

[Former Member]

hi Venila,

Refer

http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/exec.htm

Regards,

Santosh

[Former Member]

Hi Vennila,

Using EXEC and ENDEXEC you can communicate with the external databases using native sql commands. There is no disadvantage of using them as far as i know.

The meaning of abap editor being integrated into ABAP data dictionary can be understood using the following.

if you declare a variable in abap editor like this:

data: v_matnr type mara-matnr.

The compiler would first check the existence of the table mara and the field matnr in the abap data dictionary.

It it does exist, then it will not give a syntax error.

Reward points if helpful.

Regards,

Hemant