How to view column attribute definitions using a query?
book
Article ID: KB0076956
calendar_today
Updated On:
Products
Versions
TIBCO Data Virtualization
7.0.x and higher
Description
How to view column attribute definitions using a query?
Resolution
The system table /services/databases/system/ALL_COLUMNS can be queried. Before querying the systems table, the resource whose column attributes you wish to view should be published.
Example Let us say that I have an introspected an Oracle table '/users/composite/admin/DATASOURCES/ora_ds/JOE/EMPLOYEE', and I want to see the definitions of the columns in the table.
(1) Publish the table (e.g. as /services/databases/examples/EMPLOYEE) (2) Run a query on ALL_COLUMNS, and filter the results on TABLE_NAME as shown below:
------------ SELECT * from /services/databases/system/ALL_COLUMNS where DATASOURCE_NAME like '%examples%' and TABLE_NAME = 'employee' ------------
Issue/Introduction
How to view column attribute definitions using a query?