If you have to change something in the CLI Config File /DB2 Client config
setting as part of deployment then the way is to use
db2 update cli cfg .... command
Cheers..Praveen
-----Original Message-----
From: SlowJoe
[mailto:db2udbdba-ezmlmshield-x55661729.[Email address protected]
Sent: 25 October 2004 15:04
To: LazyDBA Discussion
Subject: Re: Verify character encoding of database
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
>
>
>
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
**********************************************************************
This email and any files transmitted with it are confidential and are
intended solely for the use of the individual or entity to whom they are
addressed. This communication represents the originator's personal views and
opinions, which do not necessarily reflect those of HPI Limited. If you are
not the original recipient or the person responsible for delivering the
email to the intended recipient, be advised that you have received this
email in error, and that any use, dissemination, forwarding, printing, or
copying of this email is strictly prohibited. If you received this email in
error, please immediately notify [Email address protected]
This message has been scanned by Panda Anti-Virus. Recipients are advised to
apply their own virus checks to this message on delivery.
**********************************************************************
DB2 & UDB email list listserv db2-l LazyDBA home page