Lower case fields

anandinmainframe · Active User Joined: 31 May 2007 Posts: 171 Location: India

Hi All,
How can we fetch a field with the lower case
for eg: 12566t,12376y,15r896 etc ....... that value can be anywhere from 1 to 6.
This field has been defined as CHAR.

enrico-sorichetti · Posted: Thu Jun 25, 2009 9:11 am

for a char field the content case is irrelevant,
if You use it in a where clause just fill the comparison operand with the proper lower case chars, nothing else
db2, or any other dbms, or access method, do not care about content

dick scherrer · Posted: Thu Jun 25, 2009 9:17 am

Hello,

Accessing these values in db2, vsam, or some other access method should not be an issue (as Enrico mentioned).

Getting the value from the user to use in a query will need to be dealt with. You need to make sure that however these values are entered, they are not automatically switched to upper case.

anandinmainframe · Active User Joined: 31 May 2007 Posts: 171 Location: India

Enrico,
Thanks for the reply.
Actually those fields are in the database and they were stored in the database with lower case but it should be a Higher case.
for eg Y as y. so i want to retrieve all the records which has the lower case instead of Higher case.

dick scherrer · Posted: Thu Jun 25, 2009 9:24 am

Hello,

You might consider unloading the table(s), correcting the case problem in the qsam file(s), and then reloading the corrected data.