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: 8132
Location: East Dubuque, Illinois, USA

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 Multiple VSAM files single output fil... Mohan Kothakota DFSORT/ICETOOL 11 Wed Aug 09, 2017 7:57 pm
No new posts Fileaid Update Replace with null string descann Compuware & Other Tools 4 Mon May 15, 2017 3:00 pm
No new posts Replace values in the input data Vikas Maharnawar DFSORT/ICETOOL 10 Thu May 11, 2017 2:18 pm
No new posts VSAM Space Allocation mrgnndhmk JCL & VSAM 7 Sat Apr 22, 2017 12:42 am
No new posts Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm


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