- The Update operator can load CLOB/BLOB/JSON/XML in inline and deferred modes on all non-z/OS platforms.
- On z/OS, the operator can load CLOB/BLOB/JSON/XML in inline mode if the size is less than or equal to 64,000 bytes. It cannot load CLOB/BLOB/JSON/XML in deferred mode.
- TPT does not support the ST_Geometry data type in the TPT schema. But, the Update operator can load data to ST_Geometry columns if the job specifies CLOB or BLOB in the TPT schema.
- UDT data can be loaded in its external type format.
- Error and Work Tables
The table names for the ErrorTable1, ErrorTable2, and WorkTable attributes must be new tables unless you are restarting a paused Update operator job.