Skip to Content
0

Cross-query DB on MaxDB

Apr 09 at 09:01 AM

26

avatar image
Former Member

Hi,

we have a MaxDB database and we want to create a view with join that involves two tables belonging to different databases (but within the same instance).
Is it possible on MaxDB? what is the syntax / commands to do this?

Thanks.

Davide

SQL
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

James Zhang
Apr 10 at 01:04 AM
0

Hi Davide,

It is not possible to do this on maxdb, like oracle dblink.

You have to consider the migrate/export the table to the same database, or you can write abap code via open sql to try to achieve this.
Because netweaver can use dbco to connect different database, which means you have possibility to access to different database.

Best regards,
James

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Apr 10 at 08:03 AM
0

Hi James,
thanks for the support.

Best Regards.

Davide


Share
10 |10000 characters needed characters left characters exceeded