can the technique I have seen here and elsewhere to solve the
case-insensitive search problem with db2 be implemented in z/os?
for example...
alter table individual
add column up_lname
generated always as
(upper(lname));
Then I should be able to do case insensitive searches and use an index
(well, if one is there on up_lname).
Thanks
Serge Rielau - 10 Mar 2006 16:26 GMT
> can the technique I have seen here and elsewhere to solve the
> case-insensitive search problem with db2 be implemented in z/os?
[quoted text clipped - 7 lines]
> Then I should be able to do case insensitive searches and use an index
> (well, if one is there on up_lname).
I just checked. Not in DB2 V8 for zOS.
Cheers
Serge

Signature
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Steamroller - 10 Mar 2006 16:31 GMT
Thanks. That is as I suspected.