IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

JCL to merge two files side by side


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Nickz

New User


Joined: 24 Feb 2025
Posts: 1
Location: India

PostPosted: Mon Jun 23, 2025 12:40 pm
Reply with quote

Hi all,

I have below requirement I'm posting example

FB file 80 bytes

I have two files as below


File : 1

020250623
1123456789567891 N
1123456789567892 Y

File 2
020250623
112345678912345 1234567
112345678912346 1234566


Output:

020250623
1123456789567891 N 12345678912345 1234567
1123456789567891 Y 12345678912346 1234566

I'm breaking down

From file 2 we need from 2nd pos to 20

I'm getting out as not expected

I have used join keys
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 2218
Location: USA

PostPosted: Mon Jun 23, 2025 4:54 pm
Reply with quote

Nickz wrote:

I have used join keys


It is a good choice.

No more info is available from your post.
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 2218
Location: USA

PostPosted: Mon Jun 23, 2025 6:24 pm
Reply with quote

One extra note:

JCL has no available tool to perform such manipulation on any file (e.g. dataset).

Utilities like DFSORT or SYNCSORT can be used for that purpose.

JCL is built exactly in the same manner FOR ANY POSSIBLE PROGRAM running on mainframe.
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 2218
Location: USA

PostPosted: Mon Jun 23, 2025 7:11 pm
Reply with quote

Nickz wrote:

I'm getting out as not expected


Definitely, you are doing something wrong.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts One to Many merge SYNCSORT 7
No new posts Create a specific record/file based o... SYNCSORT 8
No new posts 3 files concatenated to 1 DFSORT/ICETOOL 2
No new posts JCL sort to compare dates in two file... DFSORT/ICETOOL 2
No new posts SORT JCL to merge multiple tow into s... DFSORT/ICETOOL 6
Search our Forums:


Back to Top