Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Search and replace the key in the report

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> SYNCSORT
View previous topic :: :: View next topic  
Author Message
V S Amarendra Reddy

Active User


Joined: 13 Sep 2006
Posts: 216
Location: USA

PostPosted: Thu Jul 09, 2015 7:41 pm    Post subject: Search and replace the key in the report
Reply with quote

Hi All,

I have 1 input file and a lookup file. Lookup file contains 2 fields one is the Child, and another is the Parent and each of 6 bytes long, char type and the file is of FB type.

Now the input file is a pure report with all the header, details etc.. and produced outside of Mainframes and gets into Mainframes.

It is of type FB and the length is 227 bytes. This has the Child keys present in byte 13 and length is 6.

My requirement is to read the key from the file and look in the look up file, get the parent value and put it in the input report record in position 2 and copyt it into output file.

The catch here the input report file shouldn't be sorted and Look up file is just the input file. The o/p file needs to be an exact copy of the input file but with the parent key value. if the key is not found it can put blanks in parent but still copy the record to output file.

I thought of implementing this using Easytrieve or Syncsort. Just want to know if Syncsort can do it in simple way.

I have searched for JOINKEYS but it appears to be doing sort and reformatting. So, please let me know if there is any better way to do it in Syncsort.

Regards
Amar
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7312

PostPosted: Thu Jul 09, 2015 7:59 pm    Post subject: Reply to: Search and replace the key in the report
Reply with quote

Need a reasonable sample of inputs, and expected output for those inputs.

What do you mean by "sorting" is not allowed?

Is the report in the same order as your reference file? Is the reference file in order?
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 -> SYNCSORT All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IEBCOPY - Not replace a existing PDS ... Aks1988 JCL & VSAM 15 Mon Mar 09, 2020 7:06 pm
No new posts convert SUPERC compare report to side... jzhardy CLIST & REXX 5 Fri Feb 21, 2020 8:55 am
No new posts ISPF search - capturing result jzhardy TSO/ISPF 15 Sat Dec 07, 2019 5:20 am
No new posts Report generation using TRAILER3 Krishnadeva Reddy DFSORT/ICETOOL 2 Sat Oct 05, 2019 2:24 am
No new posts Search the strings present in ps file... Bhuvana Narasimhan All Other Mainframe Topics 8 Thu Aug 22, 2019 8:20 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us