Statements and Functions by Category

This topic contains lists of DataBasic statements and functions categorised by function. Many statements and functions are listed in more than one category.

Accessing Proc

PROCREAD statement

PROCWRITE statement

Accessing TCL

CHAIN statement

PERFORM statement

Assignment

CLEAR statement

LET statement

MAT statement

Bit Manipulation

BITCHANGE function	BITCHECK function	BITLOAD function
BITRESET function	BITSET function

Branching

CASE statement	GO{TO} statement	IF statement
ON GO{TO} statement	INPUTTRAP statement

Data Definition

CLEAR statement	COMMON statement	DIMENSION statement
EQUATE statement	PRECISION statement	VARVALSET statement

Data Input

DATA statement	GROUPSTORE statement	IN statement
INPUT statement	INPUT@ statement	INPUT CTRL statement
INPUTERR{OR} statement	INPUTNULL statement	INPUTTRAP statement
PROCREAD statement	PROMPT statement

Data Output

CRT statement	FOOTING statement	HEADING statement
INPUTERR{OR} statement	PAGE statement	PRINT statement
PRINTER statement	PROCWRITE statement

Dimensioned Arrays

DIM{ENSION} statement	MAT statement	MATBUILD statement
MATPARSE statement	MATREAD statement	MATREADU statement
MATWRITE statement	MATWRITEU statement

Dynamic Arrays

DEL statement	FIND statement	FINDSTR statement
GROUPSTORE statement	INS statement	LOCATE statement
REMOVE statement	SORT function

Execution Locks

LOCK statement

UNLOCK statement

File I/O

Format Conversions

ASCII function	CHAR function	DOWNCASE function
DTX function	EBCDIC function	FMT function
ICONV function	OCONV function	SEQ function
UPCASE function	XTD function

Item Lists and Indexes

CLEARSELECT statement	FORMLIST statement	GETLIST statement
PERFORM statement	POSITION statement	READLIST statement
READNEXT statement	READPREV statement	SELECT statement
SELECTE statement	SELECTINFO function	WRITELIST statement

Item Locks

MATREADU statement	MATWRITE statement	MATWRITEU statement
READ statement	READU statement	READVU statement
RECORDLOCKED function	RELEASE statement	WRITE statement
WRITEU statement	WRITEV statement	WRITEVU statement

Inter-process Communication (IPC)

ACCEPT statement	CONNECT statement	DISCONNECT statement
RECEIVE statement	RECWAIT statement	SEND statement

Logical

ALPHA function

NOT function

NUM function

Looping

FOR statement	LOOP statement	NEXT statement
REPEAT statement	UNTIL statement	WHILE statement

Manipulating Dynamic Array Elements

DELETE function	EXTRACT function	INSERT function
MAXIMUM function	MINIMUM function	REPLACE function
SUM function	SUMMATION function

Maths/Numeric

ABS function	COS function	EXP function
INT function	LN function	MOD function
PWR function	REM function	RND function
ROUND function	SIN function	SQRT function
TAN function	TRUNC function

Miscellaneous

$CHAIN statement	$INCLUDE statement	$OPTIONS statement
@ function	ASSIGN statement	BCC function
BREAK statement	CRC function	DEBUG statement
DQUOTE function	ECHO statement	GETMSG function
GROUP function	INCLUDE statement	NULL statement
PRINTERR statement	PROGRAM statement	PTR function
REM statement	RQM statement	SENTENCE function
SLEEP statement	SPOOLER function	SQUOTE function
UNASSIGNED function

Pointer File Referencing

DELETELIST statement	GETLIST statement	READLIST statement
READNEXT statement	WRITELIST statement

Program Termination

ABORT statement

END statement

STOP statement

Program-to-Program Communication

See Interprocess Communication.

Sequential File Access

CLOSESEQ statement	DELETESEQ statement	FLUSH statement
OPENSEQ statement	READBLK statement	READSEQ statement
SEEK statement	WEOFSEQ statement	WRITEBLK statement
WRITESEQ statement

String/Substring Manipulation

CHANGE function	CHECKSUM function	COL1/COL2 function
CONVERT function	CONVERT statement	COUNT function
DCOUNT function	DECRYPT function	ENCRYPT function
FIELD function	FOLD function	INDEX function
LEN function	SOUNDEX function	SPACE function
STR function	TRIM function	TRIMB function
TRIMF function

Subroutine Branching

CALL statement	GOSUB statement	INPUTTRAP statement
ON GOSUB statement	RETURN statement	SUB{ROUTINE} statement

System Interaction

ACCESS function	ASSIGN statement	BREAK statement
CALL statement	CHAIN statement	COLLECTDATA statement
DATA statement	DEBUG statement	ECHO statement
ENTER statement	PERFORM statement	PRINTERR statement
PROCREAD statement	PROCWRITE statement	PROMPT statement
RQM statement	RTNDATA statement	SLEEP statement
SYSTEM function	SYSTEM statement

Tape I/O

READT statement	REWIND statement	WEOF statement
WRITET statement

Time and Date

DATE function

TIME function

TIMEDATE function

Transaction Handling

TRANSABORT statement	TRANSEND statement	TRANSQUERY function
TRANSTART statement

Variable Checking

VARTYPE function

VARVAL function

VARVALTYPE function

CLEARFILE statement	CLOSE statement	DELETE statement
DELETELIST statement	GETLIST statement	MATREAD statement
MATREADU statement	MATWRITE statement	MATWRITEU statement
OPEN statement	POSITION statement	READ statement
READLIST statement	READNEXT statement	READPREV statement
READU statement	READV statement	READVU statement
SELECT statement	SELECTE statement	WRITE statement
WRITELIST statement	WRITEU statement	WRITEV statement
WRITEVU statement