HP3000-L Archives

November 2003, Week 4

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: Removing deleted recs from KSAM/xl file
From:
Tracy Pierce <[log in to unmask]>
Reply To:
Tracy Pierce <[log in to unmask]>
Date:
Tue, 25 Nov 2003 10:05:50 -0800
Content-Type:
text/plain
Parts/Attachments:
text/plain (41 lines) 
OOPS, yes, you are correct.  instead of
KSAMUTIL > ERASE,
try
PURGE FLATFILE
FCOPY FROM=KSAMFILE;TO=FLATFILE;NEW
PURGE KSAMFILE
BUILD KSAMFILE;KSAMXL;REC=-96,8,F,ASCII;KSAMXL;KEY=(B,3,6);REUSE
FCOPY FROM=FLATFILE;TO=KSAMFILE


> -----Original Message-----
> From: Jay Willis [mailto:[log in to unmask]]
> Sent: Tuesday, November 25, 2003 9:41 AM
> To: Tracy Pierce
> Subject: Re: Removing deleted recs from KSAM/xl file
>
>
> Tracy, I didn't think that ksamutil could be used on nm ksam
> files. Is that
> correct?
>
> Tracy Pierce wrote:
>
> > reasonable KSAM maintenance includes, IMHO, an occasional
> reorganization,
> > which will make the file run more efficiently by placing
> records in physical
> > sequence.  this simple procedure doesn't care if your ksam
> is xl or classic,
> > and doesn't address the issue of fullness...
> >
> > :FCOPY FROM=KSAMFILE;TO=FLATFILE;NEW
> > :KSAMUTIL
> > >ERASE KSAMFILE
> > >EXIT
> > :FCOPY FROM=FLATFILE;TO=KSAMFILE
>

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

ATOM RSS1 RSS2