Oracle Error ORA-34145: (MXCGPUT03) You cannot use the APPEND keyword with SURROGATE workspace object.

Oracle Error Message

ORA-34145: (MXCGPUT03) You cannot use the APPEND keyword with SURROGATE workspace object.

Reason for the Error

User used the APPEND keyword on a SURROGATE target in a FILEREAD, SQL FETCH or SQL SELECT command.

Solution

To assign a value to a SURROGATE in a FILEREAD, SQL FETCH or SQL SELECT command, use the ASSIGN keyword.