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

Conditional replace values in output file from input file


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

New User


Joined: 28 Sep 2022
Posts: 1
Location: India

PostPosted: Wed Sep 28, 2022 2:24 pm
Reply with quote

Hi all i ma looking after an query in df sort
scenario:
i have 2 input files one with

Code:
009999989


and 2nd with
Code:

01234567-07/22/22BBBBBBBBB89132311
01234898-07/22/22BBBBBBBBB43279098 with multiple records

i need to pass the value of that input file to all the bbbbbbbbb present in the output file and copy the data replaced to sort out file

Code’d for you
Back to top
View user's profile Send private message
Joerg.Findeisen

Active Member


Joined: 15 Aug 2015
Posts: 971
Location: Bamberg, Germany

PostPosted: Wed Sep 28, 2022 2:52 pm
Reply with quote

When you look for a DFSORT solution, why post in the COBOL thread? What have you tried so far? Remember to use the Code Tag Button when presenting code/data. Thanks!
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2973
Location: NYC,USA

PostPosted: Wed Sep 28, 2022 3:52 pm
Reply with quote

Use JOINKEYS and reformat to add F1 to F2
On the way out OUTREC IFTHEN when not bbbbb.. then blank that position using overlay.
ibmmainframes.com/about59524.html

Or use this one add twist it to just overlay when it’s bbb…. In second step.
ibmmainframes.com/about15850.html

Use code tags.
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 1699

PostPosted: Wed Sep 28, 2022 6:23 pm
Reply with quote

gutlapalli balaji wrote:

i need to pass the value of that input file to all the bbbbbbbbb present in the output file and copy the data replaced to sort out file


Please clarify for us: what is preventing you from doing your own job??
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 Insert trailer for non empty file only DFSORT/ICETOOL 6
No new posts Help to Filter File Manager Copybook ... DFSORT/ICETOOL 14
This topic is locked: you cannot edit posts or make replies. Merge 2 input files based on the reco... JCL & VSAM 2
No new posts Merge 2 input files after sort SYNCSORT 14
No new posts File Aid Batch IBM Tools 7
Search our Forums:

Back to Top