topic Re: Native SQL to retrieve range in Application Development and Automation Discussions

Native SQL to retrieve range

Former Member — Fri, 17 Jul 2009 01:03:26 GMT

Hi,

I have an requirement in which i need to retreive the data from oracle database(ODS) using native sql.

In the selection screen iam giving select option for lotid. Based on the lotid i need to retrieve the data from ODS.

If the user enters range for eg 1 to 5, how can i use that range in native sql query?

Regards,

Arun.

Re: Native SQL to retrieve range

Former Member — Fri, 17 Jul 2009 05:08:28 GMT

Prepare your sql statement in ABAP , and execute it while activating the trace,

Then display trace and goto EXPLAIN SQL , here you will get the sql statement in native SQL ,now this statement will differ from the database you want to run the native sql on since, the statement you get will be native to the database your sap server is running on

But it should be similar .

Try it out.