Application Development and Automation 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: 
Read only

Execute String in Native or Open SQL

Former Member
0 Likes
504

Hi all,

I have the following question:

Is it possible to execute one string containing the selection code (string = 'select <field> from <db_table> where <conditions>') in NATIVE SQL or OPEN SQL?

Thanks in advanced.

Best Regards,

Giulio

1 ACCEPTED SOLUTION
Read only

former_member194669
Active Contributor
0 Likes
402

Hi,

You need to check for syntax GENERATE SUBROUTINE .

Please check this <a href="http://www.sapdevelopment.co.uk/programs/custom/zyes4sql.htm">link</a>

May this one will help you.

aRs

2 REPLIES 2
Read only

Former Member
0 Likes
402

According to the help:

Unlike in Open SQL, a client field in Native SQL is treated like any other field, and must therefore be listed explicitly in statements.

Rob

Read only

former_member194669
Active Contributor
0 Likes
403

Hi,

You need to check for syntax GENERATE SUBROUTINE .

Please check this <a href="http://www.sapdevelopment.co.uk/programs/custom/zyes4sql.htm">link</a>

May this one will help you.

aRs