Can we use EXEC SQL in ABAP

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[RaymondGiuseppi]

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.