check SQL syntax runtime?

[Former Member]

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]

hi

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

[Former Member]

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]

Hi,

use subroutine pool with syntax check statement

for your purpose.

Regards

amole

[abdul_hakim]

hi

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