topic query in Application Development and Automation Discussions

query

Former Member — Tue, 15 May 2007 05:14:13 GMT

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

Re: query

Former Member — Tue, 15 May 2007 05:18:28 GMT

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

ENDEXEC.

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

Re: query

Former Member — Tue, 15 May 2007 05:25:07 GMT

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

Re: query

Former Member — Tue, 15 May 2007 05:28:35 GMT

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

Rewards ifhelpful

Re: query

Former Member — Tue, 15 May 2007 05:32:22 GMT

answered

Re: query

Former Member — Tue, 15 May 2007 05:34:01 GMT

hi Venila,

Refer

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

Regards,

Santosh

Re: query

Former Member — Tue, 15 May 2007 05:34:27 GMT

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