User Tools

Site Tools


basic_supported_commands_and_attributes.htm
Navigation:  ISAM File Drivers > Basic Database Driver >====== Basic:Supported Commands and Attributes ====== Previous pageReturn to chapter overviewNext page
File Attributes Supported
CREATE Y
DRIVER(filetype [,driver string]) Y
NAME Y
ENCRYPT N
OWNER(password) N
RECLAIM N
PRE(prefix) Y
BINDABLE Y
THREAD Y4
EXTERNAL(member) Y
DLL([flag]) Y
OEM Y
File Structures Supported
INDEX N
KEY N
MEMO N
BLOB N
RECORD Y
Index, Key, Memo, Attributes Supported
BINARY N
DUP N
NOCASE N
OPT N
PRIMARY N
NAME N
Ascending Components N
Descending Components N
Mixed Components N
Field Attributes Supported
DIM Y
OVER Y
NAME Y
File Procedures Supported
BOF(file) N
BUFFER(file) N
BUILD(file) N
BUILD(key) N
BUILD(index) N
BUILD(index, components) N
BUILD(index, components, filter) N
BYTES(file) Y5
CLOSE(file) Y
COPY(file, new file) Y
CREATE(file) Y
DUPLICATE(file) N
DUPLICATE(key) N
EMPTY(file) Y
EOF(file) Y
FLUSH(file) N
LOCK(file) Y
NAME(label) Y
OPEN(file, access mode) Y
PACK(file) N
POINTER(file) Y2
POINTER(key) N
POSITION(file) Y3
POSITION(key) N
RECORDS(file) N
RECORDS(key) N
REMOVE(file) Y
RENAME(file, new file) Y
SEND(file, message) Y
SHARE(file, access mode) Y
STATUS(file) Y
STREAM(file) N
UNLOCK(file) Y
Record Access Supported
ADD(file) Y
ADD(file, length) N
APPEND(file) Y
APPEND(file, length) N
DELETE(file) N
GET(file,key) N
GET(file, filepointer) Y
GET(file, filepointer, length) N
GET(key, keypointer) N
HOLD(file) N
NEXT(file) Y
NOMEMO(file) N
PREVIOUS(file) N
PUT(file) Y1
PUT(file, filepointer) Y1
PUT(file, filepointer, length) N
RELEASE(file) N
REGET(file,string) Y
REGET(key,string) N
RESET(file,string) Y
RESET(key,string) N
SET(file) Y
SET(file, key) N
SET(file, filepointer) Y
SET(key) N
SET(key, key) N
SET(key, keypointer) N
SET(key, key, filepointer) N
SKIP(file, count) N
WATCH(file) N
Transaction Processing Supported
LOGOUT(timeout, file, …, file) N
COMMIT N
ROLLBACK N
Null Data Processing Supported
NULL(field) N
SETNULL(field) N
SETNULL(file, field) N
SETNONNULL(field) N

Notes

1.When using PUT() with this driver you should take care to PUT back the same number of characters that were read. If you PUT back more characters than were read, then the “extra” characters will overwrite the first part of the subsequent record. If you PUT back fewer characters than were read, then only the first part of the retrieved record is overwritten, while the last part of the retrieved record remains as it was prior to the PUT().

2.POINTER() returns the relative byte position within the file.

3.POSITION(file) returns a STRING(4).

4.THREADed files consume additional file handles for each thread that accesses the file.

5.BYTES() returns the actual bytes read from the file. The size of the clipped RECORD may be different depending on the file driver and it's DRIVER() strings. With the ASCII or BASIC file drivers BYTES will include the ENDOFRECORD (typically 13,10) byte count, but these bytes are not in the RECORD. With the ASCII driver the /TAB driver string can affect (expand, change or remove) the tab (9) characters in the record buffer resulting in a different length.

basic_supported_commands_and_attributes.htm.txt · Last modified: 2021/04/15 15:56 by 127.0.0.1