where the following is true:
- cname
- Column whose value is to be replaced by the value of expr
- The column named must not be a column of the primary index.
- expr
- Expression whose resulting value is to replace the current value of the identified column
- The expression can contain any combination of:
- Constants
- Current values of columns of the referenced row
- Values from fields of input data records
- tname
- Table or view to be updated
- This table was previously identified as tname1 in the BEGIN MLOAD command.
- If tname is not explicitly qualified by database name, the current default database qualifies it.
- WHERE condition
- Conditional clause that specifies the row or rows to be updated
- The conditional clause can use values from fields of input data records by referring to their field names.