Header and Footer inclusion in a data file through SORT

narasridhar · New User Joined: 12 Oct 2006 Posts: 32 Location: India

Can some one help the way for writing the data records in a file as shown below by using the SORt card?

Header record1
Header record2
Header record3
Data record 1
Data record 2
;
;
; These data records can be vary on each time. These records to include in this file each time.
;
etc
Footer record1
Footer record2

Is any of doing this through SORT

Frank Yaeger · Posted: Fri Oct 31, 2008 4:21 am

It's not clear what you want to do. Does your input file have just the data records? Or does your input file have the header, data and trailer records?

Do you want to add the header and trailer records? Or do you want to replace the header and trailer records? Or do you want to keep the header and trailer records where they are and sort the data records?

You need to do a better job of explaining your requirement. Show an example of the input records and what you expect for output. Explain the "rules" for getting from input to output. Give the RECFM and LRECL of the input file. Give the starting position, length and format of any relevant fields.

narasridhar · New User Joined: 12 Oct 2006 Posts: 32 Location: India

I have a file with the header and footer records which is same all the times. I need to amend the data records as a result of output from the data file. the number of data records vary each time.

narasridhar · New User Joined: 12 Oct 2006 Posts: 32 Location: India

Please find the two files as input and ouput
-------------------------------------------------

Input file1:
----------
123456
123456
123456

Input file2:
-------------
This is header1
This is header 2

This is footer1
This is footer2

i am output file as below:
----------------------------
This is header1
This is header 2

123456
123456
123456

This is footer1
This is footer2

The data records are variable length records.

Frank Yaeger · Posted: Fri Oct 31, 2008 4:56 am

We're getting closer.

So you want to insert the two header records (records 1 and 2) from input file2 before the data records from input file1, and you want to insert the two footer records (records 3 and 4) from input file2 after the data records from input file1 - right?

narasridhar · New User Joined: 12 Oct 2006 Posts: 32 Location: India

Frank Yaeger · Posted: Fri Oct 31, 2008 5:56 am

Ok, I think I have all the information I need now. It's quitting time here. I'll give you a solution tomorrow.

Frank Yaeger · Posted: Fri Oct 31, 2008 8:59 pm

Here's a DFSORT/ICETOOL job that will do what you asked for. Be sure to use a MOD data set for //OUT.

narasridhar · New User Joined: 12 Oct 2006 Posts: 32 Location: India

Pleae find the my code it was copying correctly BUT the header records are copying again after the data records and the finally it is displaying the footer record. We need to avoid the header record coying after the data records. Please find my code below

Frank Yaeger · Posted: Fri Oct 31, 2008 10:47 pm

I don't understand. You showed me a specific example with two header records and two footer records. I asked you specifically if you wanted to treat record 1 and 2 as the header records and records 3 and 4 as the footer records and you said YES. So I showed you the job for that SPECIFIC SITUATION using STOPAFT=2 and SKIPREC=2. Now you've changed the job to use STOPAFT=16 and SKIPREC=4 and you don't understand why it doesn't work. Unbelievable!

STOPAFT=2 and SKIPREC=2 works for two header records (and any number of footer records) - that's the requirement we discussed, so I gave you the solution for that situation.

If you actually have a different number of header records, then why didn't you tell me that? For the general solution, you need STOPAFT=n and SKIPREC=n where n is the number of header records. For example, if you have 16 header records, then you'd use STOPAFT=16 (stop after the 16 header records) and SKIPREC=16 (skip the 16 header records).

narasridhar · New User Joined: 12 Oct 2006 Posts: 32 Location: India

Thanks Frank it works successfully.

Thanks alot for your patience to give the detailed information on every thing

saquib.ahsan · New User Joined: 22 Sep 2008 Posts: 6 Location: Pune

I have a problem wherein i need to insert multiple line header before the actual data. Let me explain it further, and then come back to the question:

File1 (FixedBlock):
Data record1
Data record2

Each record has the following format
Date <2 spaces> count

I need to append a header as below:
Date <2 spaces> Number of breaks

I can add the header using OUTFIL HEADER1 and then append the data using OUTREC, but since the second field in the header is large, i want it in the following format:
Date <2 spaces> Number of
breaks
i.e. i want the header on two rows
Can someone help me out on this. I do not want to hard code the header format in a file and then merge the two files. Can it be done using OUTFIL HEADER1 options?

Frank Yaeger · Posted: Fri Jan 16, 2009 3:17 am

Please post this as a new Topic. If you want a DFSORT solution, post it in the DFSORT Forum. Otherwise, post it in the JCL Forum. Show an example of the records in the input file (relevent fields only) and what you expect for output. Give the RECFM and LRECL of the input file. Give the starting position, length and format of each relevant field.