Upper case conversion of data in DB2 tables

udaynimje · Posted: Sat Mar 31, 2007 3:53 pm

while creating a table in ispf caps lock was off and i entered some values(* so all records in table are in lower case.)
when i am trying to update table with caps on records are unidentified sql code is -100

i didn't know that db2 is case sensitive. now how to convert all records in table in upper case.

i want to know how to convert all records either in upper case or lower case.

William Thompson · Posted: Sat Mar 31, 2007 3:57 pm

How many records?
Where are these records located?

dick scherrer · Posted: Sat Mar 31, 2007 10:13 pm

Hello,

If you unload the table(s) you can translate easily in batch. After translation, reload the data.

udaynimje · Posted: Sun Apr 01, 2007 5:13 pm

actually i am completing my training in an institute. table is very small 5 attributes and around 60 rows out of which 20 records are in lower case.
Unloading and loading is good option but can we do it using any sql query.

William Thompson · Posted: Sun Apr 01, 2007 5:24 pm

Have you looked at The UPPER function?

dick scherrer · Posted: Sun Apr 01, 2007 8:51 pm

Hello,

If any part of the "key" data is lower case, you will be ahead to "fix" the data outside of the database. Depending on the table definition, you may not be able to fix in place.

Good luck

Phrzby Phil · Posted: Mon Apr 02, 2007 6:19 pm

You say you didn't know DB2 was case sensitive.

For any language, you must distinguish between how it processes its commands and variable or field names (or "columns" in DB2), from how it handles its (i.e., your) data.

It may be case insensitive for the former, but you'd surely want it to store your data in upper or lower as you input it.