|
|
| Author |
Message |
chinnaraj
New User
Joined: 01 Nov 2007
Posts: 6
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 |
|
 |
References
|
 Posted: Fri Jun 27, 2008 4:04 pm Post subject: Re: VSAM File Delete, Insert - IDCAMS |
|
|
|
|
| Moved: Fri Jun 27, 2008 4:50 pm by superk From Compuware Tools to SMS & VSAM |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 2912
Location: Brussels once more ...
|
|
|
|
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: 44
Location: chennai
|
|
|
|
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
Global Moderator
Joined: 23 Nov 2006
Posts: 7470
Location: 221 B Baker St
|
|
|
|
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: 6
Location: Chennai
|
|
|
|
| Thanks to everyone !!! |
|
| Back to top |
|
|
|
|
