I need to retrieve the configuration information from within a Java
application. Although, there is the requirement to have the
"db2java.zip" file on the class path in order to access the DB2 JDBC
driver, the application does not know, where DB2 is installed.

Thanks for your help,

Johannes



Bello Femi wrote:
> **A LazyDBA.com subscriber has responded to your lazydba.com post**
> **LazyDBA.com mail shield has forwarded you this email,
> **and removed any attachments, and kept your email address secret
> **from this person, and any viruses/trojans.
> **If you reply to this email, the person will see your email address as normal
> **Anything below this line is the original email text
>
>
>
> The UNICODE settings are defined on the client side, you can add an entry on
> the CLI.INI file to enable unicode.
>
> Femi
>
>
>
>
>
> -----Original Message-----
> From: SlowJoe
> [mailto:db2udbdba-ezmlmshield-x5362632.[Email address protected]
> Sent: Monday, October 25, 2004 11:02 AM
> 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
>
>
> This e-mail (and any attachments) may contain privileged and/or confidential information. If you are not the intended recipient please do not disclose, copy, distribute, disseminate or take any action in reliance on it. If you have received this message in error please reply and tell us and then delete it. Should you wish to communicate with us by e-mail we cannot guarantee the security of any data outside our own computer systems. For the protection of Legal & General's systems and staff, incoming emails will be automatically scanned.
>
> Any information contained in this message may be subject to applicable terms and conditions and must not be construed as giving investment advice within or outside the United Kingdom.
>
> Legal & General Group PLC, Temple Court, 11 Queen Victoria Street, London, EC4N 4TP.
> Registered in England no: 1417162
>
> Legal & General Group Plc is a holding company, subsidiary undertakings of which are fully authorised as appropriate under the Financial Services and Markets Act in respect of their investment activities in the UK.
>
>
>
>

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