Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 7314

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: 7314

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 How to change the logon screen info o... sakthikumarT TSO/ISPF 4 Fri Dec 29, 2017 6:44 pm
No new posts Change NULL indicator in UNLOAD utility Khadhar Basha DB2 2 Fri Dec 15, 2017 3:01 pm
No new posts Extract record for change in combinat... Trinadh DFSORT/ICETOOL 6 Thu Nov 23, 2017 3:32 pm
This topic is locked: you cannot edit posts or make replies. Incrementing current time field by 30... arunsoods DFSORT/ICETOOL 11 Thu Oct 26, 2017 3:22 pm
No new posts sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us