How to: Pass Data to Parameters by Value

Article
06/18/2008

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 
```

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:
```
DO myProcedure WITH (myVar), (myVar2)
```

See Also

Tasks

How to: Pass Data to Parameters by Reference

Concepts

Passing Data to Parameters