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
 

 

Upper case conversion of data in DB2 tables

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

New User


Joined: 09 Oct 2006
Posts: 6
Location: pume maharashtra India

PostPosted: Sat Mar 31, 2007 3:53 pm    Post subject: Upper case conversion of data in DB2 tables
Reply with quote

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

William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Sat Mar 31, 2007 3:57 pm    Post subject:
Reply with quote

How many records?
Where are these records located?
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: Sat Mar 31, 2007 10:13 pm    Post subject:
Reply with quote

Hello,

If you unload the table(s) you can translate easily in batch. After translation, reload the data.
Back to top
View user's profile Send private message
udaynimje

New User


Joined: 09 Oct 2006
Posts: 6
Location: pume maharashtra India

PostPosted: Sun Apr 01, 2007 5:13 pm    Post subject: Re: Upper case conversion of data in DB2 tables
Reply with quote

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

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Sun Apr 01, 2007 5:24 pm    Post subject:
Reply with quote

Have you looked at The UPPER function?
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: Sun Apr 01, 2007 8:51 pm    Post subject:
Reply with quote

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

Active Member


Joined: 31 Oct 2006
Posts: 962
Location: Richmond, Virginia

PostPosted: Mon Apr 02, 2007 6:19 pm    Post subject:
Reply with quote

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.
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 -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Sorting group data rajella DFSORT/ICETOOL 4 Sun Jan 22, 2017 11:32 pm
No new posts Storing huge volume of data, compare ... Pradeep K M All Other Mainframe Topics 3 Mon Jan 16, 2017 5:08 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts Summing on Mixed Case Literals Roy Ware SYNCSORT 3 Tue Jan 03, 2017 10:18 pm
No new posts HALDB data refresh/copy from producti... vineetanand2007 IMS DB/DC 1 Mon Jan 02, 2017 11:16 am


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