topic Re: EXEC SQL in Application Development and Automation Discussions

EXEC SQL

Former Member — Mon, 17 Dec 2007 11:42:36 GMT

Hi to all Guru's,

1.can anybody explain me what is 'EXEC SQL’?

Thanks

Priya

Re: EXEC SQL

Former Member — Mon, 17 Dec 2007 11:44:16 GMT

Hi Priya,

EXEC SQL is a statement used to perform NATIVE SQL operations.

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.

In Native SQL statements, the data is transported between the database table and the ABAP program using host variables. These are declared in the ABAP program, and preceded in the Native SQL statement by a colon (:). You can use elementary structures as host variables. Exceptionally, structures in an INTO clause are treated as though all of their fields were listed individually.

If the selection in a Native SQL SELECT statement is a table, you can pass it to ABAP line by line using the PERFORMING addition. The program calls a subroutine <form> for each line read. You can process the data further within the subroutine.

Thanks,

Vinay

Re: EXEC SQL

Former Member — Mon, 17 Dec 2007 12:02:29 GMT

good

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.

There is no period after Native SQL statements. Furthermore, using inverted commas (") or an asterisk (*) at the beginning of a line in a native SQL statement does not introduce a comment as it would in normal ABAP syntax. You need to know whether table and field names are case-sensitive in your chosen database.

As in Open SQL, after the ENDEXEC statement, SY-DBCNT contains the number of lines processed. In nearly all cases, SY-SUBRC contains the value 0 after the ENDEXEC statement. Cursor operations form an exception: After FETCH, SY-SUBRC is 4 if no more recors could be read. This also applies when you read a result set using EXEC SQL PERFORMING.

http://help.sap.com/saphelp_46c/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/content.htm

thanks

mrutyun6