Skip to Content
avatar image
Former Member

Cross-query DB on MaxDB

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 10 at 01:04 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 10 at 08:03 AM

    Hi James,
    thanks for the support.

    Best Regards.

    Davide


    Add comment
    10|10000 characters needed characters exceeded