Executing a Parameterized Query
This section provides examples of executing a parameterized query, an XSLT transformation, and physical stored procedures that return scalar parameters and cursors.
When you execute a parameterized query that has input parameters, you are prompted to supply values for them.
The parameterized query used here has one input parameter (desiredProduct) and an output cursor.
To execute a parameterized query
1. Double-click to open the parameterized query, and click the Execute button in the editor.
The window opens so you can provide parameter values.
This window displays the input parameters defined for the query. The icon to the left of a parameter represents the parameter type. To see the type as text, let the cursor hover over the icon. For XML parameters you might have access to a button on the window so that you can open up an XML editor.
2. Type a value in the Value field, or check Null (if the parameter is nullable).
For this example, supply a value for the defined input parameter, desiredProduct.
3. Click OK.
When the parameterized query is executed, the product name, ID and description are displayed.
4. In the Result For result panel:
a. To view the next fifty rows in a large data set, click Next.
b. To view the details of a specific row in a Result Details dialog, select the row and click Details. To see details for an adjacent result, click Prev or Next. For some extremely large results, such as those generated by using EXTEND on an array to generate BIGINT number values, some of the data might be truncated without a visual indication by Studio.
c. To save the results, use Save to File.
d. To clear what is displayed in the tab, click Clear.
Note: Result for result appears on the tab of the Result panel because result was the name used for the output parameter in the query. If you assign a different name to the output cursor, such as productFound, the tab would show Result for productFound.
