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

TRAILER1 result minus one


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

New User


Joined: 01 Apr 2006
Posts: 17
Location: Pune

PostPosted: Wed Sep 05, 2007 5:02 pm
Reply with quote

Hi all,
currently i am fighting with one problem. In my output file Header record is as below :
<BatchUpdate Type="TRI" WorkDate="20070905" RecordCount="00037">
followed by Detail records. And last record is </BatchUpdate>
which is also being counted in the RecordCount.

I want only the number of detail records and that is 36 and not 37.

My control card is as below :
SORT FIELDS=COPY
OUTFIL REMOVECC,NODETAIL,
TRAILER1=(COUNT=(M11,LENGTH=5))

Thanks you all for reading....!
Back to top
View user's profile Send private message
shankar.v

Active User


Joined: 25 Jun 2007
Posts: 196
Location: Bangalore

PostPosted: Wed Sep 05, 2007 5:41 pm
Reply with quote

Try with the following sort cards
Code:

  SORT FIELDS=COPY
  OUTFIL REMOVECC,NODETAIL,
     TRAILER1=(COUNT-1=(M11,LENGTH=5))
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: Wed Sep 05, 2007 9:19 pm
Reply with quote

sandy,

For more information on DFSORT's COUNT-n and COUNT+n functions, see my paper at:

Use [URL] BBCode for External Links
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 leading spaces can be removed in trai... DFSORT/ICETOOL 1
No new posts first column truncated in search result IBM Tools 13
No new posts convert file from VB to FB and use tr... DFSORT/ICETOOL 8
No new posts SDSF like solution in EJES (store com... All Other Mainframe Topics 4
No new posts executing XCTL command in COBOL witho... CICS 10
Search our Forums:

Back to Top