Home page
Release Information
Reality on the Web
MultiValue Compatibility
Documentation Overview
Installation Guides
User's Reference
English Reference
DataBasic Reference
About this Section
Contents
References
Abbreviations and Conventions

Introduction to DataBasic
Compilation
Cataloging

DataBasic Elements
Program Elements
Multi-statement Line
Line Continuation
Identifiers
Statement Labels
Reserved Words
Comments
Blank Spaces and Lines
Program Storage
Naming a Program

Subroutines and External Functions
Internal Subroutine
External Subroutine
External Function

Including Common Code
Defining Code to be Automatically Included
Order of Included Code

Literals, Symbols and Variables
Numeric Literals
String Literals
Symbols
Variables

Assignments
Arithmetic Expressions
Precedence
Parentheses
Strings in Arithmetic Expressions
Examples

String Expressions and Concatenation
Substring Expression
Concatenation
Examples

Substring Extraction
Substring Assignment
Relational Expressions
Relational Operators
Arithmetic Relations
String Relations
Pattern Matching

Logical Expressions
Assignment Operators
Using the THEN/ELSE and ON ERROR Clauses
Syntax of THEN/ELSE
Syntax of ON ERROR Clause
Statements using THEN/ELSE
Statements using ON ERROR
Examples

Format Strings
Syntax
Operation
Examples of Format Strings

Conversions
Output Conversions
Input Conversions
Date Output Conversions
External to Internal Date Conversion
Mask Character Conversions
User Exit Conversions
TCL Commands that Modify Conversions

Execution and Item Locks
Execution Locks
Item Locks

Arrays
Dimensioned Arrays
Syntax
Dimensioning an Array
Accessing Array Elements
Using MATWRITE{U} and MATREAD{U}
Writing a Matrix to Disk

Dynamic Arrays
Syntax
Element Delimiters
Data Extraction and Replacement
Data Insertion and Deletion
Manipulating the contents of Dynamic Arrays
Dynamic Array Examples
Program Examples
Data Extraction Examples
Data Replacement Examples
Rules for Dynamic Array References

Dynamic Arrays vs. Dimensioned Arrays
Dynamic Arrays
Dimensioned Arrays
Rules of Usage

Using Indexes

Statements and Intrinsic Functions
Statements and Functions by Category
$CHAIN Statement
$DEFINE Statement
$IFDEF Statement
$IFNDEF Statement
$OPTIONS Statement
$UNDEFINE Statement
@ Function
A
ABORT Statement
ABS Function
ABSS Function
ACCEPT Statement
ACCESS Function
ACCESS Statement
ADDS Function
ALPHA Function
ANDS Function
ASCII Function
ASSIGN Statement

B
BCC Function
BITCHANGE Function
BITCHECK Function
BITLOAD Function
BITRESET Function
BITSET Function
BREAK Statement

C
CALL Statement
CASE Statement
CASING Statement
CATS Function
CHAIN Statement
CHANGE Function
CHAR Function
CHARS Function
CHECKSUM Function
CLEAR Statement
CLEARDATA Statement
CLEARFILE Statement
CLEARSELECT Statement
CLOSE Statement
CLOSESEQ Statement
COLLECTDATA Statement
COL1/COL2 Functions
COMMON Statement
COMPARE Function
COMPARE Statement
CONNECT Statement
CONVERT Function
CONVERT Statement
COS Function
COUNT Function
COUNTS Function
CRC Function
CRT Statement

D
DATA Statement
DATE Function
DCOUNT Function
DEBUG Statement
DECRYPT Function
DEFFUN Statement
DEL Statement
DELETE Function
DELETE Statement
DELETELIST Statement
DELETESEQ Statement
DIMENSION Statement
DISCONNECT Statement
DIVS Function
DOWNCASE Function
DQUOTE Function
DTX Function

E
EBCDIC Function
ECHO Statement
ENCRYPT Function
END Statement
ENTER Statement
EQS Function
EQUATE Statement
EXP Function
EXTRACT Function

F
FIELD Function
FIELDS Function
FILEINFO Function
FILEPATH Function
FIND Statement
FINDSTR Statement
FLUSH Statement
FMT Function
FOLD Function
FOOTING Statement
FOR Statement
FUNCTION Statement

G
GES Function
GETLIST Statement
GETMSG Function
GOSUB Statement
GOTO Statement
GROUP Function
GROUPSTORE Statement

H
HEADING Statement

I
ICONV Function
ICONVS Function
IF Statement
IFS Function
IN Statement
INCLUDE Statement
INDEX Function
INPUT Statement
INPUT CTRL Statement
INPUT@ Statement
INPUTCLEAR Statement
INPUTERROR Statement
INPUTNULL Statement
INPUTTRAP Statement
INS Statement
INSERT Function
INT Function

L
LEN Function
LENS Function
LES Function
LET Statement
LIMIT.INDEX Statement
LN Function
LOCATE Statement
LOCK Statement
LOOP Statement
LOWER Function

M
MAT Statement
MATBUILD Statement
MATPARSE Statement
MATREAD Statement
MATREADU Statement
MATWRITE Statement
MATWRITEU Statement
MAXIMUM Function
MINIMUM Function
MOD Function
MODS Function
MULS Function

N
NEGS Function
NES Function
NEXT Statement
NOT Function
NOTS Function
NULL Statement
NUM Function
NUMS Function

O
OCONV Function
OCONVS Function
ON GOSUB Statement
ON GOTO Statement
OPEN Statement
OPENSEQ Statement
ORS Function

P
PAGE Statement
PAUSE Statement
PERFORM Statement
POSITION Statement
PRECISION Statement
PRINT Statement
PRINTER Statement
PRINTERR Statement
PROCREAD Statement
PROCWRITE Statement
PROGRAM Statement
PROMPT Statement
PTR Function
PWR Function

R
RAISE Function
READ Statement
READBLK Statement
READLIST Statement
READNEXT Statement
READPREV Statement
READSEQ Statement
READT Statement
READU Statement
READV Statement
READVU Statement
RECEIVE Statement
RECORDLOCKED Function
RECWAIT Statement
RELEASE Statement
REM Function
REM Statement
REMOVE Statement
REPEAT Statement
REPLACE Function
RETURN Statement
REWIND Statement
RND Function
ROUND Function
RQM Statement
RTNDATA Statement

S
SEEK Statement
SELECT, SELECTE Statements
SELECTINFO Function
SEND Statement
SENTENCE Function
SEQ Function
SEQS Function
SIN Function
SLEEP Statement
SORT Function
SOUNDEX Function
SPACE Function
SPACES Function
SPLICE Function
SPOOLER Function
SQRT Function
SQUOTE Function
STOP Statement
STR Function
STRS Function
SUBROUTINE Statement
SUBS Function
SUM Function
SUMMATION Function
SYSTEM Function
SYSTEM Statement

T
TAN Function
TIME Function
TIMEDATE Function
TRANSABORT Statement
TRANSEND Statement
TRANSQUERY Function
TRANSTART Statement
TRIM/TRIMB/TRIMF Functions
TRUNC Function

U
UNASSIGNED Function
UNLOCK Statement
UNTIL Statement
UPCASE Function

V
VARTYPE Function
VARVAL Function
VARVALSET Statement
VARVALTYPE Function

W
WAKE Statement
WEOF Statement
WEOFSEQ Statement
WHILE Statement
WRITE Statement
WRITEBLK Statement
WRITELIST Statement
WRITESEQ Statement
WRITET Statement
WRITEU Statement
WRITEV Statement
WRITEVU Statement

X
XTD Function

Related TCL Commands
BASIC
BLIST
BREF
BVERIFY
CATALOG
CLEAR-BASIC-LOCKS
COMPILE
DB
DEBUG
DECAT
DELETE-CATALOG, DECATALOG
ECOPY
END
LOAD-BNF
NC.LIST
NC.RESET
PRINT-CATALOG
RUN

Programming in DataBasic
Programming Hints
Using System Delimiters
Cursor Positioning
Opening Files
Repeating Operations
Unknown Number of Values
Modifying a Program

Running a DataBasic Program in a Proc
Interprocess Communication
Sequential File Access
Embedded Basic Subroutines
How to Write an Embedded Basic Subroutine
Embedded Basic Examples
Debugging Embedded Basic Subroutines
How to Associate a Trigger with a File
Triggers Dos and Don’ts

Efficiency Guidelines
Internal Storage
Numeric Operations
Dynamic Arrays
File Open and Close
File Input and Output
Locking
PERFORM
Efficient Use of Subroutines and External Functions
Miscellaneous
Using the DataBasic Profiler

Programming Examples
INV-INQ Program Example
Area Program Example
Profits Program Example
Program Example Using Transactions
Program Examples using Interprocess Communication
ORDER Client/Server
FPUT Client/FGET Server
PERFORM Client/Server
TCP Client/Server
TCP Ping
TCP Email

DataBasic Development Program Example
DataBasic Real-time Run Program Example

The Debugger
Overview
Entering the Debugger
Nested Programs

Variables
Symbol Table
Enabling and Disabling the Debugger

Summary of Debugger Commands
$
/
?
@
A
B
D
DE{BUG}
E
END
G
K
L
LD
LP
M
N
OFF
P
PC
S
T
U
V
W
WF
WS
X
Z

Additional Information
Terminal Types
User Exit Conversions
Redefining User Exits
File I/O and IPC Error Codes
File I/O Error Codes
IPC Error Codes

Printer Independent Functions
Introduction to Printer Independence
Printer Independent Functions
Function Classes

Using Alternative Compilers
Overview
Procedure
Using the BASIC Command with the C option
Previous Releases

TCP Parameters
Port Numbers
Options

MultiValue Compatibility
Features that Depend on the Compatibility Mode
Reality Features with Additional Functionality
Additional Features
DataBasic Elements
Statement Labels
Predefined Symbols
Substring Extraction
Item Locks
Boolean Compiler Directives

Statements and Intrinsic Functions
$OPTIONS Statement
@ function
ASSIGNED Function
CHANGE Statement
CLEARINPUT Statement
CREATE Statement
DELETE Statement
DELETESEQ Statement
DISPLAY Statement
DIV Function
DQUOTE Statement
EQUATE Statement
EREPLACE Function
EXECUTE Statement
FIELD Function
FORMLIST Statement
GROUP Function
LEFT Function
MATPARSE Statement
MSLEEP Statement
OPENSEQ Statement
OUT Statement
QUOTE Function
READLIST Statement
READNEXT Statement
READPREV Statement
REMOVE Statement
RIGHT Function
SADD Function
SELECT Statement
SQUOTE Statement
SSUB Function
STATUS Function
SWAP Function
SYSTEM Function
TCLREAD Statement
TRANS Function
WRITE Statements

Compatibility Switch Matrix

Proc Reference
Editors
Resilience
SQL for Reality
UNIX-Connect
External Interfaces
Other Documents