PRDB ZEBRA by Key Ally, Inc.

Post-Relational Database Command Reference

ZEBRA
BASIC

BASIC
   ABORT
   ASSIGNMENT
   BOOLEAN
   BRANCHING
   COMPILE.TIME
   CONSTANT
   DIMENSION
   DYNAMIC
   EQUATE
   EXECUTE
   IO
   MATH
   STRING
   SYSTEM
   TABLE
   TAPE
   TBD
   TRANSFORM

A	Index: A B C D E F G H I L M N O P R S T U W X Symbol Idea Code
ABORT	Stops execution and returns to command level.
ABS	Returns the unsigned value.
ACOS	Returns the arc-cosine.
AND	Boolean AND.
ASIN	Calculates the arc-sine.
ASSIGNED	Determines if a variable has been assigned.
ATAN	Calculates the arc-tangent.
B	Index: A B C D E F G H I L M N O P R S T U W X Symbol Idea Code
BEGIN CASE	BEGIN CASE and END CASE are designed to bracket a set of CASE statements.
BREAK KEY	Determins 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 H I L M N O P R S T U W X Symbol Idea Code
CALL	Transfer control to a subroutine, with the expectation that control will transfer back when the subroutine encounters a RETURN.
CASE	CASE statements are a cleaner form of cascading IF-THEN-ELSE.
CHAIN	Use this command to transfer control from on program to another with no method for returning.
CHAR	Used to produce a single character based on its ASCII value.
CHECKSUM	Performs an CRC checksum.
CLEAR	DEPRECIATED. Used to clear all variables. This hides typographic errors in variables and is considered poor programming practice.
CLEARDATA	Clears all data stacked by the DATA statement.
CLEARFILE	Deletes all the records in a table's data section or dict section.
COL1	Only works in conjunction with a FIELD statment.
COL2	Only works in conjunction with the FIELD statement.
COMMON	Used to declare variables which persist after the completion of a called routine.
CONVERT	Converts each individual character in the old string to the new string character based on position in each string
COS	Returns the cosine.
COSH	Calculates the hyberbolic cosine.
COUNT	Counts the number of delimiters.
CREATE	Used with OPENSEQ to create new O/S files (Types 1 and 19).
CRT	Manages output to terminals.
D	Index: A B C D E F G H I L M N O P R S T U W X Symbol Idea Code
DATA	Adds data to the stack, which will be consumed by the next EXECUTE.
DATE	Returns the current date in internal format.
DCOUNT	Counts the number of delimited fields.
DEBUG	Invokes step-through mode for testing.
DELETE	There are two delete commands. Both are explained here.
DIM	Establishes the size of a dimensioned array.
DIMENSION	Establishes the size of a dimensioned array.
DISPLAY	Manages output to terminals.
DIV	Divides and throws away the remainder.
DO	DO is a looping command.
DTX	Convert Decimal to Hex.
E	Index: A B C D E F G H I L M N O P R S T U W X Symbol Idea Code
EBCDIC	Converts string to IBM ebcdic code.
ECHO	Controls whether or not output to terminal (standard out) is suppressed.
ELSE	It is used only in conjunction with another branching command. THEN is the "Yes" path. ELSE is the "No" path.
END	Used 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 CASE	BEGIN CASE and END CASE are designed to bracket a set of CASE statements.
ENTER	Use this command to transfer control from on program to another with no method for returning.
EOF	Submit Description:
EQU	Can be used like an EQUATE to define literals.
EQUATE	Can be used like an EQU to define literals.
ERRMSG	Submit Description:
EXECUTE	Executes a command as if issued from the command line.
EXTRACT	Submit Description:
F	Index: A B C D E F G H I L M N O P R S T U W X Symbol Idea Code
FIELD	Submit Description:
FIX	Submit Description:
FLUSH	Used with OPENSEQ to make sure all writes have completed.
FOOTING	Submit Description:
FOR	This is a looping command, which is a special form of branching command, designed to repeat a block of code.
G	Index: A B C D E F G H I L M N O P R S T U W X Symbol Idea Code
GO	Use this command when you want to jump to a different point in the code with no need to return.
GOSUB	GOSUB allows a program to detour to a label within the same program and then resume from the original point when it encounters a RETURN.
GOTO	Use this command when you want to jump to a different point in the code with no need to return.
GROUP	Submit Description:
H	Index: A B C D E F G H I L M N O P R S T U W X Symbol Idea Code
HEADING	Submit Description:
HUSH	Submit Description:
I	Index: A B C D E F G H I L M N O P R S T U W X Symbol Idea Code
ICONV	Converts a literal or variable based on a supplied set of rules
IF	This is the primary branching command. I is used to include and excludeblocks of code dynamically at runtime.
INCLUDE	Add source code from an external source at compile time.
INDEX	Submit Description:
INPUT	Submit Description:
INPUTERR	Submit Description:
INPUTIF	Allows several things to be mashed into a single, poorly thought out command. Use INPUT instead and increase readability.
INPUTNULL	Submit Description:
INSERT	Add source code from an external source at compile time.
INT	Submit Description:
L	Index: A B C D E F G H I L M N O P R S T U W X Symbol Idea Code
LEN	Submit Description:
LOCATE	There are two syntaxes for the LOCATE. Both are explained here.
LOCK	Submit Description:
LOOP	Initiates a DO loop.
LOWER	Converts the alphabetic characters to lowercase.
M	Index: A B C D E F G H I L M N O P R S T U W X Symbol Idea Code
MAT	Sets each element of a dimensioned array to the same value.
MATBUILD	Converts between dimensioned and dynamic arrays.
MATCH	Submit Description:
MATPARSE	Converts between dimensioned and dynamic arrays.
MATREAD	Identical to READ except that the receiving dynamic array is replaced by a receiving dimensioned array.
MATREADU	Identical 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.
MATWRITEU	Identical to WRITEU except that the receiving dynamic array is replaced by a receiving dimensioned array.
MOD	Submit Description:
N	Index: A B C D E F G H I L M N O P R S T U W X Symbol Idea Code
NEXT	Part of the FOR loop.
NOT	Submit Description:
NULL	Submit Description:
NUM	Submit Description:
O	Index: A B C D E F G H I L M N O P R S T U W X Symbol Idea Code
OCONV	Converts a literal or variable based on a supplied set of rules.
ON	Submit Description:
OPEN	OPEN establishes a file handle.
OR	Boolean OR.
P	Index: A B C D E F G H I L M N O P R S T U W X Symbol Idea Code
PAGE	Submit Description:
PERFORM	Executes a command as if issued from the command line.
PRECISION	Submit Description:
PRINT	Manages output to terminals or printers.
PRINTER	Submit Description:
PRINTERR	Submit Description:
PROCREAD	Submit Description:
PROCWRITE	Submit Description:
PROMPT	Submit Description:
PWR	Submit Description:
R	Index: A B C D E F G H I L M N O P R S T U W X Symbol Idea Code
RANDOMIZE	Submit Description:
READ	Retrieves a record from the file and based on the record id
READNEXT	Submit Description:
READT	Submit Description:
READU	Retrieves a record from the file and based on the record id and sets an update lock
READV	Retrieves a field from a record from the file and based on the record id
READVU	Retrieves a field from record from the file and based on the record id and sets an update lock
RELEASE	Submit Description:
REM	When used as the first non-whitespace character, it makes the line which follows it a remark. Otherwise, it calculates the remainders from division.
REMOVE	Submit Description:
REPEAT	Submit Description:
REPLACE	Submit Description:
RETURN	Submit Description:
REWIND	Submit Description:
RND	Submit Description:
S	Index: A B C D E F G H I L M N O P R S T U W X Symbol Idea Code
SELECT	Submit Description:
SIN	Submit Description:
SINH	Submit Description:
SLEEP	Submit Description:
SOUNDEX	Submit Description:
SPACE	Submit Description:
SQRT	Submit Description:
STEP	Optional part of the FOR command.
STOP	Stops execution and returns to command level.
STR	Creates a repeating string.
SUBROUTINE	Submit Description:
SUM	Submit Description:
SYSTEM	This is a way to get a lot of different data from the system. Some is generic to the entire system, some is specific to the state of your session.
T	Index: A B C D E F G H I L M N O P R S T U W X Symbol Idea Code
TABSTOP	Submit Description:
TAN	Calculates the tangent.
TANH	Calculates the hyberbolic tangent.
THEN	It is used only in conjunction with another branching command. THEN is the "Yes" path. ELSE is the "No" path.
TIME	Submit Description:
TIMEDATE	Submit Description:
TO	Used in FOR, EQU amd EQUATE.
TRIM	Convert a string by compressing multiple blanks into single blanks and eliminating leading blanks and trailing blanks.
U	Index: A B C D E F G H I L M N O P R S T U W X Symbol Idea Code
UNLOCK	Submit Description:
UNTIL	Manges the exit from a DO or FOR loop.
W	Index: A B C D E F G H I L M N O P R S T U W X Symbol Idea Code
WEOF	W(rite) E(nd) O(f) F(ile) marker on a tape.
WHILE	Manges the exit from a DO or FOR loop.
WRITE	Writes record back to a database table.
WRITEBLK	Submit Description:
WRITET	Submit Description:
WRITEU	Writes data back to the database.
WRITEV	Writes one field back to a database table.
WRITEVU	Writes field back to a database table.
X	Index: A B C D E F G H I L M N O P R S T U W X Symbol Idea Code
XTD	Converts a hexidecimal value to an integer.
Symbol	Index: A B C D E F G H I L M N O P R S T U W X Symbol Idea Code
!	When used as the first non-whitespace character, it makes the line which follows it a remark. Otherwise, it is used as a logical "OR".
#	Symbol for not equals (boolean test).
$INCLUDE	Add source code from an external source at compile time.
$INSERT	Add source code from an external source at compile time.
*	When used as the first non-whitespace character, it makes the line which follows it a remark. Otherwise, it is used as multiplication.
+	Symbol for addition.
-	Symbol for subtraction or unary minus.
/	Symbol for division.
<	Symbol for boolean Less-Than compare. Also used as close angle bracket.
<>	Symbol for not equals (boolean test). Also used as Angle brackets.
=	Symbol for equals (boolean test) or assignment.
>	Symbol for boolean Greater-Than compare. Also used as open angle bracket.
@	Used in managing cursor positioning on terminals.
@AM	Is a synonym for character 254, the Field Mark.
@FM	Is a synonym for character 254, the Field Mark.
@SVM	Is a synonym for character 252, the Subvalue Mark.
@VM	Is a synonym for character 253, the Value Mark.
Idea	Index: A B C D E F G H I L M N O P R S T U W X Symbol Idea Code
BRANCHING	Without 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.
CONSTANTS	Constants are values which cannot change during the course of execution.
VARIABLES	Variables are values which can change during the course of execution.
Code	Index: A B C D E F G H I L M N O P R S T U W X Symbol Idea Code
ANGLES	Example of Angle brackets.
ASSIGNMENT	Example of Assignment handling
BOOLEAN	Example of Boolean logic
COMMENT	Code which illustrates the three types of Comments
COUNT	Example of different counting options.
CURSOR	Cursor managment example.
DEFINE	This is how $DEFINE and its related commands work.
EQUATE	This is how constants are created.

More Details or Suggestions?

Updated from a Post-Relational data table on 10:18:38 23 Apr 2010
Courtesy of Key Ally, Inc.
General Automation is a Trademark of Tiger Logic

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.