Post-Relational Database Command Reference
 UNIVERSE 
 BASIC 
 BASIC
   ABORT
   ASSIGNMENT
   BOOLEAN
   BRANCHING
   BSD
   COMPILE.TIME
   CONSTANT
   DIMENSION
   DYNAMIC
   EQUATE
   EXECUTE
   IO
   MATH
   NLS
   SQL
   STRING
   SYSTEM
   TABLE
   TAPE
   TBD
   TRANSACTION
   TRANSFORM
 PROC
   BRANCHING
   BUFFER
   EXECUTE
 TCL
   ANALYSIS
   IO
   SYSTEM
C Index: C  D  F  L  M  O  R  S  U  W  
CLEARFILEDeletes all the records in a table's data section or dict section.
CLOSEReleases all locks related to a file variable.
CLOSESEQReleases all locks associated with a sequential file variable.
CREATEUsed with OPENSEQ to create new O/S files (Types 1 and 19).
D Index: C  D  F  L  M  O  R  S  U  W  
DELETEThere are two delete commands. Both are explained here.
DELETELISTRemoves a record from the &SAVESLISTS& table.
DELETEUThis command acquires an update lock before deleting the record.
F Index: C  D  F  L  M  O  R  S  U  W  
FILEINFOProvides information about a file.
FILELOCKLocks an entire table.
FILEUNLOCKReleases a FILELOCK.
FLUSHUsed with OPENSEQ to make sure all writes have completed.
L Index: C  D  F  L  M  O  R  S  U  W  
LOCKAllow for the locking of non-table related resources.
M Index: C  D  F  L  M  O  R  S  U  W  
MATREADIdentical to READ except that the receiving dynamic array is replaced by a receiving dimensioned array.
MATREADUIdentical to READU except that the receiving dynamic array is replaced by a receiving dimensioned array.
MATWRITE Identical to WRITE except that the receiving dynamic array is replaced by a receiving dimensioned array.
MATWRITEUIdentical to WRITEU except that the receiving dynamic array is replaced by a receiving dimensioned array.
O Index: C  D  F  L  M  O  R  S  U  W  
ONUse ON as part of the GOSUB command or as part of the WRITE command.
OPENOPEN establishes a file handle.
OPENCHECKOPENCHECK establishes an SQL file handle.
OPENDEV
OPENPATH
OPENSEQ
R Index: C  D  F  L  M  O  R  S  U  W  
READRetrieves a record from the file and based on the record id
READLIST
READNEXTGets a value (typically an ID) from a select list, then moves the pointer forward to the next value.
READSEQ
READURetrieves a record from the file and based on the record id and sets an update lock
READVRetrieves a field from a record from the file and based on the record id
READVURetrieves a field from record from the file and based on the record id and sets an update lock
RECORDLOCKED
RECORDLOCKL
RECORDLOCKU
S Index: C  D  F  L  M  O  R  S  U  W  
SELECTCreates a pointer to an unsorted list of Table IDs, suitable for use with READNEXT.
U Index: C  D  F  L  M  O  R  S  U  W  
UNLOCKRelease a resource lock.
W Index: C  D  F  L  M  O  R  S  U  W  
WEOFSEQW(rite) E(nd) O(f) F(ile) marker on a sequential file.
WRITEWrites record back to a database table.
WRITELIST
WRITESEQ
WRITESEQF
WRITEUWrites data back to the database.
WRITEVWrites one field back to a database table.
WRITEVUWrites field back to a database table.

More Details or Suggestions?
           

MV Updated from a Post-Relational data table on 10:18:33 23 Apr 2010
Courtesy of Key Ally, Inc.
More information at U2-Users Group
UniVerse is a Trademark of Rocket Software. Previous, IBM, Informix, Ardent, and vMark.
DMOZ
Wikipedia
 


Post-Relational (adjective) relating to databases which are a superset of SQL and XML, offering highly structured data with both relational and multi-value approaches available.

PRDB Reference (noun) repository of commands, concepts, and code designed for the various Post-Relational databases.