Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Lower case fields

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
anandinmainframe

Active User


Joined: 31 May 2007
Posts: 171
Location: India

PostPosted: Thu Jun 25, 2009 9:07 am    Post subject: Lower case fields
Reply with quote

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.
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Thu Jun 25, 2009 9:11 am    Post subject: Reply to: Lower case fields
Reply with quote

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
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Jun 25, 2009 9:17 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
anandinmainframe

Active User


Joined: 31 May 2007
Posts: 171
Location: India

PostPosted: Thu Jun 25, 2009 9:18 am    Post subject: Reply to: Lower case fields
Reply with quote

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.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Jun 25, 2009 9:24 am    Post subject:
Reply with quote

Hello,

You might consider unloading the table(s), correcting the case problem in the qsam file(s), and then reloading the corrected data.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Validate date and numeric fields and ... Rick Silvers DFSORT/ICETOOL 6 Thu May 11, 2017 6:51 pm
No new posts Sum Fields ballaswaroop DFSORT/ICETOOL 4 Tue May 02, 2017 11:07 am
No new posts DFSORT MUL FIELDS tspr52 DFSORT/ICETOOL 16 Fri Mar 03, 2017 11:53 pm
No new posts VALIDATE NULL VALUE IN DB2 CASE STATE... useit DB2 5 Thu Feb 09, 2017 4:34 pm
No new posts Sort two file having same field, one ... himanshu malik DFSORT/ICETOOL 7 Thu Feb 02, 2017 10:09 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us