IBM Support What's New?

SQL0401N when inserting special characters into Oracle database using Infosphere Federation Server

Technote (FAQ)


Question

Why is SQL0401N received when trying to insert special characters into an Oracle database through a nickname in Federation Server?

Cause

This could be due to the Oracle database being code page AL32UTF8 and the Federation database being a non-UTF code page.

Answer

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

Document information

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: 2014-06-29