Interbank Database: TS-2068 and the Larken RAMdisk

See all articles from Sinc-Link v11 n1
Author(s): George Chambers
Publication: Sinc-Link
Pub Details: Sinc-Link v11 n1 (Volume 11, Issue 1)
Date: January/February 1993
Pages: 24-25

This is the first of two articles which will describe the insertion of blocks of prepared data into an interbank database.

One of the disks in our Larken disk library (#30) has programming which makes use of the Larken RAMdisk. It manages the memory chips in the RAMdisk in such a way as to create an immense database. Where the 2068 has about 38K of free memory, this program makes it possible to create a database of up to 282K.

The programming to make this possible was written by one of our members, Larry Crawford, and examples of it’s use are on the disk #30. It has languished in the library without much attention being paid to it. Until recently, that is. A few months ago I took another look at it, and became enchanted with it’s possibilities. When Bob Mitchell created the index of the Sinc-Link newsletter contents (published in the newsletter in recent issues), I found it rather frustrating to search out articles; it was still difficult to locate a specific article. Then an idea came to me. Why not make use of this interbank database program to hold the Sinc-Link index. This is an article about my experience.

The first thing to be decided was how large each record in the file should be. The database is designed to handle any size record, up to a maximum record size of 127 characters.

Many of the entries in Bob’s Sinc-Link index exceed 64 characters, some even larger than the 127 character limit. It seemd most expeditious to make the record size coincide with a Tasword file, that is, make each record equivalent to two lines of Tasword, 128 characters.

Larry’s program is based on the premise that the entries will be entered manually. This was not my intention. My plan was to massage the n/l index data (which is on library disk (#52) so that it would conform to the 127-character size I set for my database.

The ‘index’ data on disk #52 was in the form of Mscript files. Since it appeared easier to massage the data if it was in the form of Tasword files, I used another program in our library (on #55-Stephen Gunhouse Collection) called ‘WP Conversion’. This utility can convert an Mscript file to a Tasword file, and vice versa.

Incidentally the n/l index files were originally on an MSDOS disk, and were converted to Mscript files by using the conversion program on library disk #27 MSDOS/LARKEN.

Once the Mscript ‘index’ files were converted to Tasword, I edited them. That is to say, where an entry was longer than the 127 characters allowed, I split it into smaller records. With Tasword this was an easy matter; Each record had to use no more than 2 lines of Tasword. That is to say, every second line of Tasword was the start of a new record. I started each record with the newsletter ID, e.g. 9101 9/1 p.04. If an entry had to be split, each new entry had to be given this ID. This was the most tedious part of the job.

I needed a marker at the end of the actual data in each record (something like a period at the end of a sentence). But in this case I wanted the keyword ENTER (code 13). What I did was place an asterisk at the end of ea entry in the Tasword file. I then broke out of Tasword Basic and did a FOR/NEXT loop which searched through the text, replacing every appearance of the asterisk ‘code 42’ with the value 13.

Enter this in the front of your Tasword program:

1 GOTO 10
2 FOR N = 33280 TO (length of tasword file)
3 IF PEEK N = 42 THEN POKE N, 13
4 NEXT N: STOP

To use, enter GOTO 2. It will take a minute or so to complete. Don’t forget to delete this once you gave finished with it.

This marker ’13’ prevents the “empty” part of any record from showing on the screen. If there were no marker ’13’ there would be blank lines in the screen display of the record. In effect the marker tightens up the screen display.

Having saved the prepared Tasword files, now comes the touchy part; inserting it into the database.

We know the database starts at address 32768. How do we know that? Well, because that is where the bank-switching takes place; in the upper half of the computer memory, which starts at address 32768. We can verify that. Let’s try.

First load the interbank database SHELL. The disk has an AUTOSTART menu. Select option B. You will be presented with a CAT, showing one or more “.CC” files. Enter “SHELL”.

When it has loaded you will see a menu. Select option ‘N. New Database’. You will be asked for a name, then for the record length for this database. In our case we shall select the maximum. Enter 127. You will now return to the menu.

We shall enter our first record. Select Option A, then type in say, your name. Just a short name will do. With the name still on the screen, press the ENTER key. The next record entry will appear. This time we shall terminate the record entry by entering a STOP, i.e. the ‘shifted A’ key. This should bring you back to the menu. We now have our first entry in the database. Let’s look at it. Select Option ‘L’, and when asked, ask to start at record 1. The screen will show your name as record 1. The screen will ask you to “PRESS ANY KEY”. We want to break out into the Basic, so ‘break’ into the program with the usual way with the Break key and space bar.

This is about the only place in the program operation that you can break out into Basic. The other situation is where you have a screen display of records and the ‘scroll?’ indicator showing. Here, if you want to break out of the program, enter “N”. A “PRESS ANY KEY” will appear. Break out of the program with Break key and space bar.

We are now out of the program. Enter a LINE in the program:

1  FOR N = 32768 TO 65500: PRINT N, CHR$ PEEK N: NEXT N : STOP

Use GOTO 1. Never use RUN, or you will lose program variables. You will get a display on the left side of your screen showing a series of addresses, with the letters of your name opposite them. This is the start of the record area. Continue with scrolling. The screen will show emptiness, except for the addresses. Except that, depending on the record size you selected, you will presently come across a “STOP” entry.

Note this address; it is where the next entry will start. In our case, since you entered 127 as the record length, you will come across this ‘STOP’ at address 32896.

This will be significant when we come to loading in our ‘prepared’ Tasword files, which we will cover in our next article.