MVSFORUMS.com

NASCAR9 · Posted: Fri Nov 03, 2006 1:38 pm Post subject: Mixed Case

I need to load a VSAM file into DB2 tables. I had a request to change names to mixed case. I'm writing this program in COBOL. Is there a function, LE routine, or something in DB2 to accomplish this request?

I familiar with 'UPPER-CASE' and 'LOWER-CASE'.

Any help will be appreciated.
_________________
Thanks,
NASCAR9

kolusu · Posted: Fri Nov 03, 2006 2:08 pm Post subject:

NASCAR9,

what are the rules governing the mixed case? Both DB2 and Cobol have functions to change from uppercase to lowercase and vice versa.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

sriramla · Beginner Joined: 22 Feb 2003 Posts: 74 Topics: 1

The rules to convert names to Mixed case are always complicated and you need to come up with precise requirements before coding. You need to pay attention to Jr, Sr, Roman Numeral for first, second (I, II etc), names like Bill 'O Boyle etc....

Any rule you apply may not cover all possible scenarios for names. Hence I recommend to use a Exception table for name conversion that stores the upper case name and corresponding Mixed case name for unique names that do not follow your rules.

NASCAR9 · Posted: Fri Nov 03, 2006 3:38 pm Post subject:

Thanks for the responses! I was hoping for a function or called sub-routine already written by IBM. Sounds like that doesn't exist. I don't have time to code the rules, time is very critical at this point. It's a 'Nice to have' not a hard requirement.
_________________
Thanks,
NASCAR9