Use the properties in this group to specify whether large object (LOB) columns in the Columns property are passed through the connector by using locator information. If the schema contains LOB columns and you set Enable LOB references to No, all LOB columns are passed inline. If you set Enable LOB references to Yes, only the specified columns are passed by reference. The remaining LOB columns are passed inline.
If you set Enable LOB references to Yes, the value that is passed as a locator is read from the database when the target stage runs. But, the rest of the data is read when the source stage runs. You also must set Array size to 1 if Enable LOB references is Yes.
The following IBM® InfoSphere® DataStage® data types are treated as LOBs:
LongVarBinary for database binary large object (BLOB) columns
LongVarChar and LongNVarChar for database character large object (CLOB) columns
The default value is No.