How to push data from a view to a database table in TIBCO Data Virtualization?
Article ID: KB0074777
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 8.1 and later |
Description
This article provides details on how to push data from a View to a database table in TIBCO Data Virtualization.
Environment
All supported Operating Systems
Resolution
This can be achieved within a SQL Script by adding the below block of code:
CREATE TABLE <path to destination table> AS SELECT * FROM <view>
Here is an example which pushes data from the view 'ViewOrder' into a new table 'customer_details':
CREATE TABLE <path to destination table> AS SELECT * FROM <view>
Here is an example which pushes data from the view 'ViewOrder' into a new table 'customer_details':
PROCEDURE PushData() BEGIN CREATE TABLE /shared/examples/ds_inventory/tutorial/customer_details AS SELECT CustomerContactFirstName, CustomerContactLastName, CustomerContactPhone FROM /shared/examples/ViewOrder; ENDScreenshot for reference:
Issue/Introduction
How to push data from a view to a database table in TIBCO Data Virtualization?
Feedback
Yes
No
Powered by
