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
 

 

SYNCSORT replace certain content of vsam into another vsam

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

New User


Joined: 25 May 2007
Posts: 61
Location: Coimbatore

PostPosted: Thu May 28, 2009 9:31 pm    Post subject: SYNCSORT replace certain content of vsam into another vsam
Reply with quote

I have a VSAM file with 808080 in the 30th to 40th position.
I just want to modify the 808080 to 909090 for all the records into another VSAM file.
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: Fri May 29, 2009 1:50 am    Post subject:
Reply with quote

Hello,

Your post shows 6 bytes, but mentions 11 positions. Show some proper sample input and the output you want from that input.
Back to top
View user's profile Send private message
Bhargav_1058

New User


Joined: 13 Dec 2008
Posts: 53
Location: New York

PostPosted: Fri May 29, 2009 1:36 pm    Post subject: Reply to: SYNCSORT replace certain content of vsam into anot
Reply with quote

Hi,

If your file is having all 808080 starting from 30th position to 40th position and if you want to change all of them then try below.

1). Copy your VASM to a flat file using below sort condition..

SORT FIELDS=COPY
INREC IFTHEN=(WHEN=(30,10,CH,EQ,C'8080808080'),OVERLAY=(30:C'9090909090'))

2). Copy the new output file from the above step to your VSAM file.

Thanks,
Bhargav.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri May 29, 2009 1:41 pm    Post subject:
Reply with quote

Why unload the file, SORT products can do VSAM >> VSAM
Back to top
View user's profile Send private message
Bhargav_1058

New User


Joined: 13 Dec 2008
Posts: 53
Location: New York

PostPosted: Fri May 29, 2009 1:45 pm    Post subject:
Reply with quote

Yeah thats true...

Sort can do VSAM to VSAM, not required to unload the VSAM.
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: Fri May 29, 2009 9:23 pm    Post subject:
Reply with quote

Hello,

The request mentions 11 positions, the "solution" only 10. . .
Quote:
Show some proper sample input and the output you want from that input.
Is it really so difficult to post proper information icon_sad.gif
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7999
Location: Bellevue, IA

PostPosted: Fri May 29, 2009 9:26 pm    Post subject:
Reply with quote

Quote:
Is it really so difficult to post proper information
Dick, if it was easy there would be more people doing it ... sigh.
Back to top
View user's profile Send private message
Pons

New User


Joined: 25 May 2007
Posts: 61
Location: Coimbatore

PostPosted: Thu Jun 11, 2009 2:38 am    Post subject:
Reply with quote

Hi Dick,

I gave the data for sample. All 11 bytes are like 80808080808.

Thanks bhargav. I will try your idea and let you know in case of any assistance.
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 Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts VSAM RLS=NRI while doing IDCAMS sheersh JCL & VSAM 1 Tue Mar 07, 2017 1:55 pm
No new posts SYNCSORT SEQNUM and FI fields. nartcr SYNCSORT 7 Sat Jan 21, 2017 4:02 am
No new posts Fail to change physical VSAM filename... jacobdng CICS 7 Fri Jan 20, 2017 12:36 pm


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