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: 901
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: 2942
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: 1612

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 Converting ASCII values to COMP-3 (ZD... JCL & VSAM 2
No new posts Jes2 command output All Other Mainframe Topics 4
No new posts Selecting the max value from a file. DFSORT/ICETOOL 3
No new posts Change history of vsam file. JCL & VSAM 3
No new posts Generate output lines (SYSIN card for... DFSORT/ICETOOL 4
Search our Forums:

Back to Top