Re: DB/2 Connect on an NT platform connecting to AS/400

Apparently, you have files (and/or character fields within files) defined
with CCSID 65535 (*HEX).
Basically it means "no CCSID".
Change those files to some explicit CCSID - for US it will be 37.
You may also need to change QCCSID system value to 37, so that all jobs
will start using explicit CCSID as well.

    Alexei Pytel


joberhol@compures.com on 03/22/2000 03:56:26 PM

Please respond to MIDRANGE-L@midrange.com

To:   MIDRANGE-L@midrange.com
cc:
Subject:  DB/2 Connect on an NT platform connecting to AS/400




We have Catalog Architect  (part of the Ecommerce Websphere suite)  running
on an NT box the is supposed to connect to the AS/400 using DB/2 Connect.
When we try to connect we get the following error message:

     [IBM][CLI Driver] SQL0332N There is no available conversion for the
source code page "65535" to the target code page "1252". Reason Code "1".
SQLSTATE=57017

Additional information yields:

OS/400 users should be aware that AS/400 CCSID 65535 is not
supported. AS/400 data encoded using CCSID 65535 must be
converted to a supported CCSID before it can be accessed using
DB2 Connect.

Has anyone run into this with DB/2 Connect.  Any Suggestions?  IBM hasn't
got a clue what to do.  They keep bouncing between OS/400 support and NT
support with no resolution.


Thanks
Jim Oberholtzer


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---