topic Execute String in Native or Open SQL in Application Development and Automation Discussions

Execute String in Native or Open SQL

Former Member — Wed, 08 Aug 2007 18:01:52 GMT

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

Re: Execute String in Native or Open SQL

Former Member — Wed, 08 Aug 2007 18:27:49 GMT

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

Re: Execute String in Native or Open SQL

former_member194669 — Wed, 08 Aug 2007 18:30:16 GMT

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