How to view the SQL behind the views that are part of a CAR file without using the TIBCO Data Virtualization Studio?
book
Article ID: KB0071655
calendar_today
Updated On:
Products
Versions
TIBCO Data Virtualization
All supported versions
Description
This article lists the steps to follow to view the SQL behind the views that are part of a CAR file without using the TIBCO Data Virtualization Studio.
Resolution
A CAR file is nothing but a version of a zip file and any unzipping software to open this file (Example: 7zip). Once this CAR file is unzipped, it would list the files that hold various information related to the resource/s exported. The metadata.xml file would contain the SQL that is part of the CAR file resource.
(i) Example: view1 is a CAR file, unzipping this CAR file using a software called 7-Zip (free third party software)
(ii) Files inside the view1.car file:
(iii) Open the metadata.xml file in a notepad and search for the below tag: this tag holds the SQL that belongs to the CAR file.
<attribute name="SQL" type="STRING">
Issue/Introduction
How to view the SQL behind the views part of a CAR file without using the TIBCO Data Virtualization Studio?