When a UniVerse Table or File is created using command defaults, three things come into existence. These are the data portion of the file, the dictionary portion of the file, and the VOC entry that describes the physical location of the other two, as well as specifying the name that users use to access that file. The data portion of the file, for most file...

SUBROUTINE TEACHER.TO.STUDENT (STUDENT.IDS, TEACHER.ID)** Returns a list of STUDENT keys for a supplied TEACHER id.* Version 3 – accessing the raw index file*COMMON /TEACHER.TO.STUDENT/OPEN.FILE,FILE.STUDENT_TEACHER.ID*RESULT = ""IF NOT(OPEN.FILE) THEN   OPEN "","STUDENT_TEACHER.ID" TO FILE.STUDENT_TEACHER.ID ELSE RETURN   OPEN.FILE = @TRUEEND*READ STUDENT.IDS...

Giving UniVerse Secondary Indexes a Second ChanceType 25 (B-tree) FilesSecondary Indexes are implemented using Type 25 (B-tree) Files. The records in a type 25 file are stored in sorted order, not hashed like Types 2-18 and 30. These files can be read or written just like others, or they can be browsed forwards and backwards, and they are extremely efficient. ...

Giving UniVerse Secondary Indexes a Second Chance UniVerse Secondary Indexes promise speedy selects with automatic updates but I know programmers who avoid them because they seem too awkward to access from Basic or take too long to build. By setting up pointers directly to the internal B-tree index files, we can access data in a more familiar fashion and...

Rocket U2 is a suite of database management (DBMS) and supporting software now owned by Read More...