SQL0401N when inserting special characters into Oracle database using Infosphere Federation Server
Why is SQL0401N received when trying to insert special characters into an Oracle database through a nickname in Federation Server?
This could be due to the Oracle database being code page AL32UTF8 and the Federation database being a non-UTF code page.
If SQL0401N is received when trying to insert special characters into an Oracle database using a nickname in Federation Server, check the code pages. If the Oracle database has code page AL32UTF8 and the Federation Server database has a non-UTF code page such as ISO8859-1, then do one of the following to resolve this issue.
Option 1: add NLS_LANG=UTF-8 in db2dj.ini
Option 2: create a UTF-8 codeset federated DB
Option 3: If a Federated database with a non-UTF code page is needed, create 2 instances. one instance with federated DB with the non-UTF codeset(same as current), another with fed DB as UTF8 codeset
More support for:
InfoSphere Federation Server
Data Sources and Wrappers - Oracle
Software version: 9.1, 9.5, 9.7
Operating system(s): AIX, HP-UX, Linux, Solaris, Windows
Software edition: All Editions
Reference #: 1439345
Modified date: 29 June 2014