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 |
---|---|
BioRS | BioRS databanks |
DB2® Database for Linux, UNIX, and Windows | Nicknames, materialized query tables, tables, views |
DB2 for System 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 |
Microsoft Excel | .xls files (only the first sheet in the workbook is accessed) |
Microsoft SQL Server | 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. |
Web Services | Operations in a Web services description language file |
XML-tagged files | Sets of items in an XML document |