Share via


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 
    

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