Hi Femi,
seems like we have some misunderstanding here. I do know where to find
the "cli.ini" file on my own system. However, on a customer's box it
might be located at weird places. A solution would be to retrieve the
file's location at deployment time and put an entry in some
configuration file.
However, I would prefer a "SQL based" way.
Regards,
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
>
>
> Johannes,
>
> The JAVA appliction using the database would have required an install of the
> DB2 Admin Client, if not on the same server as the database, as this will be
> required to ensure all the DB2 JDBC drivers are being used. An install of
> the this client will have created a CLI.INI file in the SQLLIB directory
> where you can specifify the UNICODE option.
>
> Femi
>
> -----Original Message-----
> From: SlowJoe
> [mailto:db2udbdba-ezmlmshield-x62250370.[Email address protected]
> Sent: Monday, October 25, 2004 1:26 PM
> To: LazyDBA Discussion
> Subject: Re: Verify character encoding of database
>
>
> 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.
>
>>
>>
>>
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
DB2 & UDB email list listserv db2-l LazyDBA home page