How to receive results from a SQL server stored procedure?
Article ID: KB0076201
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All supported versions |
Description
How to receive results from a SQL server stored procedure?
Issue/Introduction
How to receive results from a SQL server stored procedure?
Resolution
Below are the steps, using the 'sp_help' procedure 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 'Design By Example'.
(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.
Here are annotated screenshots that illustrates 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 'Design By Example'.
(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.
Here are annotated screenshots that illustrates the steps.
Feedback
Yes
No
Powered by
