LARKEN Sequential/Random Files Utility

See all articles from Sinc-Link v7 n3
Author(s): Bob Mitchell
Publication: Sinc-Link
Pub Details: Sinc-Link v7 n3 (Volume 7, Issue 3)
Date: May/June 1989
Pages: 16

STOP THE PRESS SOFTWARE REVIEW

LARKEN SEQUENTIAL/RANDOM FILES UTILITY

Larry Kenny (Larken Electronics Navan Ontario) has recently provided a new software offering based on the concept of sequential filing previously included in the version 3 LKDOS EPROM. This utility is available on disk and provides users of earlier LKDOS EPROMs with the opportunity to get into the world of random/sequential filing; even for version 3 holders, it provides added capabilities for using this ram-resident extension to the LKDOS system.

The utility allows the LKDOS-2068 to handle large data base files and exploits features of the 2068 hitherto unused. Up to four files may be accessed simultaneously to permit data to be sorted, merged, etc.

Included with the disk is a very thorough seven-page document of explanations and instructions. It is well organized and relatively simple to follow; but it took me several readings along with trying the example file to begin to absorb the complexities of the system and there are still parts that will require much more study and application.

The disk contains the main BASIC program <SRcode.B1> which will in turn load in the operating code <LBASE.BC> as a long REM statement (about 2500 bytes). When the program is RUN, the BASIC memory map is initialized and the BASIC “start of program pointer”(system variable 23635/6) is changed to an address well past the end of the REM statement to make it invisible in the listing and safe from everything except the NEW command.

In the version 3 EPROM, the sequential filing system has two modes: OUT and IN. In the disk version data is handled in two modes: Output (OUT) and Random Access (RND). OUT is used to create a file or to add more data to an existing file.

RND is used to print or get data from existing files; data can be read sequentially from start to end of the file OR can be randomly accessed from anywhere in the file and then read or changed; the latter is accomplished using a new TAB command and it is this feature that is not available in the EPROM. This opens up all sorts of possibilities for handling large amounts of data (up to 800K on a quad disk drive).

The documentation gives examples to show how all this done and this exercises the grey matter slightly more than somewhat. To make it a bit easier to follow, a sample data base is included on the disk: <TIMEDESGN> which is a contents list of Time Designs Magazine articles. The file <LBASE.B1> should be examined carefully to determine how the random filing system works and along with the documentation, things begin the get clearer. It is best to make a copy of the listing for closer study. But take care: If after <TIMEDESGN> has been opened, you wish to study the BASIC or to make some changes, you must first close the file. If you forget to do this and BREAK into BASIC, you will have to use <RAND USR 26800: CLOSE# 7> and then GO TO 1 to set things right again.

Searching for any given string is a feature of the disk version of Sequential/Random Filing; it is very versatile and recognizes any input in either upper or lower case, eg, entering a string <LARKEN> would also turn up records with <larken> or <Larken> or even <LaRkEn>.

The LBASE sample that is included on the disk is not complete as a text editor; neither is it a word processor; rather it is an example of what can be done with the Sequential/Random (S/R) Filing system. The instructions make this point in a section entitled <Adding new features to LBASE>. For example, a sort routine might be added either in machine code or as a compiled BASIC add-on. I found it eas[y] to add a routine to print any given record to either the 2040 or wide printer. Some hints are given on how to accomplish this but this will call for some ingenuity on the part of Larken users.

This review has touched on only a small part of the detail contained in the Larken documentation. It is a utility for the serious programmer and is recommended for those who want to extend the use of the 2068 to very large data bases. Much work would have to be done to merge the S/R filing concept with other features found in data base programs such as Profile.

Bob Mitchell 890509