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:
From:
Robert Mills <[log in to unmask]>
Reply To:
Robert Mills <[log in to unmask]>
Date:
Wed, 26 Nov 2003 10:09:59 -0000
Content-Type:
text/plain
Parts/Attachments:
text/plain (58 lines)
IIRC the originator of this thread stated that they had MPEX.

Do an %ERASE <ksamxlfilename> instead of doing a PURGE and BUILD. The
advantage of this method is that you would not have to modify the
DISC=<maxrecords> parameter in the build if you have done an %ALTFILE on it.

regards,

Robert W.Mills
Systems Development Manager
Windsong Services
(01689) 870622 x3005


Tracy Pierce <mailto:[log in to unmask]> wrote on 25 November 2003
18:06:

> 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 *

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

ATOM RSS1 RSS2