Skip to content

Can't import tables from a schema in DB2 #17

@janzamojski

Description

@janzamojski

When trying to either create an ERD containing tables or to import tables into an existing ERD from a DB2 database the schema name, although specified, seems to default to the name of the user that logs on to the database. The "Load Tables" button works correctly, i.e. the tables are loaded from the specified schema but if I select one or more and click the "Finish" button, I get a com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, which indicates that the table doesn't exist in the schema named after the database user. This is obviously true, because the table lives in the schema that I specified in the GUI but somehow this doesn't get recognized.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions