MVSFORUMS.com

puttu · Beginner Joined: 29 Jul 2010 Posts: 41 Topics: 9

hi,
I need a sort conditionto merge two files into the one file.

Please find the details:
input file:
file 1 : 1st position to 15th position having data (acct-nbr)
file 3 : 16th postion to 32nd positio having data (name).

Output file:
output file: 1st to 15th position (acct nbr),16th to 32nd (name)

kolusu · Posted: Tue Aug 10, 2010 11:19 am Post subject:

puttu,

huh? What is the Matching key in both files?
_________________
Kolusu
www.linkedin.com/in/kolusu

puttu · Beginner Joined: 29 Jul 2010 Posts: 41 Topics: 9

kolusu,
in file 1 we have starting position 00 for all reords.
in file 2 we have starting position 2010 for all records.

kolusu · Posted: Tue Aug 10, 2010 11:37 am Post subject:

Puttu,

Did you even read my post? bonk

Please read this post and see how to explain your requirement

http://www.mvsforums.com/helpboards/viewtopic.php?p=54768#54768
_________________
Kolusu
www.linkedin.com/in/kolusu

puttu · Beginner Joined: 29 Jul 2010 Posts: 41 Topics: 9

kolusu,
a bit confusion...
can u please send a exact code for my requirement....

kolusu · Posted: Tue Aug 10, 2010 12:17 pm Post subject:

puttu · Beginner Joined: 29 Jul 2010 Posts: 41 Topics: 9

kolusu,

for my requirement. i dont want to check key.
just i want to merge.

puttu · Beginner Joined: 29 Jul 2010 Posts: 41 Topics: 9

Hi kolusu,

Please find the detailed explanation of my requirement:

need a sort conditionto merge two files into the one file.

Please find the details:
input file:
file 1 : 16th postion to 31st position having data.
file 2 : 1st position to 15th position having data.

Output file:
output file: 1st to 15th position ,16th to 32nd

input file 1 format:
from 1st postion spaces, 16th to 31 having date.

file 2 format:
1st to 15th time stamp

output should be:
1,16 date, 17,15 timestamp

kolusu · Posted: Tue Aug 10, 2010 2:14 pm Post subject:

puttu,

you don't get it don't you? sigh ok explain me from the following input

File 1 has 5 records like shown below

File 2 has only 3 records like shown below.

if the criteria is to match record-1 or file 1 with record-2 of file 2 then then the output is shown below.

Now the question is what happens when the files DO NOT have the same number of records like shown below?

Technically you ALWAYS will have a KEY if you want to merge contents from 2 different files. In this case it is the record number. Remember that we can't see your data nor read your mind. So Please specify everything so that we wont be wasting time.

FILE : 1

puttu · Beginner Joined: 29 Jul 2010 Posts: 41 Topics: 9

kolusu,
what u taken examples & output also correct.
here in my case always both the files will have same records 100%.

kolusu · Posted: Tue Aug 10, 2010 2:46 pm Post subject:

puttu,

Use the folloiwng DFSORT JCL which will give you the desired results