If you can't get the merge stage to work the way you want, you may need to consider loading the two sequential files up into database tables and then doing the outer join yourself via custom sql.
-craig
Merging Sequential Files
Moderators: chulett, rschirm, roy
-
rajesh_potluri
- Participant
- Posts: 6
- Joined: Wed May 07, 2003 5:29 am
- Location: India
- Contact:
Since you need all records from both the files, this is a case of full outer join when joining two tables. Here we have a case of joining two files on similar lines.
If u are working on a server job, the join stage over there has the option of full outer join. Simple solution.
If u are working on a mainframe job, the join stage provided has only the left outer, right outer and inner join facilities. In this case, the round about way of achieving this would be to use two join stage flows. One join stage use the left outer join and in the second flow perform right outer join and in the later stage, simply merge the output of the above two flows.
You may get back for ne issues.
Rajesh
If u are working on a server job, the join stage over there has the option of full outer join. Simple solution.
If u are working on a mainframe job, the join stage provided has only the left outer, right outer and inner join facilities. In this case, the round about way of achieving this would be to use two join stage flows. One join stage use the left outer join and in the second flow perform right outer join and in the later stage, simply merge the output of the above two flows.
You may get back for ne issues.
Rajesh