INSERT, UPDATE, and DELETE statements and large objects (LOBs)

You can perform read operations on remote LOBs on federated systems. Write operations on LOBs are supported for some data sources.

With federation you can perform read operations on LOBs that are located in any relational data source. You can perform write operations on LOBs that are located in the following data sources:
  • Oracle, using the NET8 wrapper
  • Db2® for z/OS®, Db2 for IBM® i, and Db2, using the DRDA wrapper
  • Teradata, using the Teradata wrapper
Under certain conditions, you can perform write operations on LOBs in other data sources by altering the nickname column type to a VARCHAR.