Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic native SQL constructs

Former Member
0 Kudos

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....

3 REPLIES 3

Former Member
0 Kudos

The native SQL depends on the database.

Look up a help.sap.com

0 Kudos

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

0 Kudos

Thanks!!! The Demo is great...