I don't know the precise answer, but when I first started working on our
KSAM database (10+ years ago) I asked why every file had two slack bytes
at the FRONT of every record.   Someone explained that CM ksam used
these two bytes to mark deleted records.  I've never bothered to
challenge this standard at my firm - although I have always wondered why
you would want to read deleted records anyway.  

However, what I can say is that KSAMXL has a ";REUSE" option - allowing
ksam to re-use space on files.  Very useful if you have a file whose
contents are volatile.   The natural consequence of this is that you
can't always rely upon being able to retrieve deleted data.  

P.s. I have once seen an application abort because KSAM reported back
that the "current record was marked for deletion".  And it is possible
to read KSAM files by relative record numbers - in which case (I think)
you can direclty read deleted records but are (at least) warned that the
record is deleted. 

-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
Behalf Of Brian Donaldson
Sent: 30 October 2004 01:23
To: [log in to unmask]
Subject: [HP3000-L] KSAMXL Delete Question

When a record is deleted from a KSAMXL file how does the file system
flag this record as being (logically) deleted? -- low-values in the 1st
two bytes of the record, asterisks....??

Inquiring minds want to know...

TIA,
Brian Donaldson.

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________




The contents of this email are confidential to the intended recipient
and may not be disclosed. Although it is believed that this email and
any attachments are virus free, it is the responsibility of the recipient to confirm this.

Smith & Williamson Corporate Finance Limited - A member of M&A
International Inc. http://www.mergers.net Registered in England No.
4533970. Authorised and regulated by the Financial Services Authority 
Smith & Williamson Investment Management Limited, Registered No. 976145. Authorised and regulated by the Financial Services Authority.
Smith & Williamson Pension Consultancy Limited - Independent
Intermediary. Registered No. 3133226. Authorised and regulated by the
Financial Services Authority.
Smith & Williamson Fund Administration Limited, Registered No. 1934644. Authorised and regulated by the Financial Services Authority.
Smith & Williamson Limited - A member of Nexia International.
Registered in England No. 4534022. Regulated by the Institute of
Chartered Accountants in England & Wales for a range of investment
business activities.

Registered Office: No 1 Riding House Street, London W1A 3AS
Telephone: 020 7637 5377 http://www.smith.williamson.co.uk

Nexia Audit Limited - A member of Nexia International. Registered in
England No. 4469576. Registered to carry on audit work and regulated by the Institute of Chartered Accountants in England & Wales for a range of investment business activities.

Registered Office: No 1 Riding House Street, London W1A 3AS
Telephone: 020 7637 5377 http://www.nexiaaudit.co.uk

NCL Investments Limited, Registered No. 1913794.
Member of the London Stock Exchange authorised and regulated by the Financial Services Authority.

Registered Office: Bartlett House, 9-12 Basinghall Street, London  EC2V 5NS
Telephone: 020 7600 2801 


______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *