Posted: Fri Sep 13, 2013 2:55 pm Post subject: How to get the count of total records
Can any one help me how we can display the total count if records that are present in the header not at the trailer. I used the below logic. It worked for Trailer. But i replaced trailer with Header the job is failing.
That is the Requirment which i got. They want the count to be present in the header as soon as they open the file.
My Source is a batch file which generated in the above steps of the JCL.
Destination is some other System. _________________ Subbu.Ch
Well, I don't like the "design". You could drive a very wid truck through the gaps without scraping the sides.
You should be able to find examples of this.
Use JOINKEYS, with the same dataset on both legs of the JOINKEYS.
In JNF2CNTL set a value of one on each record (cut it down so it is almost just that) and use SUM. The only other value you need on the record is something "low" so that the single record which comes out of the JNF2CNTL appears first.
Use JOIN F1,F2,ONLY
Your F2 is the header. Do your remaining formatting.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum