topic Re: Is there report or TCODE for execution of open sql SELECT query in Application Development and Automation Discussions

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

Former Member — Mon, 21 Jun 2010 14:49:44 GMT

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?

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

Former Member — Mon, 21 Jun 2010 15:30:55 GMT

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

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

Former Member — Mon, 21 Jun 2010 15:40:09 GMT

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.

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

Former Member — Mon, 21 Jun 2010 15:45:23 GMT


> 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