IBM Mainframe Forum

by **ranga_subham** » Thu Nov 20, 2008 6:14 pm

Hi, Is it possible to use SEQNUM on TRAILER1 when NODETAIL & REMOVECC used?

I tried it with OUTREC OVERLAY, BUILD & FIELDSalso but wasn't getting in output.

Please suggest.

Thanks.

by **Alissa Margulies** » Thu Nov 20, 2008 8:43 pm

Why are you trying to put a SEQNUM on a TRAILER1? If I could understand your requirement, maybe I could be more help.

by **ranga_subham** » Mon Nov 24, 2008 4:33 pm

Alissa, I was on vacation so could not give reply... :roll:

Select all

//STEP0001 EXEC PGM=SORT
//SORTOUT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SORTIN DD *
ABCD0001
ABCE2001
ABCF3004
//SYSIN DD *
SORT FIELDS=COPY
OUTFIL REMOVECC,NODETAIL,TRAILER1=(COUNT=(M11),SEQNUM,3,ZD)

I was trying to get the output with SEQNUM :!:

Thanks.

by **Alissa Margulies** » Tue Nov 25, 2008 8:39 am

I still don't understand your requirement. Are you just trying to insert the number of records? If so, then COUNT is sufficient, you do not need SEQNUM. If this is not what you want, then please post an example of your expected output.

by **ranga_subham** » Tue Nov 25, 2008 2:49 pm

Alissa, thanks for the reply.

I am trying to count no. of records from 10 files but want to have sequence number also alongside for each count. Let us say, the first has 10, 2nd has 20, 3rd has 30 records.

I want to see my output as given below:

Select all

00000000010 001
00000000020 002
00000000030 002

Please let me know if it is possible.

Thanks.

by **Alissa Margulies** » Tue Nov 25, 2008 8:54 pm

Your output does not match the sample input in your previous post. Is there something unique in the records of each input file that identifies it as to which file it comes from? For example, does every record from file1 have a '1' in a certain position, whereas file2 would have a value of '2' in that same position? If there is an identifying field, then we can use SECTIONS with a COUNT in TRAILER3.

by **ranga_subham** » Tue Nov 25, 2008 9:58 pm

I have asked my seniors about this but they said like what you have asked for cannot be guranteed because the files are user created without any standards.

Thanks.

by **Alissa Margulies** » Wed Nov 26, 2008 1:27 am

If you are concatenating all 10 files in this job and there are no unique file identifiers, then there is no way for the sort to know which file the record came from. Each input file would have to be pre-processed to include an identifier field.