topic executing SQL Commands in Application Development and Automation Discussions

executing SQL Commands

Former Member — Thu, 12 Feb 2009 09:20:53 GMT

Hello all,

Can any one tell me how to execute Native SQL queries from ABAP.

Thanks in advance.

Best Regards,

Sasidhar Reddy Matli.

Re: executing SQL Commands

GauthamV — Thu, 12 Feb 2009 09:23:02 GMT

check this.

[http://help.sap.com/saphelp_nw04/helpdata/en/51/ef9f94e4ba894d8e93b2eed7c9f82d/frameset.htm]

Re: executing SQL Commands

Former Member — Thu, 12 Feb 2009 09:27:31 GMT

Hi,

Check out below link for ABAP.

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

Regards,

Vishal

Re: executing SQL Commands

former_member396896 — Thu, 12 Feb 2009 09:28:56 GMT

http://help.sap.com/saphelp_nw04/helpdata/EN/fc/eb3b8b358411d1829f0000e829fbfe/frameset.htm

Re: executing SQL Commands

Former Member — Thu, 12 Feb 2009 09:29:55 GMT

Hi,

Kindly go through these link below:

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

Hope it helps

Regrds

Mansi

Re: executing SQL Commands

former_member222860 — Thu, 12 Feb 2009 09:31:32 GMT

Hi,

Write your SQL queries in between Exec Sql and EndExec.

Here's sample code:

data: begin of itab occurs 0,
          matnr like makt-matnr,
          maktx like makt-maktx,
        end of itab.

exec sql.
select matnr, maktx from makt into :itab
endexec.

loop at itab.
write:/ itab-matnr, itab-maktx.
endloop.

Check in Help/ for more info.

Cheers\

Mahesh