How to execute a string which contains query in ABAP?

[former_member579349]

I have string variable and i am creating my query dynamically and storing it in string.

Now I want to execute it but my query is a string.

So I am not sure how to execute it.Could you please help me ?

Thanks!

[srikanthnalluri]

Try ADBC, refer the demo program - DEMO_ADBC_QUERY

You can pass you query to CL_SQL_STATEMENT, other way is to use the sub routine query. Refer this - Link

[TMSingh_SAP]

Hi pratish,

Hard to explain..what you need...and what you have done....For a query to get answered you need to give details but befor that check SDN also ..there may be similar queries also..

First show what u r doing or trying to achieve

and the where is the problem coming...

Mohan

[former_member579349]

Eg. DATA : STR TYPE STRING VALUE " SELECT QUERY WHICH HAS BEEN DYNAMICALLY CREATED".

is there any way to execute STR?

[srikanthnalluri]

It is doable, Use Sub routine pool generated program. I have updated my answer.