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

Change Field value to a Constant (ZERO) Using SYNCSORT


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
amrit suri

New User


Joined: 18 Jun 2011
Posts: 2
Location: Hyderabad

PostPosted: Sat Apr 28, 2012 2:45 am
Reply with quote

Good Morning

I have a VB file with LRECL of 230.

In this file I have data in packed decimal format and have
values in columns 31-34 , 35-42 and 43-50. For solving one really lengthy problem I'm required to Change all the values in these columns (and only to these columns ) to ZERO.

Please note that I do not have any reference value that can be compared against and then CHANGE operator can be applied to replace values in these columns, in other words the values are UNKNOWN to and all have to changed to ZERO. ( Sorry for being redundant )

Could you please direct me an appropriate procedure which i can utilize to
find solution.

Also the installation in my Organization Support ONLY SYNCSORT "-SYNCSORT FOR Z/OS 1.3.2.2R".

Regards
Amit Suri
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Sat Apr 28, 2012 3:13 am
Reply with quote

Try:

Code:
  OPTION COPY
  INREC OVERLAY=(31:+0,TO=PD,LENGTH=4,
                 35:+0,TO=PD,LENGTH=8,
                 43:+0,TO=PD,LENGTH=8)



With a line of 66 Xs as input gives:

Code:
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX                    XXXXXXXXXXXXXXXX
EEEEEEEEEEEEEEEEEEEEEEEEEEEEEE00000000000000000000EEEEEEEEEEEEEEEE
777777777777777777777777777777000C0000000C0000000C7777777777777777
Back to top
View user's profile Send private message
amrit suri

New User


Joined: 18 Jun 2011
Posts: 2
Location: Hyderabad

PostPosted: Tue May 01, 2012 10:25 pm
Reply with quote

Hi Bill

Thanks a lot for your input , they were really helpful , i was able to achieve the results which i was looking for


Regards
Amit Suri
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Tue May 01, 2012 10:35 pm
Reply with quote

Glad it helped. Thanks for letting us know.
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 -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts 3270 personal communications. Can't c... TSO/ISPF 2
No new posts Join 2 files according to one key field. JCL & VSAM 3
No new posts SELECT from data change table DB2 5
Search our Forums:

Back to Top