By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,721 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

Problems with code page

P: n/a
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,
--
Burkhard Schultheis
Tele Data Electronic, Wagnerstr. 10, D-76448 Durmersheim
Email: sc********@tde-online.de
Phone: +49 7245 9287-21
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

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?


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

Regards,
--
Burkhard Schultheis
Tele Data Electronic, Wagnerstr. 10, D-76448 Durmersheim
Email: sc********@tde-online.de
Phone: +49 7245 9287-21
Nov 12 '05 #2

P: n/a
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 wrote:
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

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?


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

Regards,


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.