469,602 Members | 1,826 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,602 developers. It's quick & easy.

[DB2/AS 400] no available conversion for the source code page "819" ...

Hey there!
Please help me...

I've got a iSeries (AS 400 with DB2), and I must connect to this database from Linux.

On AS400 I've this settings (which I can't change):
Language: Polish
Country/region: United States of America
Default system Keyboard: United States/Canada
Coded character set ID: 65535
Graphic character set: 697
Code page: 37

Locale: None
On my Linux box I've db2 cli (Command Line Processor for DB2 SDK 8.2.0)

When I set on Linux:

export LANG=en_EN
export LC_ALL=en_EN
export LESSCHARSET=latin2

I have got a error when I try connect to my database on AS400:
"SQL0332N There is no available conversion for the source code page "819" to
the target code page "870". Reason Code "1". SQLSTATE=57017"

So I change my LANG on Linux on this:

export LANG=pl_PL
export LC_ALL=pl_PL
export LESSCHARSET=latin2

I I can connect to database, but...I CAN'T select any data, because I've got error:

"SQL0332N Brak obs?ugi konwersji danych ze ?ród?owej strony kodowej "" na
docelow? stron? kodow? "". Kod przyczyny: "". SQLSTATE=57017"

What must I set to select data from my database, please help.

Thanks

--
Pozdrawiam.
Grzesiek; scss (at) poczta.onet.pl

Jul 5 '06 #1
0 3573

This discussion thread is closed

Replies have been disabled for this discussion.

By using this site, you agree to our Privacy Policy and Terms of Use.