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
 

 

add additional record in between records - DFSORT

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

Active User


Joined: 18 Oct 2008
Posts: 380
Location: India

PostPosted: Tue Aug 07, 2012 7:56 pm    Post subject: add additional record in between records - DFSORT
Reply with quote

Hi,

I have an input file (LRECL=80,RECFM=FB) with data as shown below:
Code:

----+----1----+----2----+----3
A1 NAME OF LENGTH 80         
A2 ADDR OF LENGTH 80         
A8 OTHR OF LENGTH 80         
ZZ ENDR OF LENGTH 80         
A1 DATA OF LENGTH 80         
A2 DATA OF LENGTH 80         
ZZ ENDR OF LENGTH 80         
A1 NAME OF LENGTH 80         
A2 ADDR OF LENGTH 80         
A7 MISC OF LENGTH 80         
ZZ ENDR OF LENGTH 80         
A1 NAME OF LENGTH 80         
A2 ADDR OF LENGTH 80         
A8 OTHR OF LENGTH 80         
ZZ ENDR OF LENGTH 80         


The above data has groups of records (each group of records start with A1 and ends with ZZ at 1st column). There are total 4 groups. My requirement is to insert A9 record after each A8 record if a group has got A8 record type. However, all the records should remain in the same order as they do appear in I/P file.

The expected output is like this:
Code:

----+----1----+----2----+----3
A1 NAME OF LENGTH 80         
A2 ADDR OF LENGTH 80         
A8 OTHR OF LENGTH 80         
A9 EXTR OF LENGTH 80         
ZZ ENDR OF LENGTH 80         
A1 DATA OF LENGTH 80         
A2 DATA OF LENGTH 80         
ZZ ENDR OF LENGTH 80         
A1 NAME OF LENGTH 80         
A2 ADDR OF LENGTH 80         
A7 MISC OF LENGTH 80         
ZZ ENDR OF LENGTH 80         
A1 NAME OF LENGTH 80         
A2 ADDR OF LENGTH 80         
A8 OTHR OF LENGTH 80         
A9 EXTR OF LENGTH 80         
ZZ ENDR OF LENGTH 80         


Is this possible with DFSORT v10 for z/OS? Please help.

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

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7251

PostPosted: Tue Aug 07, 2012 8:10 pm    Post subject: Reply to: add additional record in between records - DFSORT
Reply with quote

Try an IFTHEN on OUTFIL and use the / (slash operator) when you get an A8. There are examples. Search for "slash operator".
Back to top
View user's profile Send private message
ramsri

Active User


Joined: 18 Oct 2008
Posts: 380
Location: India

PostPosted: Tue Aug 07, 2012 8:29 pm    Post subject: A9 EXTR OF LENGTH 80
Reply with quote

Bill, yes.......got the results.....thanks for the idea !!!

Code:

//SYSIN    DD *                               
 SORT FIELDS=COPY                             
 OUTFIL IFTHEN=(WHEN=(1,2,CH,EQ,C'A8'),       
 BUILD=(1,80,/,C'A9 EXTR OF LENGTH 80',60X)) 
//*                                           
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7251

PostPosted: Tue Aug 07, 2012 8:43 pm    Post subject: Reply to: add additional record in between records - DFSORT
Reply with quote

No problem. Thanks for posting your solution, it'll help someone else later.
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 Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 8 Fri Dec 09, 2016 4:40 am
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to update a portion of text in a ... Bill Woodger DFSORT/ICETOOL 25 Wed Nov 09, 2016 9:41 pm
No new posts How to get the remainder and quotient... vnktrrd DFSORT/ICETOOL 2 Mon Oct 31, 2016 10:59 am
No new posts How to split the records using the am... vnktrrd DFSORT/ICETOOL 24 Fri Oct 28, 2016 7:33 pm


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