View previous topic :: View next topic
|
Author |
Message |
sridevi2005
New User
Joined: 15 Sep 2005 Posts: 42
|
|
|
|
Hi,
I want to delete a paticular record in KSDS by using JCL.
Please provide the JCL code for me.
Thanks in Advance.
Sridevi |
|
Back to top |
|
|
Rupesh.Kothari
Member of the Month
Joined: 27 Apr 2005 Posts: 463
|
|
|
|
Hi,
Quote: |
I want to delete a paticular record in KSDS by using JCL. |
Is it possible to JCL?
Regards
Rupesh |
|
Back to top |
|
|
nikyojin
New User
Joined: 05 Oct 2005 Posts: 94
|
|
|
|
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 |
|
Back to top |
|
|
ikumar
New User
Joined: 02 Aug 2005 Posts: 81
|
|
|
|
Hi nikyojin,
can't we apply the 2nd step direcly on VSAM file |
|
Back to top |
|
|
Rupesh.Kothari
Member of the Month
Joined: 27 Apr 2005 Posts: 463
|
|
|
|
HI,
Quote: |
can't we apply the 2nd step direcly on VSAM file |
No We can not use DFSORT for VSAM.
Hope it clears your doubt.
Regards
Rupesh |
|
Back to top |
|
|
paulstephen
New User
Joined: 20 Oct 2005 Posts: 20 Location: Chennai
|
|
|
|
DFSORT is specifically meant for flat files |
|
Back to top |
|
|
rsshanmugam
New User
Joined: 08 Mar 2005 Posts: 62 Location: Basildon
|
|
|
|
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. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
Back to top |
|
|
|