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

Sort card to concatenate two records based on one condition


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

Senior Member


Joined: 08 May 2006
Posts: 1193
Location: Dublin, Ireland

PostPosted: Fri Apr 24, 2015 4:25 pm
Reply with quote

If there are only 2 records, I'd suggest you modify the PUSH. Instead of Pushing the key field (1,8) you can PUSH the entire first record at the end of both records.

Then you can drop the first record in JNF1CNTL output process. Finally, in the REFORMAT, you can use FIELDS=(F1:134,133,1,133) and you have the 2nd record appended to the first in a single 266-byte record.

DFSORT also has the ability to squeeze out blanks, left- and right-justify - which you might want to look at.

Garry.
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Fri Apr 24, 2015 4:25 pm
Reply with quote

I think it would be much clearer if you now start a new question. You've got the output you want from your initial request, and it turns out that wasn't the whole thing.

A new question, then, with actual sample data and expected output, all in the Code tags to preserve spacing, and use the Preview button to see that you have what you want before posting.
Back to top
View user's profile Send private message
sakrat

Active User


Joined: 05 Feb 2014
Posts: 164
Location: India

PostPosted: Fri Apr 24, 2015 4:27 pm
Reply with quote

Bill Woodger wrote:
I think it would be much clearer if you now start a new question. You've got the output you want from your initial request, and it turns out that wasn't the whole thing.

A new question, then, with actual sample data and expected output, all in the Code tags to preserve spacing, and use the Preview button to see that you have what you want before posting.



ok thanks.....
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 Goto page Previous  1, 2

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Compare only first records of the fil... SYNCSORT 7
Search our Forums:

Back to Top