Setting Transaction Options for a Procedure
You can force Studio to ensure consistent execution results for a given set of input parameter values (variant). If the procedure is executed more than once for a variant, it returns the result set from the first execution. Results from these procedure variants are valid only for the lifetime of a transaction unless caching is enabled.
Note: When transaction procedure caching is enabled, results are cached until the transaction is completed. This can affect performance if the procedure results are unusually large or the transaction remains unresolved for a long time.
Studio also minimizes repeated calls to the data source—for example, if a procedure has an input parameter like this:
getAccountHistory(IN acctNum INTEGER, OUT results CURSOR)
If you call this procedure for the first time in a transaction with a given input value, the procedure runs as usual. If you call the same procedure again with the same input value in the same transaction, Studio returns the results of the previous call instead of re-executing the procedure.
To set transaction options
1. On the Info tab of the procedure definition, check the box labeled Execute only once per transaction for each unique set of input values to ensure consistent results during a single execution.