|
View previous topic :: View next topic
|
| Author |
Message |
chinnaraj
New User
Joined: 01 Nov 2007
Posts: 17
Location: Chennai
|
|
|
|
There's a VSAM file with 'n' records and I have to delete 10 records ( whose keys are A1,A2,A3...A10 ) in it and have to insert 10 new records (say New records keys as B1,B2,B3...B10) instead.
I want to perform this insertion & deletion using IDCAMS.
Regards,
Chinna. |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
Insert isn't a problem - use REPRO
But how to use IDCAMS to delete records - Can't be done. |
|
| Back to top |
|
|
ksathishkumar83
New User
Joined: 21 Nov 2006
Posts: 50
Location: India
|
|
|
|
Hi,
Copy the VSAM file contents to a Flat file. Delete the records you want to delete and insert new records in the Flat File.
Delete & Define the VSAM File .Repro the contents of Flat file to VSAM. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| Delete the records you want to delete and insert new records in the Flat File. |
Make sure the inserted new records are in sequence. |
|
| Back to top |
|
|
chinnaraj
New User
Joined: 01 Nov 2007
Posts: 17
Location: Chennai
|
|
|
|
| Thanks to everyone !!! |
|
| Back to top |
|
|
|
|
