View previous topic :: View next topic
|
Author |
Message |
Knowledge Hunter
New User
Joined: 17 Aug 2006 Posts: 22 Location: India
|
|
|
|
hi all,
Is there an utility or jcl avaiable to delete the records in a VSAM dataset without unclustering it.
Regards,
Yogesh |
|
Back to top |
|
|
dineshness
New User
Joined: 25 Dec 2006 Posts: 63 Location: Perambalur
|
|
|
|
I think individually emptying the Data and Index component of the VSAM cluster would essentially mean deleting all the records in the CLUSTER without deleting the CLUSTER itself.
Dinesh. |
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
Use omit cond=all like below
//sortin dd dsn=your.vsam,disp=old
//sortout dd dsn=your.vsam,disp=old
//sysin dd *
sort fields=copy
omit cond=all
/*
This solves your problem |
|
Back to top |
|
|
Knowledge Hunter
New User
Joined: 17 Aug 2006 Posts: 22 Location: India
|
|
|
|
thanks for you inputs |
|
Back to top |
|
|
Knowledge Hunter
New User
Joined: 17 Aug 2006 Posts: 22 Location: India
|
|
|
|
hi Murali,
i tried your solution, but i am getting
"VSAM OPEN ERROR -- A8" error and job abends with U0016. since the file is opened in DISP=OLD in sortin, it is unavaiable for SORTOUT step.
Kindly throw some light on this. |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
Knowledge Hunter wrote: |
Is there an utility or jcl avaiable to delete the records in a VSAM dataset without unclustering it. |
Use Idcams repro from an empty dataset to the vsam file with the reuse parameter. |
|
Back to top |
|
|
|