Museum

Home

Lab Overview

Retrotechnology Articles

⇒ Online Manual

Media Vault

Software Library

Restoration Projects

Artifacts Sought

RDB/VMS SQL USER — VMS RDB_4.0

 By default, specifies the user name of the process that invokes
 interactive SQL or runs a program.  Consider an application used
 by several people to record their sales.  The application
 identifies the sales person by assigning USER to a column in the
 table:

 EXEC SQL
 INSERT INTO SALES_LOG
         (DATE, AMOUNT, SALES_PERSON)
         VALUES
         (:SALE_DATE, :SALE_AMOUNT, USER)
 END-EXEC

 Sales people could then easily retrieve logs of their sales:

 SQL> SELECT * FROM SALES_LOG
 cont>   WHERE SALES_PERSON = USER;

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