Variables Function

The $Variables (or $Vars) function resolvers the column references and variables (if applicable. Please refer to the data generation software's manual for details) in the provided pattern string.
The only mandatory parameter is source pattern.

Notation

  • @n means reference to column #n. Example: @2 means the second column value.
  • @'name' means reference to column 'name'. Example: @'ID' means ID column value.
  • @name means reference to global variable 'name'. Example: @year refers to variable 'year'
  • #name means reference to local variable 'name'.

Notes

  • There is no additional quotation is required if the pattern contains ',' signs.
  • The engine calculates this function only once before execution even referred by '@' or '@@' column has been changed.

Examples

$Query($Vars(select OrderID from Orders where CustomerID=@1 and OrderNo=#number))