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