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

Insert records into VSAM dataset


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

New User


Joined: 02 May 2008
Posts: 77
Location: chennai

PostPosted: Mon Feb 09, 2015 12:55 pm
Reply with quote

Hi,

I have a VSAM file and i need to insert some records inbetween. How do i do them using JCL
Code:

 Key                                       
 <===+>---10---+----2----+----3----+----4----+----5----
 IR0004  FUNCTIONS 01, 12, AND 13 REQUIRE FAC         
 IR0005  FUNCTIONS 02 AND 07 REQUIRE FAC AND TYPE     
 IR0006  FUNCTIONS 03, 05, 06 REQUIRE FAC AND ONE ONLY
 IR0007      AND INV         

Say, First 6 is the Key and i want to insert a line after the 'IR0004' and 'IR0006' how do i do this by using the JCL. how will be key reordered?
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8577
Location: Dubuque, Iowa, USA

PostPosted: Mon Feb 09, 2015 5:20 pm
Reply with quote

First, be aware that VSAM has several types -- ESDS, KSDS, RRDS, LDS -- so just saying your data set is VSAM does NOT imply that it has a key.

Second, use IDCAMS to REPRO the new records. As long as the keys are unique and your data set is sorted into ascending key sequence the records will be inserted correctly.

Third, if your key does not have gaps, such as yours, then you will need to unload the VSAM data set, create a new key with the added records in the appropriate places, and then reload the VSAM data set (by using the DELETE / DEFINE / REPRO functions of IDCAMS).
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 Is it possible to allocate DA dataset... All Other Mainframe Topics 2
No new posts Map VSAM Dataset to a Table/Tablespace DB2 2
This topic is locked: you cannot edit posts or make replies. copy file 2 data into file1 for match... DFSORT/ICETOOL 4
No new posts Write records with 3 or less rows in ... DFSORT/ICETOOL 3
No new posts Recreating VSAM cluster catalog info ... All Other Mainframe Topics 6
Search our Forums:

Back to Top