topic Re: Dynamic table in ABAP NATIVE SQL statement in Application Development and Automation Discussions

Dynamic table in ABAP NATIVE SQL statement

alexandreourth — Thu, 02 Aug 2018 19:03:07 GMT

Hello experts,

I'm in SAP ECC6 system and I'm working with an external Database. I use Native SQL statement to dialog with it ( CONNECT TO db ...) EXEC SQL.

     EXEC SQL
             OPEN C FOR SELECT * FROM :gv_table
        ENDEXEC.

      DO.
        EXEC SQL.
          FETCH NEXT C INTO :<fs_line>
        ENDEXEC.
         ......

The gv_table is a data from my ABAP program which is well filled. When i execute, i have an oracle error which says : "Invalid table name". Or when i check the debugger the data is good.

Does someone know how to perform an Native SQL query with a dynamic FROM clause please?

Kind regards,

Alexandre

Re: Dynamic table in ABAP NATIVE SQL statement

matt — Thu, 02 Aug 2018 20:47:02 GMT

Use the CL_SQL_STATEMENT and related classes. Then it's a doddle to dynamicly generate native SQL.

Re: Dynamic table in ABAP NATIVE SQL statement

roberto_forti — Fri, 03 Aug 2018 00:48:54 GMT

Native SQL error is occurring because table statement from external database is missing. So, it is required (example: ... FROM xptotab).

Re: Dynamic table in ABAP NATIVE SQL statement

Siddharth_Shah1 — Fri, 03 Aug 2018 03:44:06 GMT

Hi Alexandre,

Try with ADBC - ABAP Database Connectivity.

https://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=491920170

Regards,

Sid

Re: Dynamic table in ABAP NATIVE SQL statement

retired_member — Fri, 03 Aug 2018 06:46:47 GMT

You use Native SQL to select from an internal table. Simply Impossible! This is only available for Open SQL.

Re: Dynamic table in ABAP NATIVE SQL statement

alexandreourth — Fri, 03 Aug 2018 07:47:19 GMT

Hi Matthew,

I did it! Thanks a lot for the tip really helpful!

It was a combination of this class and another one and it did the work!!!!

Have a good day 🙂

Re: Dynamic table in ABAP NATIVE SQL statement

alexandreourth — Fri, 03 Aug 2018 07:52:05 GMT

Hi Horst,

There is a workaround to do that. Check Matthew's answer.

Have a good day.

Re: Dynamic table in ABAP NATIVE SQL statement

alexandreourth — Fri, 03 Aug 2018 08:31:18 GMT

Hi Siddharth,

Thanks for your answer. It was something like that yes. I don't know why people downvoted your answer because it is the same lead as matthew's and it's the correct one.

Have a good day

Re: Dynamic table in ABAP NATIVE SQL statement

matt — Fri, 03 Aug 2018 10:43:26 GMT

Could be because it's the same as mine, but posted 6 hours later... ,-)

Re: Dynamic table in ABAP NATIVE SQL statement

alexandreourth — Fri, 03 Aug 2018 10:54:33 GMT

Or people are salty...don't know 🙂

Re: Dynamic table in ABAP NATIVE SQL statement

retired_member — Fri, 03 Aug 2018 17:08:53 GMT

No, it isn't.

ADBC enables dynamic Native SQL, yes.

But your Syntax for selecting data from an internal table

SELECT * FROM :gv_table

is not possible in EXEC SQL and not in ADBC.

Since 7.52 it is possible in ABAP SQL:

SELECT * FROM @gv_table

Your example simply didn't fit to the question.

Re: Dynamic table in ABAP NATIVE SQL statement

Siddharth_Shah1 — Sat, 04 Aug 2018 08:53:08 GMT

Thats fine. It's good that what I thought and answered is correct.

Re: Dynamic table in ABAP NATIVE SQL statement

alexandreourth — Sat, 04 Aug 2018 13:16:26 GMT

Yeah but Matthew and Siddarth understood what i was trying to achieve so they gave me useful hints to look for.

You sir just said "Simply Impossible" => Not helpful. It's a community here, so yeah sometimes we have to understand what the person is trying to do and not be narrow minded in our answers.

Maybe you should think about that for your next posts.

Re: Dynamic table in ABAP NATIVE SQL statement

retired_member — Sat, 04 Aug 2018 14:32:11 GMT

In fact, the help was already there ....

Re: Dynamic table in ABAP NATIVE SQL statement

matt — Sun, 05 Aug 2018 08:53:50 GMT

If you wish to continue to get help on this site, it's probably not a good idea to be snarky with someone who happens to be the foremost expert on ABAP. Your question as stated was unclear - I read it one way, Horst another.

If you feel a response was rude, the correct action is to notify moderator. However, in this instance I do not think Horst's answer was in any way inappropriate.

Matt - SAP Community Moderator.