topic Re: check SQL syntax runtime? in Application Development and Automation Discussions

check SQL syntax runtime?

Former Member — Sun, 08 Oct 2006 09:48:31 GMT

Hi!

Is there any way to check the syntax of an SQL statement runtime? For example, I have a dynamic SQL:

select (text1)

from (text2)

where (text3).

or I have an internal table of string containing the sql statement.

How can I check whether it is syntactically correct or not? Is there a funcion module for this?

thanks,

Tamas

Former Member — Sun, 08 Oct 2006 09:53:56 GMT

Hi tamas,

1. Good question

2. Unfortunately i don't think there

is any FM or any code,

which can check such syntax, dynamically.

(so that run time error can be avoided)

regards,

amit m.

Former Member — Sun, 08 Oct 2006 14:37:40 GMT

Hi,

use subroutine pool with syntax check statement

for your purpose.

Regards

amole

abdul_hakim — Sun, 08 Oct 2006 14:46:27 GMT

welcome to sdn..

i dont think you can do it as you want..

but you could use sql trace st05 for checking the performacne of your sql statement..

Cheers,

Abdul Hakim