Something like Toad / SQLNavigator for OpenSQL?

[Former Member]

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?

[christian_wohlfahrt]

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

[Former Member]

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

[christian_wohlfahrt]

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

[Former Member]

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

[Former Member]

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 .

[Former Member]

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.

[Former Member]

Timed out, close as cleanup