467,114 Members | 1,350 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,114 developers. It's quick & easy.

generated columns for z/os

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

Mar 10 '06 #1
  • viewed: 2366
Share:
2 Replies
Steamroller wrote:
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).

I just checked. Not in DB2 V8 for zOS.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Mar 10 '06 #2
Thanks. That is as I suspected.

Mar 10 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by abigblackman@gmail.com | last post: by
1 post views Thread by Frank Swarbrick | last post: by
reply views Thread by =?Utf-8?B?WmVk?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.