BASIC
ABORT
ASSIGNMENT
BOOLEAN
BRANCHING
BSD
COMPILE.TIME
CONSTANT
DIMENSION
DYNAMIC
EQUATE
EXECUTE
IO
MATH
NLS
SQL
STRING
SYSTEM
TABLE
TAPE
TBD
TRANSACTION
TRANSFORM
PROC
BRANCHING
BUFFER
EXECUTE
TCL
ANALYSIS
IO
SYSTEM
| C | Index: C D F L M O R S U W | |
| CLEARFILE | Deletes all the records in a table's data section or dict section. | |
| CLOSE | Releases all locks related to a file variable. | |
| CLOSESEQ | Releases all locks associated with a sequential file variable. | |
| CREATE | Used with OPENSEQ to create new O/S files (Types 1 and 19). | |
| D | Index: C D F L M O R S U W | |
| DELETE | There are two delete commands. Both are explained here. | |
| DELETELIST | Removes a record from the &SAVESLISTS& table. | |
| DELETEU | This command acquires an update lock before deleting the record. | |
| F | Index: C D F L M O R S U W | |
| FILEINFO | Provides information about a file. | |
| FILELOCK | Locks an entire table. | |
| FILEUNLOCK | Releases a FILELOCK. | |
| FLUSH | Used with OPENSEQ to make sure all writes have completed. | |
| L | Index: C D F L M O R S U W | |
| LOCK | Allow for the locking of non-table related resources. | |
| M | Index: C D F L M O R S U W | |
| 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. | |
| O | Index: C D F L M O R S U W | |
| ON | Use ON as part of the GOSUB command or as part of the WRITE command. | |
| OPEN | OPEN establishes a file handle. | |
| OPENCHECK | OPENCHECK establishes an SQL file handle. | |
| OPENDEV | ||
| OPENPATH | ||
| OPENSEQ | ||
| R | Index: C D F L M O R S U W | |
| READ | Retrieves a record from the file and based on the record id | |
| READLIST | ||
| READNEXT | Gets a value (typically an ID) from a select list, then moves the pointer forward to the next value. | |
| READSEQ | ||
| 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 | |
| RECORDLOCKED | ||
| RECORDLOCKL | ||
| RECORDLOCKU | ||
| S | Index: C D F L M O R S U W | |
| SELECT | Creates a pointer to an unsorted list of Table IDs, suitable for use with READNEXT. | |
| U | Index: C D F L M O R S U W | |
| UNLOCK | Release a resource lock. | |
| W | Index: C D F L M O R S U W | |
| WEOFSEQ | W(rite) E(nd) O(f) F(ile) marker on a sequential file. | |
| WRITE | Writes record back to a database table. | |
| WRITELIST | ||
| WRITESEQ | ||
| WRITESEQF | ||
| WRITEU | Writes data back to the database. | |
| WRITEV | Writes one field back to a database table. | |
| WRITEVU | Writes field back to a database table. | |
