Cross-query DB on MaxDB

[former_member273013]

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

[former_member273013]

Hi James,
thanks for the support.

Best Regards.

Davide

[JamesZ]

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