Reveal hidden tables when you virtualize in Watson Query
The
page automatically excludes tables from the system, tools, and application schemas of the remote sources. You can override this default by specifying a list of schemas to reveal.Symptoms
The Virtualize page does not show tables from system, known tools, or application schemas.
Resolving the problem
- Use the
CALL DVSYS.LISTRDBCDETAILS
API to determine the CID and DV agent name, labeledGDB_NODE
in the result output, under which you want to reveal some schemas (groupings of tables). - In the SQL editor, reveal schemas by using the following example API invocation.
Substitute your own details for:
- <cid>
- <agent_name>
- <schema_names>, a comma-separated list of schema names.
CALL DVSYS.SETCONFIGPROPERTY('RELOADTABLES_SCHEMAS_REVEALED_<cid>', '<schema_names>', '<agent_name>', ?, ?)
See the following example.
CALL DVSYS.SETCONFIGPROPERTY('RELOADTABLES_SCHEMAS_REVEALED_DB210041', 'SYSCAT', 'qpendpoint_1:6415', ?, ?)