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

Grzesiek

unread,

Jul 5, 2006, 3:40:22 AM7/5/06

to

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.

Thank

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

Rolf P Mittag

unread,

Jul 5, 2006, 3:56:34 AM7/5/06

to

Hi,

> Coded character set ID: 65535

65535 = FFFF = no coded character set

change this to a valid character set because "no character set" can't be
converted.

HTH
R.

Grzesiek

unread,

Jul 5, 2006, 4:09:08 AM7/5/06

to

Hej Rolf,

> change this to a valid character set because "no character set" can't be
> converted.

Thanks for your fast reply.

The problem is I can't change any value on AS400 :-( , but I can chnage everything on Linux.
Thanks again

Rolf P Mittag

unread,

Jul 5, 2006, 4:09:37 AM7/5/06

to

2 thoughts :

1)
in Client Acces Data Transfer (Windows) there's an option somewhat like
"force 65535 conversion".

Maybe you can find something similar in DB2 CLI?

2)
you can try to change the servicing jobs CCSID on the AS/400 with a
remote command

HTH
R.

BTW: I allways tell people to change the CCSID to a valid one.

Dr.UgoGagliardelli

unread,

Jul 5, 2006, 4:30:09 AM7/5/06

to

Grzesiek wrote:
> Hej Rolf,
>
>
>> change this to a valid character set because "no character set" can't be
>> converted.
>
> Thanks for your fast reply.
>
> The problem is I can't change any value on AS400 :-( , but I can chnage everything on Linux.
> Thanks again
>

If you cannot change CCSID then you cannot access data too. Unless you
access the db without any convertion.

--
Dr.Ugo Gagliardelli,Modena,ItalyCertifiedUindoscrasherAñejoAlcoolInside
Spaccamaroni andate a cagare/Spammers not welcome/Spammers vão à merda
Spamers iros a la mierda/Spamers allez vous faire foutre/Spammers loop
schijten/Spammers macht Euch vom Acker/Spamerzy wypierdalac'

Jonathan Bailey

unread,

Jul 5, 2006, 6:03:28 AM7/5/06

to

In my mind i think of 65536 as being binary only so you will have to do
all your conversion on the linux machine I think, if only you can get
at the data. Maybe you can create some temporary files on the 400 with
the fields you need to extract in a better CCSID, extract into those
files & retreive that data from the 400?

Jonathan.

Kent Milligan

unread,

Jul 5, 2006, 12:09:22 PM7/5/06

to

If you have character columns defined with CCSID 65535, you really need to think
about changing them.

You might look at the Distributed Database Programming Guide online to see if
there are any tips for dealing with 65535 data:
ibm.com/iseries/db2/books.html

--
Kent Milligan
ISV Enablement - System i
km...@us.eye-bee-m.com (spam trick) GO HAWKEYES!!
>>> ibm.com/iseires/db2
(opinions stated are not necessarily those of my employer)

Grzesiek

unread,

Jul 6, 2006, 6:34:11 AM7/6/06

to

Hey everybody!

I solved this problem :-)
I used UnixODBC + iSeries ODBC for Linux, and in iSeries ODBC there is option to convert binary data to car data.

Thanks for your help and advices.

All the best

René H. Hartman

unread,

Jul 6, 2006, 10:37:03 AM7/6/06

to

Good for you! However, CCSID is really the way to go. What's your OS
version?
The thing is that it all changed with V5R3, so if you're not at V5R3 (or
higher) yet, you may see the same problem when you upgrade your OS.

--
Best regards,

René H. Hartman
www.hac-maarssen.nl

"Grzesiek" <sc...@poczta.onet.pl> schreef in bericht
news:e8ioih$dc2$1...@news.onet.pl...

Grzesiek

unread,

Jul 7, 2006, 1:22:55 AM7/7/06

to

Hej René,

> What's your OS version?

05.03.0001