transaction to execute a database query

[Former Member]

Hello guys,

I have a sap netweaver with DB2 and I would like to run a simple query in database.

Does anybody know the Sap transaction to execute a query?

thanks.

regards,

filipe

[Former Member]

Thanks for your help. I got it. It depends on the version of dbacockpit.

For a netweaver system with basis level 14 it has an option in dbacockpit -> diagnostics -> SQL commands.

For a netweaver system with basis level 11 it hasn't any option.

Thanks guys.

regards,

Filipe

[Former Member]

Try se38->RSORADJV. It works on oracle atleast.

[Former Member]

Hi Raghu,

In my ST04 transaction it doesn't appear additional functions.

It appears:

Performance

Space

Backup and Recovery

Configuration

Jobs

Alerts

Diagnostics

I use DB2 v9.

Any help?

thanks.

Filipe

[Former Member]

Hi Filipe,

Not quite sure if its DB2.

But under Performance you should have Additional Functions. Please check and revert.

Best Regards

Raghu

[Former Member]

Hi Filipe,

You can run the query using transaction st04 -> Additinal Functions -> SQL Command Editor.

Hope this helps.

Best Regards

Raghu