Executing Stored Procedures and Functions

A CALL statement executes existing collections of statements. When you create a CALL statement, the Statement Builder adds the parameters from the stored procedure to the CALL statement. The name of each parameter added to the CALL procedure has the format:


The value returned is stored in the parameter return_@RETURN_VALUE.

The pins on the table indicate if the parameter is an input or output parameter, as the following figure shows:

IMPORTANT: You must save and execute CALL statements in the Statement Builder before you can use them in an analysis display.

CALL statements can also make use of database results caching to reduce the load on your database server. For more information, refer to the Database Results Caching section.