A simple example of a Procedure that queries a table and returns all the rows
Article ID: KB0082288
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | v 7.0.0 and higher |
Description
Below is a simple example of a procedure that will query a table or a view, and return all the rows. You can replace '/shared/examples/ds_inventory/tutorial/products' with your own table.
PROCEDURE pQuery(OUT result CURSOR )
BEGIN
OPEN result FOR
SELECT * FROM /shared/examples/ds_inventory/tutorial/products ;
END
PROCEDURE pQuery(OUT result CURSOR )
BEGIN
OPEN result FOR
SELECT * FROM /shared/examples/ds_inventory/tutorial/products ;
END
Issue/Introduction
A simple example of a Procedure that queries a table and returns all the rows
Feedback
Yes
No
Powered by
