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


Rate this page:

(0 users)Average rating

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, Linux Red Hat - zSeries, Linux SUSE - zSeries, Linux x86, Solaris, Windows

Software edition:

All Editions

Reference #:

1439345

Modified date:

2012-12-14

Translate my page

Machine Translation

Content navigation