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