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

How can I get the count of header+detail+trailer records


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
prarthana

New User


Joined: 12 Mar 2006
Posts: 21

PostPosted: Fri Aug 04, 2006 8:28 pm
Reply with quote

I have 1 header record, 10 detail records, 1 trailer record. I should display the total count of 12 in the TRAILER record

COUNT in the OUTFIL gives me only the count of header+trailer record.
Can some1 help me pls?? Thanks!!
Back to top
View user's profile Send private message
prarthana

New User


Joined: 12 Mar 2006
Posts: 21

PostPosted: Fri Aug 04, 2006 8:29 pm
Reply with quote

Correct:

COUNT in OUTFIL gives only the count of header+detail records.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Sat Aug 05, 2006 11:03 pm
Reply with quote

If the header and trailer record are actually in the input data set, then they will be included in the COUNT value.

If the header is generated by a HEADER1 parameter, it will not be included in the COUNT value. If the trailer is generated by a TRAILER1 parameter, it will not be included in the COUNT value. If you want to include the generated header and trailer in the count value, you can use COUNT+2=(edit), e.g. COUNT+2=(TTTTT).

It would have helped us understand what you need if you had included your control statements in your post.
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 -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts To get the count of rows for every 1 ... DB2 3
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
Search our Forums:

Back to Top