Hi All

I am new to Db2. This question may be very simple.
In SQL Server I can set database option as case sensitive or
insensitive. Because of this if I set option as case insensitive than
'a'='A' or 'suResH'='SURESH'
Is there any such option in DB2 8.1 For linux. Can I set proper
collating sequence to achieve this then how?

Thanks and regards
Suresh

Suresh wrote:
> Hi All
>
> I am new to Db2. This question may be very simple.
> In SQL Server I can set database option as case sensitive or
> insensitive. Because of this if I set option as case insensitive than
> 'a'='A' or 'suResH'='SURESH'
> Is there any such option in DB2 8.1 For linux. Can I set proper
> collating sequence to achieve this then how?
There is no database wide switch in DB2.
If you have certain columns you want to treat as case-insensitive you
can take a peek at this article:
http://www-128.ibm.com/developerwork...adamache3.html
A more sophisticated version (culturally correct collation) can be found
here:
http://www-128.ibm.com/developerwork.../dm-0602doole/

The user defined collation sequences facility provided by DB2 can be
used to change the order, but it does not allow for two different glyphs
to be equal.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab