Function-string Variable Modifiers

Replication Server recognizes several function-string variable modifiers.

Function-string Variable Modifiers
Modifier	Description
`new`, `new_raw`	A reference to the new value of a column in a row that Replication Server is inserting or updating.
`old`, `old_raw`	A reference to the old values of a column in a row that Replication Server is inserting or updating.
`user`, `user_raw`	A reference to a variable that is defined in the input template of an rs_select or rs_select_with_lock function string.
`sys`, `sys_raw`	A reference to a system-defined variable.
`param`, `param_raw`	A reference to a stored-procedure parameter.
`text_status`	A reference to the `text_status` value for `text`, `unitext`, or `image` data. Possible values are: 0x000 – Text field contains NULL value, and the text pointer has not been initialized. 0x0002 – Text pointer is initialized. 0x0004 – Real text data will follow. 0x0008 – No text data will follow because the text data is not replicated. 0x0010 – The text data is not replicated but it contains NULL values.

Note: Function strings for user-defined functions may not use the new or old modifiers.

See Replication Server Reference Manual > Replication Server Commands > create function string for a list of system-defined variables that you can use in function-string input or output templates.