topic Re: Can we use EXEC SQL in ABAP in Application Development and Automation Discussions

Can we use EXEC SQL in ABAP

Former Member — Mon, 11 Mar 2013 05:44:20 GMT

Dear All,

Can I use EXEC SQL Statement in ABAP.

EXEC SQL INSERT INTO MYEMP SELECT * FROM ENDEXEC

if yes then how & where we can use it.

Re: Can we use EXEC SQL in ABAP

Former Member — Tue, 12 Mar 2013 13:14:24 GMT

Hi,

Yes, you can.

Native SQL statements are used to access database tables not defined in ABAP dictionary and hence allow us to integrate data not part of R/3 system.

This is an interesting link that i suggest

http://scn.sap.com/docs/DOC-34669

However,

SAP recommends the usage of ADBC (ABAP Database Connectivity) to access the external DBs.

Best Regards

Ivan

Re: Can we use EXEC SQL in ABAP

RaymondGiuseppi — Tue, 12 Mar 2013 13:25:22 GMT

Yes you can, just perform a search on google like EXEC SQL site:help.sap.com/Abapdocu_731 to find documentation relative to native sql in SAP on-line Abap documentation.

Regards,

Raymond.