topic Re: Something like Toad / SQLNavigator for OpenSQL? in Application Development and Automation Discussions

Something like Toad / SQLNavigator for OpenSQL?

Former Member — Thu, 03 Mar 2005 15:49:10 GMT

Coming from the J2EE side, I'am missing something like SQL Navigator or Toad in ABAP workbench. I found some transactions as SE16N, but I am more looking for something where I can build OpenSQL Queries 'on the fly'.

Is there something like this?

Re: Something like Toad / SQLNavigator for OpenSQL?

christian_wohlfahrt — Thu, 03 Mar 2005 17:12:14 GMT

Hi Klaus,

I don't know, what SQL Navigator might be - but have a look at transaction SQVI (Quickviewer) and SQ01 (SAP Queries).

Regards,

Christian

Re: Something like Toad / SQLNavigator for OpenSQL?

Former Member — Fri, 04 Mar 2005 10:34:53 GMT

Thx Christian, SQVI is the right direction.

Still I am looking more for a command line oriented approach where I can directly type in my OpenSQL queries and fire them.

Regards Klaus

Re: Something like Toad / SQLNavigator for OpenSQL?

christian_wohlfahrt — Fri, 04 Mar 2005 10:54:34 GMT

Hi Klaus,

then you should use SE38, local program ZTEST_USER, use an internal table and a break-point. (Or a loop / write).

For performance analysis you can use ST05 (enter SQL command).

Regards,

Christian

Re: Something like Toad / SQLNavigator for OpenSQL?

Former Member — Fri, 04 Mar 2005 10:54:43 GMT

Hi Klaus,

if you are on Oracle, you can use sql plus. It is not as comfortable as toad, but you can do what you want to. Or does it need to be a open tool that can connect to every db using odbc?

regards

Siggi

Re: Something like Toad / SQLNavigator for OpenSQL?

Former Member — Mon, 07 Mar 2005 10:47:24 GMT

Thanks again Christian for your input.

ST05 was perfect if it would also display the results of the select, not only the explain.

But with all your hints together I am able to survive .

Re: Something like Toad / SQLNavigator for OpenSQL?

Former Member — Mon, 07 Mar 2005 10:54:49 GMT

Thanks Siggi,

it is true I can always go on one level deeper on Oracle Level. However, it'd like to issue OpenSQL commands, because otherwise I miss all the logic coming along with it.

Re: Something like Toad / SQLNavigator for OpenSQL?

Former Member — Wed, 20 May 2009 14:53:41 GMT

Timed out, close as cleanup