Release Notes

50.9 Federated Systems Restrictions

Following are restrictions that apply to federated systems:

• The Oracle data types NCHAR, NVARCHAR2, NCLOB, and BFILE are not supported in queries involving nicknames.
• The Create Server Option, Alter Server Option, and Drop Server Option commands are not supported from the Control Center. To issue any of these commands, you must use the command line processor (CLP).
• For queries involving nicknames, DB2 UDB does not always abide by the DFT_SQLMATHWARN database configuration option. Instead, DB2 UDB returns the arithmetic errors or warnings directly from the remote data source regardless of the DFT_SQLMATHWARN setting.
• The CREATE SERVER statement does not allow the COLSEQ server option to be set to 'I' for data sources with case-insensitive collating sequences.
• The ALTER NICKNAME statement returns SQL0901N when an invalid option is specified.
• For Oracle, Microsoft SQL Server, and Sybase data sources, numeric data types cannot be mapped to DB2's BIGINT data type. By default, Oracle's number(p,s) data type, where 10 <= p <= 18, and s = 0, maps to DB2's DECIMAL data type.