Technote (troubleshooting)
Problem(Abstract)
When importing ODBC table definition using iSeries ODBC driver get error messages and an empty list of table to import.
For example using the following DSN entry defined in $DSHOME/.odbc.ini file on Linux:
[DEVNEW_IBM]
Description=iSeries Access ODBC Driver DSN for iSeries
Driver=/opt/ibm/iSeriesAccess/lib64/libcwbodbc.so
System=xxxxxx
Setup=/opt/ibm/iSeriesAccess/lib64/libcwbodbcs.so
Driver64=/opt/ibm/iSeriesAccess/lib64/libcwbodbc.so
Setup64=/opt/ibm/iSeriesAccess/lib64/libcwbodbcs.so
Threading=2
...........
...........
AllowDataCompression=1
LibraryView=0
AllowUnsupportedChar=0
ForceTranslation=0
Trace=0
CCSID=62215
Cause
Set up the iSeries ODBC drivers and the results are:
1. With CCSID=62215, do not get any tables selected via import table (odbc cc or odbc plugin). Also Information Analyzer discover table results in blank list.
2. With default (CCSID=1208) get a list of tables when using either odbc cc or odbc plugin to import
the tables and Information Analyzer also shows the tables.
The problem is caused due to a mismatch between DSN setting of CCSID compared with the CCSID under schema/library on the AS400.
Check with the AS400 systems administrator to confirm what it should be set to.
Environment
Linux
Resolving the problem
odbc DSN entry requires correct CCSID, as set under schema/library.
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.