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 Quick References
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

Senior Member


Joined: 15 Aug 2015
Posts: 1442
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: 3109
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: 2288
Location: USA
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 All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 

Similar Topics
Topic Forum Replies
No new posts IGYPG3178-I when compiling a pgm read... COBOL Programming 5
No new posts count contained values of several col... DB2 4
No new posts FileAid move data from two files to o... Compuware & Other Tools 5
No new posts Sorting date into YYYYMMDD, and creat... DFSORT/ICETOOL 13
No new posts To Sort detail records in a file with... SYNCSORT 5
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