how to config the option of char non-sensitive

[sunny]

dose DB2 can config the option of char non-sensitive.
e.g. 'Abc' = 'aBc'

[MarkN]

No. Because they don't equal. You will have to use UCase/Upper or LCase/Lower.
Reason: Probably because DB2 runs on other systems besides Windows and that
is how they work.

Mark


"sunny" <sunyu@hzcnc.com> wrote:
>
>dose DB2 can config the option of char non-sensitive.
>e.g. 'Abc' = 'aBc'

[sunny]

Oh. My god.
You see, I an working on transform MS SQL Server database to DB2.
In Ms Sql server, there are many stored procedure. and I config
the ms sql server the option of non-insensitive of char/string.

If in DB2 have to use UCase/Upper or LCase/Lower to solve the problem,
I have to rewrite these SP. It's really a big trouble. :-(


"MarkN" <m@n.com> wrote:
>
>No. Because they don't equal. You will have to use UCase/Upper or LCase/Lower.
> Reason: Probably because DB2 runs on other systems besides Windows and
that
>is how they work.
>
>Mark
>
>
>"sunny" <sunyu@hzcnc.com> wrote:
>>
>>dose DB2 can config the option of char non-sensitive.
>>e.g. 'Abc' = 'aBc'
>

[Greg Nash]

Hi,

One partial solution is to use generated columns that give themselves
the UCASE of another column..
or perhaps a trigger on insert or update of relevant fields to UCASE
them whenever set..
It all depends how you use the fields

--Greg

sunny wrote:

> Oh. My god.
> You see, I an working on transform MS SQL Server database to DB2.
> In Ms Sql server, there are many stored procedure. and I config
> the ms sql server the option of non-insensitive of char/string.
>
> If in DB2 have to use UCase/Upper or LCase/Lower to solve the problem,
> I have to rewrite these SP. It's really a big trouble. :-(
>
>
> "MarkN" <m@n.com> wrote:
>
>>No. Because they don't equal. You will have to use UCase/Upper or LCase/Lower.
>>Reason: Probably because DB2 runs on other systems besides Windows and
>>
> that
>
>>is how they work.
>>
>>Mark
>>
>>
>>"sunny" <sunyu@hzcnc.com> wrote:
>>
>>>dose DB2 can config the option of char non-sensitive.
>>>e.g. 'Abc' = 'aBc'
>>>
>

[MarkN]

You probably will have to rewrite them anyway because SPs are DB specific.
If you did anything besides pure SQL you will have to look at every one
anyway.

I avoid SPs if I can. They are a last resort for me.

Mark


Greg Nash <GregNashdb2@bigpond.com> wrote:
>Hi,
>
>One partial solution is to use generated columns that give themselves
>the UCASE of another column..
>or perhaps a trigger on insert or update of relevant fields to UCASE
>them whenever set..
>It all depends how you use the fields
>
>--Greg
>
>sunny wrote:
>
>> Oh. My god.
>> You see, I an working on transform MS SQL Server database to DB2.
>> In Ms Sql server, there are many stored procedure. and I config
>> the ms sql server the option of non-insensitive of char/string.
>>
>> If in DB2 have to use UCase/Upper or LCase/Lower to solve the problem,

>> I have to rewrite these SP. It's really a big trouble. :-(
>>
>>
>> "MarkN" <m@n.com> wrote:
>>
>>>No. Because they don't equal. You will have to use UCase/Upper or LCase/Lower.
>>>Reason: Probably because DB2 runs on other systems besides Windows and
>>>
>> that
>>
>>>is how they work.
>>>
>>>Mark
>>>
>>>
>>>"sunny" <sunyu@hzcnc.com> wrote:
>>>
>>>>dose DB2 can config the option of char non-sensitive.
>>>>e.g. 'Abc' = 'aBc'
>>>>
>>
>