Is there report or TCODE for execution of open sql SELECT query

[Former Member]

Hello, All!

I'd like to execute user-defined OPEN SQL code in production system. I need something like DB02->Performance->Additional Functions->SQL Command Window, but for OPEN SQL for reading cluster tables. Is there ready-to-use TCODE or report for executing sql?

[Former Member]

Hello, All!

I'd like to execute user-defined OPEN SQL code in production system. I need something like DB02->Performance->Additional Functions->SQL Command Window, but for OPEN SQL for reading cluster tables. Is there ready-to-use TCODE or report for executing sql?

[Former Member]

I don't think your security administrator or DBA would like that...consider the destructive capabilities in a production environment.

You might be able to do something with SM49/69

[Former Member]

As I understand it's just os command, so i can only make native sql query via sql plus for example. I can do it via db02. But sm49/sm69 doesn't allow to make open sql query.

I just want to select. I don't think it's destuctive.

[Former Member]

>

> I just want to select. I don't think it's destuctive.

Once you have the ability to do the SELECT, you would also have the other abilities.

Rob