How to: Pass Data to Parameters by Value
You can pass parameters by value throughout a program or at specific locations.
To pass parameters by value throughout a program
Precede code where you want to pass data to parameters by value with the following line of code:
SET UDFPARMS TO VALUE
Using SET UDFPARMS TO VALUE does not affect the WITH clause in the DO command, which, by default, passes arguments to parameters by reference.
For more information, see SET UDFPARMS Command.
To pass parameters by value at specific locations
Enclose the variable or array name with parentheses (()) as shown in the following example:
DO myProcedure WITH (myVar), (myVar2)