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

Steamroller wrote:[color=blue]
> 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).[/color]
I just checked. Not in DB2 V8 for zOS.

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

Thanks. That is as I suspected.