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

Bitwise Logical

BITAND function	BITNAND function	BITNOR function
BITNOT function	BITOR function	BITXNOR function
BITXOR function

Branching

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

Compiler Directives

$CHAIN statement	$DEFINE statement	$IFDEF statement
$IFNDEF statement	$INCLUDE statement	$OPTIONS statement
$UNDEFINE statement

Conditional Compilation

$DEFINE statement	$IFDEF statement	$IFNDEF statement
$UNDEFINE 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

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

Dynamic Array Arithmetic Functions

ABSS function	ADDS function	DIVS function
MODS function	MULS function	NEGS function
SUBS function

Dynamic Array String Functions

CATS function	COUNTS function	FIELDS function
LENS function	NUMS function	SPACES function
SPLICE function	STRS function

Dynamic Array Character Functions

CHARS function

SEQS function

Dynamic Array Logical Functions

ANDS function	IFS function	NOTS function
ORS function

Dynamic Array Comparison Functions

EQS function	GES function	LES function
NES function

Dynamic Array String Formatting Functions

ICONVS function

OCONVS function

Email API

EM_ADD_ATTACHMENT function	EM_ADD_ATTACHMENT_ITEM function	EM_ADD_DELIVERY_DETAILS function
EM_ADD_AUTH_DETAILS function
EM_ADD_HTML_TEXT function	EM_ADD_PLAIN_TEXT function	EM_DEFINE_CONFIG function
EM_ENABLE_DEBUG function	EM_SEND_EMAIL function	EM_START_EMAIL function

 

Execution Locks

LOCK statement

UNLOCK statement

File I/O

See also Sequential File Access.

CLEARFILE statement	CLOSE statement	DELETE statement
DELETELIST statement	FILEINFO function	FILEPATH function
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

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

@ function	ASSIGN statement	BASIC.DUMP statement
BCC function	BREAK statement	CASING 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	ACCESS statement	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