cancel
Showing results for 
Search instead for 
Did you mean: 

Query to external database on SQL command Editor

former_member236871
Discoverer
0 Kudos

Hi, all

In SQL command Editor of t-code DB02, is it possible to query external DBMS using DBCO information?

Plus,

I know SQL Command Editor does not support open SQL but native SQL. Is it true?

Best Regards

Accepted Solutions (0)

Answers (1)

Answers (1)

lbreddemann
Active Contributor
0 Kudos

> In SQL command Editor of t-code DB02, is it possible to query external DBMS using DBCO information?

Nope.

> Plus,

> I know SQL Command Editor does not support open SQL but native SQL. Is it true?

Yes - it's the native SQL dialect of the main database the system is running on.

In addition to that, only SQL SELECT commands are allowed that access the database dictionary tables/views.

The whole thing is designed to be an option for problem analysis when the predefined monitors of DBACOCKPIT don't cover what you want or need to see.

It's not, in no way meant to be a free-form SQL editor to access business data.

regards,

Lars