Overlay a column with another file's field value



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Overlay a column with another file's field value

Postby shreedhar » Sat Nov 23, 2013 4:13 am

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.


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.
shreedhar
 
Posts: 1
Joined: Sat Nov 23, 2013 4:03 am
Has thanked: 0 time
Been thanked: 0 time

Re: Overlay a column with another file's field value

 

Re: Overlay a column with another file's field value

Postby BillyBoyo » Sat Nov 23, 2013 6:09 am

Have a look at JOINKEYS, examples here and in your documentation.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post