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: 7306

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: 7306

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 Record Not found in AlX but record re... mukun264 COBOL Programming 2 Fri Mar 24, 2017 9:28 am
No new posts Count the length of the record & ... sreekusr DFSORT/ICETOOL 4 Thu Mar 23, 2017 7:52 pm
No new posts IMS DB-How to update a record (a sing... Nic Clouston IMS DB/DC 9 Thu Mar 09, 2017 4:38 pm
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am


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