I am trying to connect to an Iseries DB2 UDB database from a Linux DB2
UDB database with no luck.
The error message is:
db2 => connect to AS400_NAME user MY_USER_PROFILE using MY_PASSWORD
SQL0332N There is no available conversion for the source code page "923" to
the target code page "UNKNOWN". Reason Code "1". SQLSTATE=57017
I have tried to connect to 2 different Iseries both running V5R2 and
each return this same error.
I have set the CCSID for my user profile and the system value both to
37. In this news group I have found several references to similar
errors that also recommend setting the CCSID of the job, but I'm
not sure how to do this.
The Linux box is a RH 7.3 using DB2 UDB V8 ESE from the Linux Software
Evaluation Kit 2Q 2003.
Any/All help will be appreciated.