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:
В Copy Code SET UDFPARMS TO VALUE
Note: |
---|
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:
В Copy Code DO myProcedure WITH (myVar), (myVar2)