Page 1 of 1

how to delete an empty record in ksds

PostPosted: Sun Aug 22, 2010 9:03 pm
by hemachandar519
CAN WE DELETE AN EMPTY RECORD FROM KSDS...... IF S HOW..

Re: how to delete an empty record in ksds

PostPosted: Sun Aug 22, 2010 9:05 pm
by Robert Sample
A KSDS file cannot have an empty record -- by definition of both KSDS and VSAM. So there is nothing to delete.

Re: how to delete an empty record in ksds

PostPosted: Mon Aug 23, 2010 10:05 am
by hemachandar519
but i have a record in ksds whose key value is not there...
it is showing the entire record as ----------------------------------------------------------------

Re: how to delete an empty record in ksds

PostPosted: Mon Aug 23, 2010 10:21 am
by dick scherrer
Hello,

but i have a record in ksds whose key value is not there...
Yes, it is there. . . It is simply not what you want it to be.

Determine what value is in the key (look at the record in hex) and delete that record.

Or unload the file and delete the problem record in batch and reload the good records.