IBM Mainframe Forum

Hi all,

I want to match a trailer record with the total no of data records in my file
Trailer recod looks like this:
TRAILER 20090401 1304760

I am trying this using a SORT step s below:



I am getting MAXCC=0 but the output file is empty whcih is whay I am confused.
I also want to comapre the date in the trailer record with a DATE file.Can I accomplish this one step? Please help me with this?
Thanks,
Shilpa

HI Frank,

I need ur help with this As sson as possible. Your expertise is highly needed!

Thanks,
Shilpa

You need to do a better job explaining what you want to do. The job you show only uses one input (myid.input) so how does both the file with the trailer record and the file with the data records enter into it?

Please explain more clearly what you want for output for the different cases (trailer count matches number of input records; trailer count does not match the number of input records). Give the RECFM and LRECL of each input file. Give the starting position, length and format of each relevant field in the input files.

I also want to comapre the date in the trailer record with a DATE file.Can I accomplish this one step?

Again, you need to explain more clearly what you want to do. What does this DATE file look like? What do you want to compare the date in the trailer record to and what output are you expecting?

Let me explain :

input (myid.input) is the file which has a trailer record as the last record.
TRAILER 20090401 1304760 ----->the last figure is the record count.
I want to compare this record count with the actual no of data records in the file (myid.input) . This file also has a header record. The record count on the Trailer record is the count of the actual data records, it excludes the header and trlr record.
If the count matches, we should get some statistics as:
No of records in input file= 1304760
TRailer record count = 1304760.
But if the count deos not match, the job shound give a RC of 8.
Inthe input file , the record looks as given below....just data records.
U00000000345678906000+00000000+200902......................

The date file has just the date in it - '2009-04-01'. It just has to compare this date with the date in the trailer record. And give an RC of 8 if it does not match. If it matches just,
give stats as below:
Date in the trailer record= 20090401
Date in the Date file - 20090401.

Thanks,
Shilpa

What is the RECFM of myid.input?

What is the starting position and length of the date field and count field in the trailer record?

What is the starting position of the data in the date file record?

DFSORT cannot give a RC of 8. Is greater than 8 ok (e.g. 12, 16)?

Do you want to do both of these comparisons (count, date) in the same step or in different steps?

I am answering the questions below:
1. What is the RECFM of myid.input?
FB

What is the starting position and length of the date field and count field in the trailer record?
TRAILER 20090301 11
Date field -
Starting position - 9
Length - 8
Rec-cnt field -
Starting position - 18
Length - 7

3.What is the starting position of the data in the date file record?
Staring poisiton of the actual date is 4. On th ethird position we have a quote -'2009-03-31'

4. DFSORT cannot give a RC of 8. Is greater than 8 ok (e.g. 12, 16)?
Sure. The job ahould abend.

Do you want to do both of these comparisons (count, date) in the same step or in different steps
I would prefer one step, but if its complicated then 2 steps should do.

Thanks,
Shilpa

GM FRank!
Is there any way to do this?

Thanks,
Shilpa

I just got in to work. I have some ideas, but I need some time to work them out. Will post later today.

Thanks Frank! Some time later should be fine:)

Shilpa

I am trying to achieve only the record count match as below:
//PS000010 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=DW3T.RTLECR.GMAC.MNTHLY.XTRCT.SML,DISP=SHR
//OUT DD DSN=DW3T.RECRIS.GMAC.AUD,
// DISP=(NEW,CATLG,DELETE),
// UNIT=(,30),
// SPACE=(TRK,(1,1)),
// DCB=(DSORG=PS,RECFM=FB,LRECL=42,BLKSIZE=0)
//SYSIN DD *
OPTION COPY
INREC BUILD=(1,30,SEQNUM,12,ZD,START=0)
OUTFIL FNAMES=OUT,NULLOFL=RC4,
INCLUDE=(1,07,CH,EQ,C'TRAILER',AND,
(18,12,ZD,EQ,31,12,ZD))

It gives me an RC=4 with this in spool:
OUT : DATA RECORDS OUT 0; TOTAL RECORDS OUT 0
Not sure why it is not selecting the records