I have an odbc connection to an IBM db2. The tables show up in the Table tab but not in the Visual Query Builder tab.
Does anyone know how to correct this?
a. If a schema contains only views it doesn't show up in the Visual Query Builder. The schema shows up as long as there is a table in the schema. Is that your scenario?
b. Also, External tables are not showing up in the VQB. Is that your scenario?
They are showing up in the table tab but not in the VQB tab. I think they are all views. They show up in Crystal as Views. They have shown up before in the VQB tab. I don't know what changed.
@cowannbell The schema shows up as long as there is a table in the schema. Can you create a table in the schema?
I'm not quite sure what you are referring to, when you say schema.
@cowannbell DB2 Schema is a collection of named objects classify logically in the database. ... You can create multiple schemas in a database as well as multiple database objects with same name, with different schema groups. A schema can contain tables, functions, indices, tablespaces, procedures, triggers etc.
I am having the same issue with DB2. The table and schema are showing up in the 'Tables' view and I am able to access them through SQL editor. But I don't see them under the Visual Query builder. I found a few threads with the same issue with DB2.
Is this an issue isolated to DB2 from Alteryx?
Version 2023 still has the same issue. I've tried adding a schema list to the ODBC driver and it has no impact on the Visual query builder.
The schema shows up as long as there is a table in the schema. Is that your scenario?
Yes please resolve it