Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Merge two input files without using Icetool

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
Sagar Mane

New User


Joined: 12 Feb 2007
Posts: 3
Location: Mumbai

PostPosted: Wed May 30, 2007 12:11 pm    Post subject: Merge two input files without using Icetool
Reply with quote

Hi I have a requirement to merge two input files. But not using Icetool. We cannot use Icetool here.
The details for the requirement are as follows:

Input1: RECFM=FB and LRECL=600
Input2: RECFM=FB and LRECL=600

Input1:
100~ABCDE~12345~01-01-2007
200~ABCDE~64789~01-01-2005
800~ABCDE~11223~01-01-2006

Input2:
100~ABCDE~12345~xxxx~01-01-1975
800~ABCDE~64789~xxxx~01-01-1944
300~ABCDE~11223~xxxx~01-12-1954

Now I want to merge these two files in such a way that the output file will look like this:
ABCDE1234501-01-200701-01-1975
ABCDE6478901-01-200501-01-1944
ABCDE1122301-01-200601-12-1954

Here the last field i.e. the Birth Date from input file2 is merged to input file1. The key for both the input files is 5 chars from 4th position + 5chars from 9th position. eg. ABCDE(NAME) + 12345(NUMBER).

In cases where input file1 has a record without a match in input file2, and where input file2 has a record without a match in input file1 then we can write spaces for data that is missing in any file. E.g. if Input1 has a record and no matching record in Input2 then we can write spaces in place of Birth Date.


Note: I have added the seperator just to seperate the data. There is no seperator in the actual file.
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Wed May 30, 2007 6:09 pm    Post subject:
Reply with quote

What is the reason for not using ICETOOL, apart from the obvious one which is that you do not have DFSORT installed.

Surely if this is the case, then the sort product installed should have some similar logic to ICETOOL.
Back to top
View user's profile Send private message
Sagar Mane

New User


Joined: 12 Feb 2007
Posts: 3
Location: Mumbai

PostPosted: Sat Jun 02, 2007 11:50 am    Post subject: What is the reason for not using ICETOOL, apart from the obv
Reply with quote

I dont know for what reason but the client doesnt want to use Icetool. So I am searching for the same with SORT.
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: Sat Jun 02, 2007 5:09 pm    Post subject:
Reply with quote

Hello,

Which sort product are you using at this client location?
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 -> 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 Performing arithmetic on input field zh_lad DFSORT/ICETOOL 31 Tue Dec 06, 2016 8:04 pm
No new posts High CPU consumption Job using IAM fi... aswinir JCL & VSAM 15 Thu Dec 01, 2016 8:28 pm
No new posts Match or compare two files in VB Format anatol DFSORT/ICETOOL 14 Thu Nov 03, 2016 7:41 pm
No new posts How to delete second instance from Fl... Gunapala CN DFSORT/ICETOOL 6 Tue Oct 18, 2016 11:42 pm
This topic is locked: you cannot edit posts or make replies. How to use 2 input files in control c... Gunapala CN DFSORT/ICETOOL 23 Thu Oct 13, 2016 3:42 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us