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