How to fetch all the column names for View & Procedure in TDV
Article ID: KB0080132
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 7.0.5, 7.0.6,7.0.7, 7.0.8 |
Description
View_Column_Metadata
It provides the all the columns details for Views. This procedure accept an input parameter as table/view name with complete path and it provides all the columns details as output. Please refer below screenshots for more details:
Procedure_Column_Metadata
Please find the attachment for car files for both the procedures " View_Column_Metadata" and Procedure_Column_Metadata. You can try out with these procedures by importing the attached car files.
It provides the all the columns details for Views. This procedure accept an input parameter as table/view name with complete path and it provides all the columns details as output. Please refer below screenshots for more details:
Procedure_Column_Metadata
It provides the all the columns details for Procedures. This procedure accept an input parameter as Procedure name with complete path and it provides all the columns details as output. Please refer below screenshots for more details:
Please find the attachment for car files for both the procedures " View_Column_Metadata" and Procedure_Column_Metadata. You can try out with these procedures by importing the attached car files.
Issue/Introduction
We have AS utilities that provide the details about columns for View & Procedures. We have written a wrapper (View_Column_Metadata, Procedure_Column_Metadata) on those utilities to simplifies it.
Feedback
Yes
No
Powered by
