Information Server: iSeries ODBC error

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:

(0 users)Average rating

Add comments

Document information


More support for:

InfoSphere Information Server

Software version:

8.1, 8.1.0.1, 8.1.0.2, 8.5, 8.5.0.1, 8.5.0.2, 8.5.0.3, 8.7, 8.7.0.1

Operating system(s):

AIX, HP-UX, Linux, Solaris

Reference #:

1596645

Modified date:

2012-11-30

Translate my page

Machine Translation

Content navigation