Insert a rec in vsam file

prabs2006 · Active User Joined: 12 Jan 2006 Posts: 103

Can we insert a reccord in KSDS vsam file by editing it?
If not, h can we do the same in JCL

parikshit123 · Active User Joined: 01 Jul 2005 Posts: 269 Location: India

Hi,

I think, you can use WRITE statement to insert a record in a VSAM cluster. Make sure that you handle duplicat keys and/or key out of sequence errors.

I am not really sure how to do that using JCL.

SBMF390 · New User Joined: 27 Jul 2006 Posts: 9

1. Using JCL.
-You must have the new record in a flat file1.
-Repro the content of VSAm file in another File2.
-Sort in File1 and File2 into another file3.
Sort in AScending using the VASM Key.
Now Delete define the VSAM file and repto the sorted file3 into VSAM file.

2. By cobol program

3. By File Aid in Edit mode, insert it in between the two records such that the Key is between upper and below records.