- The Update, Stream and Inserter operators can all load LOB/JSON/XML in inline mode on all platforms.
The Stream operator can load CLOB/BLOB/JSON/XML in inline mode 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. Deferred LOB/XML/JSON is not supported because data sets are not assigned to the LOB, XML, and JSON files.
When the job is loading 1 or more deferred LOB/JSON/XML columns, the largest possible pack factor is 4096 because the database can support up to 4096 spool files per request.
- TPT does not support the ST_Geometry data type in the TPT schema. But, the Stream 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.