How to consume a published Packaged Query in TIBCO Data Virtualization from a Client tool?
Article ID: KB0072195
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All supported versions |
Description
A packaged query is published as a procedure and not as a view/table. Therefore running a SELECT statement against a procedure will not fetch the records and will result in an error, hence a procedure call needs to be made.
Issue/Introduction
This article states how to consume a published packaged query from a JDBC client tool like DbVisualizer.
Environment
All supported environment
Resolution
- The user needs to publish a packaged query in TIBCO Data Virtualization if the user wants to consume the packaged query from a third-party client like DbVisulizer which is a JDBC client tool.
- Once published, create a connection with the DbVisualizer to consume the resource.
- Open a connection to the database created in the DbVisualizer and then go to the query editor and write the below command to access the published packaged query:
- Once published, create a connection with the DbVisualizer to consume the resource.
- Open a connection to the database created in the DbVisualizer and then go to the query editor and write the below command to access the published packaged query:
EXEC <packagedQuery>
Additional Information
Feedback
Yes
No
Powered by
