how to delete an empty record in ksds



how to delete an empty record in ksds

Postby hemachandar519 » Sun Aug 22, 2010 9:03 pm

CAN WE DELETE AN EMPTY RECORD FROM KSDS...... IF S HOW..
hemachandar519
 
Posts: 2
Joined: Sun Aug 22, 2010 7:31 pm
Has thanked: 0 time
Been thanked: 0 time

Re: how to delete an empty record in ksds

Postby Robert Sample » Sun Aug 22, 2010 9:05 pm

A KSDS file cannot have an empty record -- by definition of both KSDS and VSAM. So there is nothing to delete.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: how to delete an empty record in ksds

Postby hemachandar519 » Mon Aug 23, 2010 10:05 am

but i have a record in ksds whose key value is not there...
it is showing the entire record as ----------------------------------------------------------------
hemachandar519
 
Posts: 2
Joined: Sun Aug 22, 2010 7:31 pm
Has thanked: 0 time
Been thanked: 0 time

Re: how to delete an empty record in ksds

Postby dick scherrer » Mon Aug 23, 2010 10:21 am

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to Interview Questions

 


  • Related topics
    Replies
    Views
    Last post