Data source support for nested-table-expressions for error tolerance

Error tolerance is supported for several relational data sources and for nonrelational nicknames.

Error tolerance in nested-table-expressions is supported for the following relational data sources:
  • Db2® family (DRDA)
  • Informix®
  • JDBC
  • Microsoft SQL Server
  • ODBC
  • Oracle (NET8)
  • Sybase (CTLIB)
  • Teradata

You can use non-relational nicknames within nested-table-expressions for error tolerance. The federated server can tolerate the allowable connection, authentication, or authorization errors when the non-relational wrappers return a permissible error code.