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

need unpaired and matched records from File-1


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
ramsri

Active User


Joined: 18 Oct 2008
Posts: 380
Location: India

PostPosted: Tue Aug 13, 2013 1:41 pm
Reply with quote

Arun,

Quote:

Are the HEADERs for the groups on the two files always identical for a group?


The file will have only one HEADER and yes.....they are identical.

Quote:

Do the TRAILERs simply contain the word TRAILER, or some other "constant" value, or what?


Yes......it is just TRAILER and nothing.

Thanks.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Aug 13, 2013 9:05 pm
Reply with quote

Hello,

To Repeat:
Quote:
What happened when you tried?

If you have not tried, do so and post the results if there is a question/problem.


If you are unwilling to do things suggested and reply as to what happened, we should start locking your topics. . .
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 Aug 16, 2013 12:59 am
Reply with quote

Ramsri,

I've lost track of whether you can use JNFnCNTL files.

If not, use OMIT on the JOINKEYS for your F2 to get rid of the header and trailer.

They will then "pop up" on your F1,ONLY output. In the wrong order.

You'll have to SORT them. Append an X'00' to the header, X'FF' to the trailer and C'1' to each data record. SORT on with, with EQUALS.

Or make a sequence number, set to zero for the header, and all 9 for the trailer. SORT on that, with NOEQUALS.

Don't forget to cut the record back down afterwards (OUTREC BUILD=).

If you can use JNF1CNTL, then the processing to order the header and trailer can be done in there and the cut-down in the REFORMAT.
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 -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
Search our Forums:

Back to Top