Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Convert upper case to lower except first letter

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
Squeak6

New User


Joined: 04 Aug 2005
Posts: 36

PostPosted: Tue Apr 26, 2011 7:05 pm    Post subject: Convert upper case to lower except first letter
Reply with quote

Good Morning all..

I have Last name in Col 66 legnth of 20 & first name in col 88 lengh of 19.. I'm trying to covert everything except the first letter of each to lower.. ( in those 2 fields ) I tryed using UTOL.. it worked but it removed all of my other fields.. ( I want my other fields just as they are )

this is what I did in my sysin

Code:
OUTREC FIELDS=(66,19,TRAN=UTOL,89,18,TRAN=UTOL)


all the other fields are gone this is what i get..

Code:
000001 oncrieffe          ngel                                           
000002 etancourt          lcides                                         
Back to top
View user's profile Send private message

Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Tue Apr 26, 2011 7:29 pm    Post subject:
Reply with quote

Use....
Code:
OUTREC OVERLAY=(66:66,19,TRAN=UTOL,89:89,18,TRAN=UTOL)
Back to top
View user's profile Send private message
Squeak6

New User


Joined: 04 Aug 2005
Posts: 36

PostPosted: Tue Apr 26, 2011 7:39 pm    Post subject:
Reply with quote

I worked.. thank you..
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Tue Apr 26, 2011 7:44 pm    Post subject:
Reply with quote

Squeak6 wrote:
I worked.. thank you..


Cheers.. Below from DFSORT documentation will give you clear idea...

Quote:

BUILD or FIELDS: Reformat each record by specifying all of its items one by one. Build gives you complete control over the items you want in your reformatted OUTREC records and the order in which they appear. You can delete, rearrange and insert fields and constants. Example:



OUTREC BUILD=(1,20,C'ABC',26:5C'*',
15,3,PD,EDIT=(TTT.TT),21,30,80:X)


OVERLAY: Reformat each record by specifying just the items that overlay specific columns. Overlay lets you change specific existing columns without affecting the entire record. Example:



OUTREC OVERLAY=(45:45,8,TRAN=LTOU)

Back to top
View user's profile Send private message
Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Tue Apr 26, 2011 11:02 pm    Post subject:
Reply with quote

Squeak6,

If you have embedded spaces in between then you might wanna use the solution posted in this topic

http://ibmmainframes.com/viewtopic.php?t=53476&highlight=findrep
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Convert rows and column into JSON for... Dinesh Manivannan DB2 2 Sun Sep 03, 2017 6:50 pm
No new posts RFE: DB2 support for mixed case names. Pedro DB2 0 Tue Jul 04, 2017 1:32 am
No new posts Convert CLIST to REXX cvnlynn CLIST & REXX 12 Tue Jun 27, 2017 2:06 am
No new posts Convert current to hex value gopurs DFSORT/ICETOOL 4 Wed Feb 15, 2017 5:40 am
No new posts VALIDATE NULL VALUE IN DB2 CASE STATE... useit DB2 5 Thu Feb 09, 2017 4:34 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us