Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Overlay a column with another file's field value

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
shreedhar

New User


Joined: 05 Feb 2007
Posts: 4
Location: Pune

PostPosted: Sun Nov 24, 2013 1:11 am    Post subject: Overlay a column with another file's field value
Reply with quote

Hi,

I want to copy file1 into file3 with below requirement.
Requirement: Overlay a column in file1 (position 44, length 6) with file2's field (position 31, length 6) creating outfile file fille3 for all my input records in file1. All are FB records/files as below
File1 - record length 1000
File2 - record length 200
File3 - record length 1000.
File2 will always have only a single record.
File1 can have any number of records.


I have seen examples of overlaying a field with the constant. But here I am looking for overlaying a field with the another file's field value.
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7314

PostPosted: Sun Nov 24, 2013 2:54 am    Post subject: Reply to: Overlay a column with another file's field value
Reply with quote

Most efficient way to do it is two steps. First step process the single-record file and generate a symbol/SYMNAMES for the value.

Second step is to use the symbol to OVERLAY your value, which is by now a constant in your symbols.

Search this forum for SYMNAMES and you should find examples, often with dates.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Nov 24, 2013 7:08 am    Post subject:
Reply with quote

Hello,

This topic is a duplicate of your same topic on the Beginners Forum.

It is now locked.

d
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies.    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 Join 2 File using a Join Key scorp_rahul23 DFSORT/ICETOOL 6 Tue Aug 14, 2018 7:36 am
No new posts JCL to send email along with formated... wik123 JCL & VSAM 5 Thu Aug 09, 2018 9:48 am
No new posts How can we create a flat file in JAVA... jasorn Java & MQSeries 2 Wed Aug 08, 2018 3:08 pm
No new posts Formating of Amount field in CLIST be... Anil Kumar Prajapati CLIST & REXX 9 Fri Aug 03, 2018 6:34 pm
No new posts SMF IFAMGET macro GTPB_RETURNEDLENGT... ironheinrich7 IBM Tools 0 Thu Aug 02, 2018 6:53 pm

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