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

How to write special character using PARSE in SORT.
IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
vaibhavjadhav

New User


Joined: 27 Jul 2007
Posts: 33
Location: mumbai
PostPosted: Wed Mar 16, 2011 10:57 pm
 Reply with quote
Hi,

Could you please help me in writing the below output using PARSE in SORT or ICETOOL.

Explanation:
The input is a comma delimited and want the output to be written as replacing comma with * as shown below. Also the field STATUS and its value in all the records and header should be written as $.

Code:

Input:

POLNO,AGENTNO,STATUS,FREQ,GENDER
00001,001,SP,MONTHLY,MALE
002,02,AP,YEARLY,FEMALE
03,003,AP,HALF,MALE
0004,04,SP,QUARTELY,MALE
00005,005,AP,MONTHLY,FEMALE


Output:

POLNO*AGENTNO*$*FREQ*GENDER
00001*001*$*MONTHLY*MALE
002*02*$*YEARLY*FEMALE
03*003*$*HALF*MALE
0004*04*$*QUARTELY*MALE
00005*005*$*MONTHLY*FEMALE
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 Mar 16, 2011 11:18 pm
 Reply with quote
You can use DFSORT statements like the following to do what you asked for:

Code:

  OPTION COPY                                             
  INREC IFTHEN=(WHEN=INIT,FINDREP=(IN=C',',OUT=C'*')),     
    IFTHEN=(WHEN=INIT,                                     
      PARSE=(%01=(ENDAT=C'*',FIXLEN=10),                   
             %02=(ENDAT=C'*',FIXLEN=10),                   
             %=(ENDBEFR=C'*'),                             
             %03=(FIXLEN=20)),                             
      BUILD=(%01,%02,C'$*',%03)),                         
   IFTHEN=(WHEN=INIT,OVERLAY=(1:1,42,SQZ=(SHIFT=LEFT)))   
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 Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts PARSE Syntax for not fix length word ... JCL & VSAM 7
No new posts Write line by line from two files DFSORT/ICETOOL 7
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us