Delete a paticular record in KSDS by using JCL

sridevi2005 · New User Joined: 15 Sep 2005 Posts: 45

Hi,

I want to delete a paticular record in KSDS by using JCL.
Please provide the JCL code for me.

Thanks in Advance.
Sridevi

Rupesh.Kothari · Member of the Month Joined: 27 Apr 2005 Posts: 486

Hi,

nikyojin · Active User Joined: 05 Oct 2005 Posts: 88

Hi sridevi,
I don't think this is directly possible...but i can provide u a soln...
1) copy the vsam file to a flat file.
2) Using DFsort omit the record to be deleted in the flat file
3) copy the flat-file again to the vsam file

ikumar · Active User Joined: 02 Aug 2005 Posts: 86

Hi nikyojin,
can't we apply the 2nd step direcly on VSAM file

Rupesh.Kothari · Member of the Month Joined: 27 Apr 2005 Posts: 486

HI,

paulstephen · New User Joined: 20 Oct 2005 Posts: 23 Location: Chennai

DFSORT is specifically meant for flat files

rsshanmugam · Posted: Mon Oct 24, 2005 3:25 pm Post subject:

DFSORT can be used for both flat and VSAM files, in this situation we start from the second step directly there is no harm as i did like this many times .

Rupesh.Kothari , nikyojin and paulstephen please change your perception on DFSORT.

Frank Yaeger · Posted: Mon Oct 24, 2005 9:41 pm Post subject: