topic Native SQL/EXEC SQL in Application Development and Automation Discussions

Native SQL/EXEC SQL

Former Member — Mon, 01 Oct 2007 09:48:56 GMT

Hi all,

Is there any way of finding out if native SQL/EXEC SQL-statements have been used in the system?

All helpful answers will be rewarded!

Regards,

M.V.

Re: Native SQL/EXEC SQL

Former Member — Mon, 01 Oct 2007 09:54:14 GMT

Hi,

Check these links,

Hope it helps,

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

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

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/ad/samples/cpp/s-fnuse-sqC.htm

Regards,

PRitha.

Reward if helpful.

Re: Native SQL/EXEC SQL

sreeramkumar_madisetty — Mon, 01 Oct 2007 10:01:42 GMT

The generally used way is : search the program with the phrase EXEC statement.

Regards,

Sree

Re: Native SQL/EXEC SQL

Former Member — Mon, 01 Oct 2007 10:06:05 GMT

Hi,

There are over a thousand customer developed programs in the system for which I would like to find out if native SQL has been used, so searching for the EXEC statement in the source of all these programs will be quite time consuming...

Is there any other way of finding out wheter native SQL have been used in the system?

Regards,

M.V.

Re: Native SQL/EXEC SQL

varma_narayana — Mon, 01 Oct 2007 10:06:53 GMT

Hi..

You can use the Standard report

RS_ABAP_SOURCE_SCAN to find out the Programs using a Specific Keyword etc.

Reward if Helpful.