Release Notes
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.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]