Dynamic native SQL constructs

[Former Member]

Hi Gurus,

I want to generate dynamic native sql constructs. Following is the code i am using but it genrates exception of invalid SQL statement

EXEC SQL.

OPEN c1 FOR

SELECT (l_t_code) FROM (s_tabnm) WHERE (l_t_codewhere)

ENDEXEC.

Please brief me how to create dynamic native SQL constructs .

Thanks

Sonal....

[Former Member]

The native SQL depends on the database.

Look up a help.sap.com

[Former Member]

Check the program, ADBC_DEMO in SE38. It will help you create dynamic native SQL queries.

[fabian_otto]

Thanks!!! The Demo is great...