DQM and Import Wizard - Unable to see some tables

[Boksberger]

I have an issue with Framework Manager that when I try to import Data Source tables from a db2 source, only a few of the tables are shown in the import wizard.

I'm not sure what exactly is happening, as this is a bit weird:

1. JDBC has been set up, and all connectivity is ok
2. DB account is able to SELECT * FROM all tables that I want, but they are not shown in the import wizard.
3. DB account has been provided read access to the SYSIBM tables for importing.
4. Some tables do show in the import wizard, but the list is not comprehensive.
5. If I change the project to CQM, all tables return fine.

[MFGF]

I have an issue with Framework Manager that when I try to import Data Source tables from a db2 source, only a few of the tables are shown in the import wizard.

I'm not sure what exactly is happening, as this is a bit weird:

1. JDBC has been set up, and all connectivity is ok
2. DB account is able to SELECT * FROM all tables that I want, but they are not shown in the import wizard.
3. DB account has been provided read access to the SYSIBM tables for importing.
4. Some tables do show in the import wizard, but the list is not comprehensive.
5. If I change the project to CQM, all tables return fine.

Hi,

What are the Catalog and Schema properties set to in the data source connection in FM? My guess is you are only seeing a single schema?

Cheers!

MF

[Boksberger]

MF,

The issue was that the table comment has a non-ascii character in it. It was showing as an arrow instead of an apostrophe. It's a little weird, and likely an artifact from the modeling tool we're using.