function module

[Former Member]

hi all ,

Iam totally struck up in an integration project . Iam searching for a function module which can take the open sal statement as import and should give the result of the statement as output . This module should be generic . Have anybody worked on this . Is there any other way for this .

Waiting for ur help .

Thanks,

Bast regards,

Kasi.

[ssimsekler]

Hi to all!

Will it be helpful using the function module 'EXEC_SQL'???

Serdar

[Former Member]

I am not sure whether this is possible. If you happen to get the solution, pls let me know

[Former Member]

Are you trying to tell that you want to execute an SQL statement dynamically and then capture its output.

You might try dynamic code execution to achieve this functionality. But I am not clear on your requirement to guide you further.

Pavan

[Former Member]

Dear pavan ,

Yes i want to execute the sql statement dynamically and capture its output.

Consider a open sql query will be given as input and i need to capture its output . This should be generic .

thanks,

kasi

[Former Member]

I donot think any such function module exists, but you will have to explore into dynamic code execution and dynamic data declaration.

In order to achieve the same.

Plz explore on data type ref to data

and generate subroutine statements.

Pavan