How to execute an introspected Microsoft SQL Server stored procedure in TIBCO Data Virtualization Studio?
Article ID: KB0076172
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 7.0 and higher |
Description
How to execute an introspected Microsoft SQL Server stored procedure in TDV Studio?
Issue/Introduction
How to execute an introspected Microsoft SQL Server stored procedure in TIBCO Data Virtualization Studio?
Resolution
Below are the steps, using the standard Microsoft stored procedure sp_help as an example.
(1) Introspect the stored procedure (e.g. sp_help).
(2) Open the procedure.
(3) Select the checkbox next to Design mode.
(4) Click on the Design By Example icon.
(5) In the Input dialog that pops up, enter the input (e.g. INFORMATION_SCHEMA.COLUMNS)
(6) A dialog will pop up, displaying the CURSOR parameters needed to return the result set. Click on the OK button in the dialog.
(7) Save the change.
(8) Execute the procedure. A results panel will appear. Click on the Display button in the panel to view the result set.
The screenshot below shows the steps.
(1) Introspect the stored procedure (e.g. sp_help).
(2) Open the procedure.
(3) Select the checkbox next to Design mode.
(4) Click on the Design By Example icon.
(5) In the Input dialog that pops up, enter the input (e.g. INFORMATION_SCHEMA.COLUMNS)
(6) A dialog will pop up, displaying the CURSOR parameters needed to return the result set. Click on the OK button in the dialog.
(7) Save the change.
(8) Execute the procedure. A results panel will appear. Click on the Display button in the panel to view the result set.
The screenshot below shows the steps.
Feedback
Yes
No
Powered by
