How to select the table from other schemas with DB2 UDB database when database login user does not own any tables
Article ID: KB0078093
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for Database | 7.2.0 |
Description
When database login user does not own any tables and the TIBCO ActiveMatrix Adapter for Database wants to use the tables from other schemas (excluding default schema).In this case, the schema select wizard of ADB adapter business studio first retrieves the list of tables either from the database login user or default schema. Then the list of tables returned and it provides an option in order to select tables from other schema,other schema has to be different from default schema and database login user.
Currently the TIBCO ActiveMatrix(R) Adapter for Database (TIBCO Business Studio(TM)) 1.3.0 will exit the schema select wizard when there is no table list retrieved from either the database login user or default schema.
Currently the TIBCO ActiveMatrix(R) Adapter for Database (TIBCO Business Studio(TM)) 1.3.0 will exit the schema select wizard when there is no table list retrieved from either the database login user or default schema.
Issue/Introduction
How to select the table from other schemas with DB2 UDB database when database login user does not own any tables
Environment
Product: TIBCO ActiveMatrix Adapter for Database
Version: 7.2.0
Product: TIBCO ActiveMatrix(R) Adapter for Database (TIBCO Business Studio(TM))
Version: 1.3.0
OS: All Supported Operating Systems
Resolution
In order to resolve this issue user can provide a default schema which owns tables and different from the other schema.If the default schema is not available then provide the system schema in default schema field and select the table from other schemas so that the adapter will execute the query with schema.table_name.
Feedback
Yes
No
Powered by
