topic Re: Open SQL to Native SQL conversion in Application Development and Automation Discussions

Open SQL to Native SQL conversion

Former Member — Tue, 08 Nov 2005 01:44:50 GMT

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!

Re: Open SQL to Native SQL conversion

Former Member — Tue, 08 Nov 2005 05:14:28 GMT

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

Cheers,

Satya

Re: Open SQL to Native SQL conversion

christian_wohlfahrt — Tue, 08 Nov 2005 07:50:45 GMT

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