VSAM File Delete, Insert - IDCAMS

chinnaraj · New User Joined: 01 Nov 2007 Posts: 16 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.

expat · Posted: Fri Jun 27, 2008 6:17 pm Post subject:

Insert isn't a problem - use REPRO

But how to use IDCAMS to delete records - Can't be done.

ksathishkumar83 · New User Joined: 21 Nov 2006 Posts: 46 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.

dick scherrer · Posted: Sat Jun 28, 2008 12:05 pm Post subject:

Hello,

chinnaraj · New User Joined: 01 Nov 2007 Posts: 16 Location: Chennai

Thanks to everyone !!!