Valid data source objects
Nicknames identify objects at the data source that you want to access. The following table lists the types of objects that you can create a nickname for in a federated system.
| Data source | Valid objects |
|---|---|
| Db2® Database | Nicknames, materialized query tables, tables, views |
| Db2 for IBM® i | Tables, views, P/L (physical/logical) files and table types |
| Db2 for VM and VSE | Tables, views |
| Db2 for z/OS® | Tables, views |
| Informix® | Tables, views, synonyms |
| JDBC | All table types |
| MariaDB* | Tables, views |
| HANA | Tables, views |
| Greenplum | Tables, views |
| Microsoft SQL Server | Tables, views |
| Microsoft Azure* | Tables, views |
| ODBC | Tables, views |
| Oracle | Tables, views, synonyms |
| Script | Scripts |
| Sybase | Tables, views |
| Teradata | Tables, views |
| Table-structured files | Text files that meet a specific format. |
| Apache Hive* | Tables, views |
| Cloudera Impala* | Tables, views |
| SparkSQL* | Tables, views |
| Oracle* | Tables, views |
| PostgreSQL* | Tables, views |
| MySQL* | Tables, views |
* This data source can be accessed by ODBC wrapper.