467,200 Members | 1,009 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

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

DB2CODEPAGE Variable

I am trying to get a better understanding of client side settings,
particularly DB2CODEPAGE.

I have a back-end remote unix db that is UTF-8 (1208). On my remote
clients, I see that my data loads(inserts) behave properly by setting
DB2CODEPAGE=1208 on the cleint side. Prior to setting this, I assumed
that the client machine's 'locale' would dictate behaviour. Apparently
not.

Can someone shed some light on the following -

1. What is the difference in using the "export DB2CODEPAGE=1208"
versus "db2set DB2CODEPAGE=1208", when setting this on the remote
client side ? Is one preferred over the other. Any behavior
differences ?

2. For the remote client, Is there a similar variable for db2cli.ini
file and should I set that as well ?

3. Do I need to set this on the server side as well ?

4. How do apps that use ODBC get this information ? Is it from the
db2cli.ini file ?

Apr 27 '06 #1
  • viewed: 18324
Share:
2 Replies
1. What is the difference in using the "export DB2CODEPAGE=1208"
versus "db2set DB2CODEPAGE=1208", when setting this on the remote
client side ? Is one preferred over the other. Any behavior
differences ?

(AW) Export sets the variable only for your current shell, where the
variable was set. db2set sets the variable for all clients in the
environment where the variable was set. If you set the variable at
both levels shell value will be taken.

2. For the remote client, Is there a similar variable for db2cli.ini
file and should I set that as well ?

(AW) I'm not sure if you can set the variable at this level. To my
knowledge - no.

3. Do I need to set this on the server side as well ?

(AW) DB2CODEPAGE is set only at the client. You can use the variable to
convert data to desired code pages.

4. How do apps that use ODBC get this information ? Is it from the
db2cli.ini file ?

(AW) Through local DB2 client.

-- Artur Wronski

May 5 '06 #2
Thank you for your response.

May 10 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Frederik Sørensen | last post: by
134 posts views Thread by James A. Donald | last post: by
23 posts views Thread by Russ Chinoy | last post: by
3 posts views Thread by rls03 | last post: by
1 post views Thread by rajivblr@gmail.com | last post: by
112 posts views Thread by istillshine@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.