Problems with code page

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Burkhard Schultheis - 13 May 2005 14:39 GMT

I have created a (German) database with "Using Codeset ISO8859-1
territory DE". Now when I'm importing from an ixf file, I get sometimes

SQL3050W Conversions on the data will be made between the IXF file code
page "923" and the application code page "819".

and sometimes "... page 1208".

Why I get different numbers for the application code page? I think the
application is the import utility. Why does it not take the databases
code page, which is 819? And what determines the code page of the import
utility?

Regards,

Signature

Burkhard Schultheis
Tele Data Electronic, Wagnerstr. 10, D-76448 Durmersheim
Email: schultheis@tde-online.de
Phone: +49 7245 9287-21

Reply to this Message

Burkhard Schultheis - 13 May 2005 15:50 GMT

Burkhard Schultheis schrieb:

> I have created a (German) database with "Using Codeset ISO8859-1
> territory DE". Now when I'm importing from an ixf file, I get sometimes
[quoted text clipped - 8 lines]
> code page, which is 819? And what determines the code page of the import
> utility?

I forgot: DB2 V8.2 FP7a on SuSE Linux 9.3, Intel.

Regards,

Signature

Burkhard Schultheis
Tele Data Electronic, Wagnerstr. 10, D-76448 Durmersheim
Email: schultheis@tde-online.de
Phone: +49 7245 9287-21

Reply to this Message

Gregor =?ISO-8859-2?Q?Kova=E8?= - 31 May 2005 10:54 GMT

Try the following:
export DB2CODEPAGE=819
do the export
on the other mashine do export DB2CODEPAGE=819
do the import

export and import utilities use the codepage that is set on the client
machine.

Hope this helps.

Best regards,
Kovi

> Burkhard Schultheis schrieb:
>> I have created a (German) database with "Using Codeset ISO8859-1
[quoted text clipped - 13 lines]
>
> Regards,

Reply to this Message