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
 

 

Update Record count in Exisitng trailer record

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Sriramhari

New User


Joined: 11 May 2009
Posts: 17
Location: Bangalore

PostPosted: Sun Mar 10, 2013 4:18 pm    Post subject: Update Record count in Exisitng trailer record
Reply with quote

Hi All,
Need to update the Total record count and detail record count in the existing trailer record.
By using ICETOOL count is getting updated, but not as expected.
By giving the below sort card,
Code:
//CTL1CNTL DD *
   ......................
   IFTHEN=(WHEN=INIT,OVERLAY=(151:SEQNUM,9,ZD)), 
   IFTHEN=(WHEN=(1,1,CH,EQ,C'T'),                 
      OVERLAY=(2:151,9,ZD,TO=ZD,LENGTH=9,                             
               15:151,9,ZD,SUB,+2,TO=ZD,LENGTH=9))


Output looks like,
Code:
T00000083600000083D
(It should be 834 not 83D)

if i remove LENGTH=9 output looks like,
Code:
T000000836      834
(It should be 000000834 not 834)

Any suggestion please.

Thanks,

Code:
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7232

PostPosted: Sun Mar 10, 2013 4:30 pm    Post subject: Reply to: Update Record count in Exisitng trailer record
Reply with quote

Use EDIT or TO=ZDF.

You could also look at OUTFIL's IFTRAIL to replace your coding more conveniently.
Back to top
View user's profile Send private message
Sriramhari

New User


Joined: 11 May 2009
Posts: 17
Location: Bangalore

PostPosted: Sun Mar 10, 2013 8:11 pm    Post subject: Reply to: Update Record count in Exisitng trailer record
Reply with quote

Thanks a lot Bill, TO=ZDF worked as expected.

Thanks,
Back to top
View user's profile Send private message
mistah kurtz

Active User


Joined: 28 Jan 2012
Posts: 268
Location: Room: TREE(3). Hilbert's Hotel

PostPosted: Mon Mar 11, 2013 2:44 pm    Post subject:
Reply with quote

Hi Sriramhari

just out of curiosity..I wanted to know..if u were using Syncsort OR DFSort?
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7232

PostPosted: Mon Mar 11, 2013 3:03 pm    Post subject: Reply to: Update Record count in Exisitng trailer record
Reply with quote

Good spot mistah kurtz. Thanks.
Back to top
View user's profile Send private message
mistah kurtz

Active User


Joined: 28 Jan 2012
Posts: 268
Location: Room: TREE(3). Hilbert's Hotel

PostPosted: Tue Mar 12, 2013 9:48 am    Post subject:
Reply with quote

Thanks Bill. But I don't think I will get an answer considering that it 'worked as expected' !!
Back to top
View user's profile Send private message
Sriramhari

New User


Joined: 11 May 2009
Posts: 17
Location: Bangalore

PostPosted: Thu Apr 04, 2013 6:50 am    Post subject:
Reply with quote

Hi Mistah Kurtz,
It is SyncSort.

Thanks,
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts -913/-911 Deadlock during UPDATE stat... NoSleep319 DB2 5 Fri Nov 18, 2016 12:37 am
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 Updating Cursor row withour using FOR... chandan.inst DB2 15 Tue Nov 08, 2016 11:17 am
No new posts abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm
No new posts sort with previous record anatol DFSORT/ICETOOL 9 Thu Oct 06, 2016 2:36 am


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