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
 

 

Change Field value to a Constant (ZERO) Using SYNCSORT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: Change Field value to a Constant (ZERO) Using SYNCSORT
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7251

PostPosted: Sat Apr 28, 2012 3:13 am    Post subject: Re: Change Field value to a Constant (ZERO) Using SYNCSORT
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    Post subject: Reply to: Change Field value to a Constant (ZERO) Using SYNC
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7251

PostPosted: Tue May 01, 2012 10:35 pm    Post subject: Reply to: Change Field value to a Constant (ZERO) Using SYNC
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    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 INVALID FIELD OR CONSTANT IN SORTOF ?? Ron Klop DFSORT/ICETOOL 8 Wed Jan 11, 2017 3:44 pm
No new posts Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am
No new posts Performing arithmetic on input field zh_lad DFSORT/ICETOOL 31 Tue Dec 06, 2016 8:04 pm
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm


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