Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

COUNT in trailer

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
shr_amar
Warnings : 2

Active User


Joined: 02 May 2005
Posts: 126
Location: UK

PostPosted: Sat Apr 17, 2010 9:51 pm    Post subject: COUNT in trailer
Reply with quote

Hello all ,

Wish to count the specific field and write to the trailer.

i/p file is VB RL =6

XXXX1
YYYYY2

O/P SHOULD BE vb RL=6

XXXX1
YYYYY2
CNT=3

THAT MEANS LAST 5 BYTE IS ADDED AND WRITTEN TO TRAILER.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Apr 18, 2010 1:29 am    Post subject:
Reply with quote

Hi Frank,

Sorry for the intrusion. . .

@shr_amar,

You have been a member here for almost 5 years and have seen what is available for your use.

What reason is there that you have not looked in the forum and used one of the solutions already available? Suggest you "clone" one pf the posted solutions and reply here if needed. If you need to ask about something, post the jcl and control statements you used, the messages generated by the process including messag ids, and your problem/question.
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Sun Apr 18, 2010 2:05 am    Post subject:
Reply with quote

Hi Frank,

Me too...

shr_amar,
how about something roughly based upon:
Code:
  SORT FIELDS=(1,4,CH,A)
    OUTFIL ...
      TRAILER1=('CNT=',TOT=(5,1,)))
Back to top
View user's profile Send private message
sqlcode1

Active Member


Joined: 08 Apr 2010
Posts: 578
Location: USA

PostPosted: Mon Apr 19, 2010 6:40 am    Post subject:
Reply with quote

CICS Guy,
OP's file is VB, you need to account for RDW and sort fields should start at 5th byte.

shr_amar,
What do you mean when you say, "THAT MEANS LAST 5 BYTE IS ADDED AND WRITTEN TO TRAILER."??

Thanks,
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Mon Apr 19, 2010 7:46 am    Post subject:
Reply with quote

sqlcode1 wrote:
OP's file is VB, you need to account for RDW and sort fields should start at 5th byte.
Yes, small details....
CICS Guy wrote:
roughly based
...
sqlcode1 wrote:
What do you mean when you say, "THAT MEANS LAST 5 BYTE IS ADDED AND WRITTEN TO TRAILER."??
That should be fairly clear based upon the OP's input and expected output examples....
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to update a portion of text in a ... Bill Woodger DFSORT/ICETOOL 25 Wed Nov 09, 2016 9:41 pm
No new posts abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm
No new posts Get Record count in summary record fo... Atul Banke DFSORT/ICETOOL 21 Fri Sep 23, 2016 4:17 pm
No new posts Update the Sortout file with record c... karthik_sripal SYNCSORT 8 Tue May 17, 2016 8:52 pm
No new posts CQM : Exec count is 0 but getpages &g... soundarr DB2 1 Thu Mar 17, 2016 10:08 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us