Museum

Home

Lab Overview

Retrotechnology Articles

⇒ Online Manual

Media Vault

Software Library

Restoration Projects

Artifacts Sought

RDB/VMS SQL DBKEY — VMS RDB_4.1A

 Database keys are internal pointers to specific table rows in a
 database.  Application programs can use the DBKEY keyword in SQL
 statements to refer to the database key for a table row.

 SQL statements that retrieve rows by specifying their database keys
 have the following advantages:

  o  Fast access:  retrieval through database keys is direct and
     bypasses any indexed or sequential searches.

  o  Reduced locking of data:  since access is direct, the database
     system locks only the row retrieved or updated.

  o  Assurance of uniqueness:  within the database key scope specified
     in ATTACH, DECLARE ALIAS, or CREATE DATABASE, database keys are
     guaranteed to be unique.  This means singleton SELECT statements
     based on database keys will never return more than a single row,
     and that they will return the exact same row, or an error if it
     was deleted.

Typewritten Software • bear@typewritten.org • Edmonds, WA 98026