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
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.