IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

can we convert values of a field in lower case to upper case


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
umed

New User


Joined: 13 May 2005
Posts: 38

PostPosted: Wed Oct 26, 2005 3:25 pm
Reply with quote

Hi,
suppose i have a file having following data :

Code:

     1   AMOL   2000
     2   umed   3000
     3   Ram     4000
     4   SHAM    100


Is there any way to get output like this :

Code:

     1   AMOL    2000
     2   UMED    3000
     3   RAM      4000
     4   SHAM    100


thanks in advance,
umed
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1448
Location: Chicago, IL

PostPosted: Wed Oct 26, 2005 3:33 pm
Reply with quote

http://ibmmainframes.com/viewtopic.php?t=3746

Regards,

Priyesh.
Back to top
View user's profile Send private message
leo_sangha

New User


Joined: 11 Aug 2005
Posts: 85
Location: England

PostPosted: Wed Oct 26, 2005 7:39 pm
Reply with quote

Hi Umed ,

This control card converts first 15 characters from the Lower to Upper case

Code:

    SORT FIELDS=COPY                 
    OUTREC FIELDS=(1:1,15,TRAN=LTOU)
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Wed Oct 26, 2005 8:47 pm
Reply with quote

Umed,

Here's a DFSORT job that will do what you asked for. I assumed the field you want to convert to uppercase is in positions 10-13, but you can change the job appropriately for a different starting position and/or length.

Code:

//S1    EXEC  PGM=ICEMAN
//SYSOUT    DD  SYSOUT=*
//SORTIN DD DSN=...  input file
//SORTOUT DD DSN=...  output file
//SYSIN    DD    *
  OPTION COPY
  INREC OVERLAY=(10:10,4,TRAN=LTOU)
/*
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts INCLUDE OMIT COND for Multiple values... DFSORT/ICETOOL 5
No new posts COBOL -Linkage Section-Case Sensitive COBOL Programming 1
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Need to convert date format DFSORT/ICETOOL 20
No new posts Keep leading zero(s) after convert fl... SYNCSORT 7
Search our Forums:

Back to Top