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 CodeSET 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 CodeDO myProcedure WITH (myVar), (myVar2)
js editor
Web development
Note: