'get db cfg for database'

Then look at the codepage/codeset.

Rgds.

-----Original Message-----
From: SlowJoe
[mailto:db2udbdba-ezmlmshield-x5362632.[Email address protected]
Sent: 25 October 2004 11:02
To: LazyDBA Discussion
Subject: Verify character encoding of database

Hi there,

I need to connect to a DB2 database, which is required to be UNICODE
enabled. Usually, it is created like this:

db2 CREATE DATABASE testdb USING CODESET UTF-8 TERRITORY us

Unfortunately, it is not me, who creates the database. I have to rely on

the database admins to create it correctly.

Now, I would like to verify the database settings. Is there another way
than putting UNICODE encoded strings into a test table and query them
afterwards to see, whether the strings are still the same?

I looked through the SQL Reference Appendix D, where the catalog views
are described... I did not find any related view.

JDBC database metadata does not give me any evidence either.

If you can give me an advice, I would greatly appreciate it.

Thanks,

Johannes


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




************************************************************************

If you have received this e-mail in error, please delete it and notify the sender as soon as possible. The contents of this e-mail may be confidential and the unauthorized use, copying, or dissemination of it and any attachments to it, is prohibited.

Internet communications are not secure and Hyperion does not, therefore, accept legal responsibility for the contents of this message nor for any damage caused by viruses. The views expressed here do not necessarily represent those of Hyperion.

For more information about Hyperion, please visit our Web site at www.hyperion.com

DB2 & UDB email list listserv db2-l LazyDBA home page