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
A Index: A  B  C  D  E  F  G  I  L  N  O  P  R  S  T  U  W  Idea  Code  
ABORTStops execution and returns to command level.
B Index: A  B  C  D  E  F  G  I  L  N  O  P  R  S  T  U  W  Idea  Code  
BEGIN CASEBEGIN CASE and END CASE are designed to bracket a set of CASE statements.
BREAK KEYDetermins whether or not a user can issue a break command to interrupt the execution of a program.
C Index: A  B  C  D  E  F  G  I  L  N  O  P  R  S  T  U  W  Idea  Code  
CALLTransfer control to a subroutine, with the expectation that control will transfer back when the subroutine encounters a RETURN.
CASECASE statements are a cleaner form of cascading IF-THEN-ELSE.
CHAINUse this command to transfer control from on program to another with no method for returning.
CONTINUESkips to NEXT or RETURN in a loop.
D Index: A  B  C  D  E  F  G  I  L  N  O  P  R  S  T  U  W  Idea  Code  
DEFFUNMakes a function available withing a program. The function must exist in its own item.
DODO is a looping command.
E Index: A  B  C  D  E  F  G  I  L  N  O  P  R  S  T  U  W  Idea  Code  
ELSEIt is used only in conjunction with another branching command. THEN is the "Yes" path. ELSE is the "No" path.
ENDUsed by several different branching commands to end a conditional block of code. It can also be used to establish physical end of program, a point after which the compiler will ignore all text in a program.
END CASEBEGIN CASE and END CASE are designed to bracket a set of CASE statements.
END ELSEIt is used only in conjunction with another branching command. THEN is the "Yes" path. END ELSE is the "No" path.
ENTERUse this command to transfer control from on program to another with no method for returning.
EXITAllows process to exit out of the innermost loop. Should be managed by proper use of the inherent UNTIL / WHILE structure.
F Index: A  B  C  D  E  F  G  I  L  N  O  P  R  S  T  U  W  Idea  Code  
FORThis is a looping command, which is a special form of branching command, designed to repeat a block of code.
FUNCTIONThis is an alternative to the SUBROUTINE command.
G Index: A  B  C  D  E  F  G  I  L  N  O  P  R  S  T  U  W  Idea  Code  
GOUse this command when you want to jump to a different point in the code with no need to return.
GOSUBGOSUB allows a program to detour to a label within the same program and then resume from the original point when it encounters a RETURN.
GOTOUse this command when you want to jump to a different point in the code with no need to return.
I Index: A  B  C  D  E  F  G  I  L  N  O  P  R  S  T  U  W  Idea  Code  
IFThis is the primary branching command. I is used to include and excludeblocks of code dynamically at runtime.
INPUTIFAllows several things to be mashed into a single, poorly thought out command. Use INPUT instead and increase readability.
ISNULL
ISNULLS
L Index: A  B  C  D  E  F  G  I  L  N  O  P  R  S  T  U  W  Idea  Code  
LOCATEThere are two syntaxes for the LOCATE. Both are explained here.
LOOPInitiates a DO loop.
N Index: A  B  C  D  E  F  G  I  L  N  O  P  R  S  T  U  W  Idea  Code  
NEXTPart of the FOR loop.
NOTNOT reverses the logic of a boolean test. True is false. False is true.
NULLA compiler directive used to represent a NOOP condition. It means 'do nothing at this step.'
NUMS
O Index: A  B  C  D  E  F  G  I  L  N  O  P  R  S  T  U  W  Idea  Code  
ONUse ON as part of the GOSUB command or as part of the WRITE command.
P Index: A  B  C  D  E  F  G  I  L  N  O  P  R  S  T  U  W  Idea  Code  
PERFORMExecutes a command as if issued from the command line.
R Index: A  B  C  D  E  F  G  I  L  N  O  P  R  S  T  U  W  Idea  Code  
READNEXTGets a value (typically an ID) from a select list, then moves the pointer forward to the next value.
REPEATThis command indicates the end of a LOOP.
RETURNUsed to mark the end of a local subroutine (See: GOSUB) or external subroutine (See: CALL).
S Index: A  B  C  D  E  F  G  I  L  N  O  P  R  S  T  U  W  Idea  Code  
STEPOptional part of the FOR command.
STOPStops execution and returns to command level.
SUBRMarks a program as a subroutine.
SUBROUTINEMarks a program as a subroutine.
T Index: A  B  C  D  E  F  G  I  L  N  O  P  R  S  T  U  W  Idea  Code  
THENIt is used only in conjunction with another branching command. THEN is the "Yes" path. ELSE is the "No" path.
TOUsed in FOR, EQU, and EQUATE.
TRANSACTION ABORTAborts all of the work since TRANSACTION START was issued.
U Index: A  B  C  D  E  F  G  I  L  N  O  P  R  S  T  U  W  Idea  Code  
UNTILManges the exit from a DO or FOR loop.
W Index: A  B  C  D  E  F  G  I  L  N  O  P  R  S  T  U  W  Idea  Code  
WHILEManges the exit from a DO or FOR loop.
Idea Index: A  B  C  D  E  F  G  I  L  N  O  P  R  S  T  U  W  Idea  Code  
BRANCHINGWithout branching, programs would execute each command once, in order. Branching allows us to repeat sections of code, perform some sections conditionally, and skip others based on external events.
CASE 1CASE 1 is a common construct in BASIC.
Code Index: A  B  C  D  E  F  G  I  L  N  O  P  R  S  T  U  W  Idea  Code  
FUNCTIONExample of the FUNCTION and DEFFUN commands versus the SUBROUTINE and CALL commands.
VALIDATIONExamples of validation logic.

More Details or Suggestions?
           

MV Updated from a Post-Relational data table on 10:18:32 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.