- Though the ODBC operator supports multiple instances, if the schema has at least one deferred mode LOB column defined, the ODBC Operator uses only one instance to do the data fetch. So for better performance with the LOB types, it is advised to use only one instance.
- The ODBC operator also supports the usage of multiple LOB columns in the schema. Also you can use a combination of inline and deferred columns in the schema.
- The ODBC operator supports inline LOBs up to the max size for the LOB.
- The ODBC operator supports enhanced LOB functionality.
For more information, see Enhanced LOB Support.