Restrictions on federated three-part names

Federated three-part names are supported for relational data sources. They are not supported for any non-relational data sources.

The following restrictions also apply to federated three-part names:
  • Functions that do not support nicknames do not support federated three-part names
  • You can specify federated three-part names on supported SQL statements only. See Support and considerations for federated three-part names.
  • Statistical views are not supported
  • Materialized query tables are not supported

The following statements do not support federated three-part names:
  • ALTER TABLE
  • COMMENT
  • CREATE ALIAS
  • CREATE INDEX
  • CREATE METHOD
  • CREATE TABLE
  • CREATE VARIABLE
  • DESCRIBE TABLE
  • GRANT
  • IMPORT (as target table) LOAD
  • LOAD
  • LOCK TABLE
  • RENAME
  • REVOKE
  • Statements with extended indicator variables