Open SQL to Native SQL conversion

[Former Member]

Does anyone know of any function module or transaction that will translate Open SQL to Native SQL? What I'd like to do is be able to take raw abap and get an explain plan via ST05 without having to run the code.

I can get an explain plan with function module "DB6_EXPLAIN", but I can't get the code into the Native format that it needs first. BTW - Oracle 9i on 46c system.

Thanks for any help!

[Former Member]

I don't think there is any way you can get open SQL to Native SQL.

Cheers,

Satya

[christian_wohlfahrt]

Hi Tim!

Easiest way to get a conversion:

- Write your statement in a small test report

- Make a trace of it's execution

- copy the native SQL from the explanation

OK, you still have to run the code - but just in a small example report, not your original program. And once you have the translation, you will be able to make smaller changes directly in native SQL.

I don't think, that's more complex than having a function module for translation - this would also need to run.

Martin had a similar requirement, have a look:

Regards,

Christian